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