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 ?
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).
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Learn how to make your data more available, reduce costs and cut your build time
Read about some useful Context Variable ideas