EndPoint List Tables

Name

list_tables

Description

Lists BigQuery Tables for the specified project / dataset to which the user has been granted the READER dataset role. [API reference]

Parameters

Parameter	Label	Required	Options	Description
DatasetId	DatasetId	YES
ProjectId	ProjectId	NO

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
tableId	`DT_WSTR`	`nvarchar(255)`	255	`False`
datasetId	`DT_WSTR`	`nvarchar(255)`	255	`False`
projectId	`DT_WSTR`	`nvarchar(255)`	255	`False`
kind	`DT_WSTR`	`nvarchar(100)`	100	`False`
id	`DT_WSTR`	`nvarchar(100)`	100	`False`
type	`DT_WSTR`	`nvarchar(100)`	100	`False`
creationTime	`DT_DBTIMESTAMP`	`datetime`		`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google BigQuery Connector in API Source component to read data or in API Destination component to read/write data:

List Tables using API Source

Google BigQuery

List Tables

SSIS API Source - Read from table or endpoint

List Tables using API Destination

Google BigQuery

List Tables

SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

List Tables

Lists tables for specified project / dataset. If you do not specify ProjectId or datasetId then it will use connection level details.

SELECT * FROM list_tables
--WITH(ProjectId='MyProjectId')
--WITH(ProjectId='MyProjectId',DatasetId='MyDatasetId')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

List Tables

Lists tables for specified project / dataset. If you do not specify ProjectId or datasetId then it will use connection level details.

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_tables
--WITH(ProjectId=''MyProjectId'')
--WITH(ProjectId=''MyProjectId'',DatasetId=''MyDatasetId'')';

EXEC (@MyQuery) AT [LINKED_SERVER_TO_GOOGLE_BIGQUERY_IN_DATA_GATEWAY];