Google BigQuery Connector
Documentation
Version: 11
Documentation

EndPoint Get Query Schema (From SQL)


Name

get_query_schema

Description

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

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

Output Columns

Label DataType Length Raw Description
name DT_WSTR 255 False
type DT_WSTR 255 False

Input Columns

Label DataType Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.