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.
Read about some useful Context Variable ideas
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at the Talend Studio improvements for API Services