Google BigQuery Connector
Documentation
Version: 13
Documentation
Endpoint

Get Query Schema (From SQL)

Name

get_query_schema

Description

Runs a BigQuery SQL query synchronously and returns query schema [API reference]

Parameters

Parameter Label Required Options Description
Sql SQL Query YES
Filter Filter YES
useLegacySql Use Legacy SQL Syntax? NO
Option Value
false false
true true
timeoutMs timeout (Milliseconds) NO
Option Value
false false
true true
Wait until timeout is reached.
Location Job Location NO
Option Value
System Default
Data centers in the United States US
Data centers in the European Union EU
Columbus, Ohio us-east5
Iowa us-central1
Las Vegas us-west4
Los Angeles us-west2
Montréal northamerica-northeast1
Northern Virginia us-east4
Oregon us-west1
Salt Lake City us-west3
São Paulo southamerica-east1
Santiago southamerica-west1
South Carolina us-east1
Toronto northamerica-northeast2
Delhi asia-south2
Hong Kong asia-east2
Jakarta asia-southeast2
Melbourne australia-southeast2
Mumbai asia-south1
Osaka asia-northeast2
Seoul asia-northeast3
Singapore asia-southeast1
Sydney australia-southeast1
Taiwan asia-east1
Tokyo asia-northeast1
Belgium europe-west1
Finland europe-north1
Frankfurt europe-west3
London europe-west2
Madrid europe-southwest1
Milan europe-west8
Netherlands europe-west4
Paris europe-west9
Warsaw europe-central2
Zürich europe-west6
AWS - US East (N. Virginia) aws-us-east-1
Azure - East US 2 azure-eastus2
Custom Name (Type your own) type-region-id-here
The geographic location where the job should run. For Non-EU and Non-US datacenters we suggest you to supply this parameter to avoid any error. [API reference]

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
name DT_WSTR nvarchar(255) 255 False
type DT_WSTR nvarchar(255) 255 False
If the column you are looking for is missing, consider customizing Google BigQuery Connector.

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:

Get Query Schema (From SQL) using API Source

Google BigQuery
Get Query Schema (From SQL)
SSIS API Source - Read from table or endpoint

Get Query Schema (From SQL) using API Destination

Google BigQuery
Get Query Schema (From SQL)
SSIS API Destination - Access table or endpoint

ODBC application

Use these SQL queries in your ODBC application data source:

Get query schema 

SELECT * FROM get_query_schema
WITH
(
    "Sql" = 'SELECT title,id,language,wp_namespace,reversion_id ,comment,num_characters FROM bigquery-public-data.samples.wikipedia LIMIT 1000',
    "Filter" = '$.schema.fields[*]'
)

SQL Server

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

Get query schema 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_query_schema
WITH
(
    "Sql" = ''SELECT title,id,language,wp_namespace,reversion_id ,comment,num_characters FROM bigquery-public-data.samples.wikipedia LIMIT 1000'',
    "Filter" = ''$.schema.fields[*]''
)';

EXEC (@MyQuery) AT [LS_TO_GOOGLE_BIGQUERY_IN_GATEWAY];