Google BigQuery Connector
Documentation
Version: 11
Documentation

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 Description
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.