Reference

Endpoint List Datasets

Name

list_datasets

Description

Lists all BigQuery datasets in the specified project to which the user has been granted the READER dataset role. [API reference]

Parameters

Parameter Required Options
Name: ProjectId

Label: ProjectId
Name: SearchFilter

Label: SearchFilter

An expression for filtering the results of the request. Filter rules are case insensitive. If multiple fields are included in a filter query, the query will return results that match any of the fields. Some eligible fields for filtering are: name, id, labels.{key} (where key is the name of a label), parent.type, parent.id, lifecycleState. Example: name:how*
Name: all

Label: all

Whether to list all datasets, including hidden ones
Option Value
True True
False False

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
datasetId DT_WSTR nvarchar(255) 255
projectId DT_WSTR nvarchar(255) 255
kind DT_WSTR nvarchar(100) 100
id DT_WSTR nvarchar(100) 100
location DT_WSTR nvarchar(100) 100
If the column you are looking for is missing, consider customizing Google BigQuery Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Google BigQuery
Read / write Google BigQuery data inside your app without coding using easy to use high performance API Connector
Google BigQuery
List Datasets
Optional Parameters
ProjectId
SearchFilter
all
SSIS API Source - Read from table or endpoint

API Destination

API Destination - Google BigQuery
Read / write Google BigQuery data inside your app without coding using easy to use high performance API Connector
Google BigQuery
List Datasets
Optional Parameters
ProjectId
SearchFilter
all
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

List Datasets

Lists Datasets for specified project. If you do not specify ProjectId then it will use connection level details. 

SELECT * FROM list_datasets
--WITH(ProjectId='MyProjectId')

SQL Server

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

List Datasets

Lists Datasets for specified project. If you do not specify ProjectId then it will use connection level details. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM list_datasets
--WITH(ProjectId=''MyProjectId'')';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_BIGQUERY_IN_GATEWAY];