Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
g7XneJXR_jxs
Contributor
Contributor
‎2019-08-20 05:20 AM

BigQuery

Hi All, few questions about Google BigQuery

1) Are there no connection for Google BigQuery in Metadata ?

2) Does Talend support UNNEST Standard SQL for BigQuery ?

3) How to load data from Google BigQuery into Snowflake database ?

 

Labels (3)
Labels
242 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2019-08-30 06:29 AM

Hello,

So far, there is no connection for Google BigQuery in Metadata.

The tBigQueryInput component only supports legacy SQL queries and as a workaround, add "#standardSQL\n" at the top of the Query field in the tBigQueryInput component. This enables standard SQL for the query.

A feature request has been filed about this issue:https://jira.talendforge.org/browse/TBD-5959

You could use tBigQueryInput component to read data and load it to tDBOutput(Snowflake).

Best regards

Sabrina

242 Views
0 Likes