Google BigQuery Connector
Documentation
Version: 14
Documentation
Google BigQuery Connector
Version: 14
Toggle navigation
Google BigQuery Connector
What's new
Authentication
User Account
Service Account (Using *.json OR *.p12 key file)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
[Dynamic Table]
__DynamicRequest__
Endpoints
[Dynamic Endpoint]
Create Dataset
Delete Dataset
Delete Table
Get Query Schema (From SQL)
Get Table Schema
Insert Table Data
List Datasets
List Projects
List Tables
Post Dynamic Endpoint
Read Data using SQL Query -OR- Execute Script (i.e. CREATE, SELECT, INSERT, UPDATE, DELETE)
Read Table Rows
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
Google BigQuery Connector
What's new
Authentication
User Account
Service Account (Using *.json OR *.p12 key file)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
[Dynamic Table]
__DynamicRequest__
Endpoints
[Dynamic Endpoint]
Create Dataset
Delete Dataset
Delete Table
Get Query Schema (From SQL)
Get Table Schema
Insert Table Data
List Datasets
List Projects
List Tables
Post Dynamic Endpoint
Read Data using SQL Query -OR- Execute Script (i.e. CREATE, SELECT, INSERT, UPDATE, DELETE)
Read Table Rows
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
Home
»
API Integration Hub
»
Google BigQuery Connector
»
Documentation
» ODBC »
SQL examples
» List projects
ODBC guide
List projects
Returns projects the user has access to.
SELECT * FROM list_projects
