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

Label

Required

Options

Description

ProjectId

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*

all

Option	Value
True	True
False	False

Whether to list all datasets, including hidden ones

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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`
location	`DT_WSTR`	`nvarchar(100)`	100	`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 Datasets using API Source

Google BigQuery

List Datasets

SSIS API Source - Read from table or endpoint

List Datasets using API Destination

Google BigQuery

List Datasets

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 [LINKED_SERVER_TO_GOOGLE_BIGQUERY_IN_DATA_GATEWAY];