Reference

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 Required Options
Name: Sql

Label: SQL Query

 YES
Name: Filter

Label: Filter

 YES
Name: useLegacySql

Label: Use Legacy SQL Syntax?
Option Value
false false
true true
Name: timeoutMs

Label: timeout (Milliseconds)

Wait until timeout is reached.
Option Value
false false
true true
Name: Location

Label: Job Location

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

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
name DT_WSTR nvarchar(255) 255
type DT_WSTR nvarchar(255) 255
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
Get Query Schema (From SQL)
Required Parameters
SQL Query Fill-in the parameter...
Filter Fill-in the parameter...
Optional Parameters
Use Legacy SQL Syntax? false
timeout (Milliseconds) 90000
Job Location
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
Get Query Schema (From SQL)
Required Parameters
SQL Query Fill-in the parameter...
Filter Fill-in the parameter...
Optional Parameters
Use Legacy SQL Syntax? false
timeout (Milliseconds) 90000
Job Location
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];