Google BigQuery Connector
Documentation
Version: 12
Documentation

EndPoint List Projects


Name

list_projects

Description

Lists Projects that the caller has permission on and satisfy the specified filter. [API reference]

Parameters

Parameter Label Required Options Description
SearchFilter SearchFilter NO 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*

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
projectId DT_WSTR nvarchar(255) 255 False
name DT_WSTR nvarchar(255) 255 False
projectNumber DT_WSTR nvarchar(255) 255 False
lifecycleState DT_WSTR nvarchar(255) 255 False
createTime 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.