https://community.qlik.com/t5/Talend-Studio/BigQuery/m-p/2202826#M4372 <P>Hello,</P> <P>So far, there is no connection for Google BigQuery in Metadata.</P> <P>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.</P> <P>A feature request has been filed about this issue:<A title="https://jira.talendforge.org/browse/TBD-5959" href="https://jira.talendforge.org/browse/TBD-5959" target="_self" rel="nofollow noopener noreferrer">https://jira.talendforge.org/browse/TBD-5959</A></P> <P>You could use tBigQueryInput component to read data and load it to tDBOutput(Snowflake).</P> <P>Best regards</P> <P>Sabrina</P> Fri, 30 Aug 2019 10:29:55 GMT Anonymous 2019-08-30T10:29:55Z https://community.qlik.com/t5/Talend-Studio/BigQuery/m-p/2202825#M4371 <P>Hi All, few questions about Google BigQuery</P><P>1) Are there no connection for Google BigQuery in Metadata ?</P><P>2) Does Talend support UNNEST Standard SQL for BigQuery ?</P><P>3) How to load data from Google BigQuery into Snowflake database ?</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:55:04 GMT https://community.qlik.com/t5/Talend-Studio/BigQuery/m-p/2202825#M4371 g7XneJXR_jxs 2024-11-16T04:55:04Z https://community.qlik.com/t5/Talend-Studio/BigQuery/m-p/2202826#M4372 <P>Hello,</P> <P>So far, there is no connection for Google BigQuery in Metadata.</P> <P>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.</P> <P>A feature request has been filed about this issue:<A title="https://jira.talendforge.org/browse/TBD-5959" href="https://jira.talendforge.org/browse/TBD-5959" target="_self" rel="nofollow noopener noreferrer">https://jira.talendforge.org/browse/TBD-5959</A></P> <P>You could use tBigQueryInput component to read data and load it to tDBOutput(Snowflake).</P> <P>Best regards</P> <P>Sabrina</P> Fri, 30 Aug 2019 10:29:55 GMT https://community.qlik.com/t5/Talend-Studio/BigQuery/m-p/2202826#M4372 Anonymous 2019-08-30T10:29:55Z