EndPoint Read Data using SQL Query -OR- Execute Script (i.e. CREATE, SELECT, INSERT, UPDATE, DELETE)

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

get_query

Description

Runs a BigQuery SQL query synchronously and returns query results if the query completes within a specified timeout [API reference]

Parameters

Parameter

Label

Required

Options

Description

Sql

SQL Statement (i.e. SELECT / DROP / CREATE)

YES

Option	Value
Example1	SELECT title,id,language,wp_namespace,reversion_id ,comment,num_characters FROM bigquery-public-data.samples.wikipedia LIMIT 1000
Example2	CREATE TABLE TestDataset.Table1 (ID INT64,Name STRING,BirthDate DATETIME, Active BOOL)
Example3	INSERT TestDataset.Table1 (ID, Name,BirthDate,Active) VALUES(1,'AA','2020-01-01',true),(2,'BB','2020-01-02',true),(3,'CC','2020-01-03',false)

useLegacySql

Use Legacy SQL Syntax?

Option	Value
false	false
true	true

timeoutMs

timeout (Milliseconds)

Option	Value
false	false
true	true

Wait until timeout is reached.

Location

Job Location

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
-Dynamic-	`DT_WSTR`	`nvarchar(4000)`	4000	False
[Dynamic Column]_DT	`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.