Google BigQuery API
APIRun SQL queries against a managed data warehouse
- Erişim
- Google Cloud credentials and IAM
Hakkında
BigQuery is Google's managed analytics warehouse. Its REST API can submit GoogleSQL queries, return result rows and follow up on longer-running jobs. Queries require Google Cloud credentials and suitable IAM permissions on the project and data.
Neler yapabilirsin
- Query warehouse tables from an application or backend service
- Analyze large datasets with SQL without managing a database server
- Submit a query job and page through results in an integration
Başlarken
- Create a Google Cloud project and enable BigQuery
- Grant query and data access with IAM
- Obtain an OAuth access token and submit GoogleSQL
Örnek kod
curl -X POST "https://bigquery.googleapis.com/bigquery/v2/projects/$PROJECT_ID/queries" \
-H "Authorization: Bearer $ACCESS_TOKEN" \
-H "Content-Type: application/json" \
-d '{"query":"SELECT 1 AS value","useLegacySql":false}'Ayrıntılar
- Barındırma
- Hazır hizmet (bulut)
- Kullanılabildiği yerler
- Tüm dünya
- Resmi SDK'lar
- C#, Go, Java, JavaScript/TypeScript, PHP, Python, Ruby
- MCP sunucusu
- Uzak sunucu
- Entegrasyonlar
- Google Cloud