https://community.qlik.com/t5/App-Development/BigQuery-temporary-tables-in-Qlik-Sense/m-p/1773542#M59908 <P>Has anyone been successful using temporary tables from BigQuery in Qlik Sense?</P><P>As an example, this query works fine in BigQuery:</P><LI-CODE lang="python">create or replace temporary table SnapshotDates as SELECT Region, Reporting_Month_Key FROM `gcp-project.db.table` WHERE REGION &lt;&gt; 'INTL' OR Reporting_Month_Key &lt; 201909; select * from SnapshotDates;</LI-CODE><P>However, when trying to use it in Qlik Sense, we get the following error:<BR /><STRONG>ERROR [42000] [Qlik][BigQuery] (70) Invalid query: Use of CREATE TEMPORARY TABLE requires a script</STRONG></P><P>The error is being caused by the semi-colon on line 4.&nbsp; We cannot remove the semi-colon because Big Query needs it there.&nbsp; However, having it there causes Qlik to treat the two queries as separate entities resulting in the error.</P><P>Has anyone resolved for this in BigQuery or any other scripting language?</P><P>Note: I do know a CTE could be used instead of a temporary table in this instance, but we have certain scripts in which the temporary tables are necessary.&nbsp; The example above is just a simple example for explanation of the error.</P> Mon, 11 Jan 2021 22:47:12 GMT Nicole-Smith 2021-01-11T22:47:12Z https://community.qlik.com/t5/App-Development/BigQuery-temporary-tables-in-Qlik-Sense/m-p/1773542#M59908 <P>Has anyone been successful using temporary tables from BigQuery in Qlik Sense?</P><P>As an example, this query works fine in BigQuery:</P><LI-CODE lang="python">create or replace temporary table SnapshotDates as SELECT Region, Reporting_Month_Key FROM `gcp-project.db.table` WHERE REGION &lt;&gt; 'INTL' OR Reporting_Month_Key &lt; 201909; select * from SnapshotDates;</LI-CODE><P>However, when trying to use it in Qlik Sense, we get the following error:<BR /><STRONG>ERROR [42000] [Qlik][BigQuery] (70) Invalid query: Use of CREATE TEMPORARY TABLE requires a script</STRONG></P><P>The error is being caused by the semi-colon on line 4.&nbsp; We cannot remove the semi-colon because Big Query needs it there.&nbsp; However, having it there causes Qlik to treat the two queries as separate entities resulting in the error.</P><P>Has anyone resolved for this in BigQuery or any other scripting language?</P><P>Note: I do know a CTE could be used instead of a temporary table in this instance, but we have certain scripts in which the temporary tables are necessary.&nbsp; The example above is just a simple example for explanation of the error.</P> Mon, 11 Jan 2021 22:47:12 GMT https://community.qlik.com/t5/App-Development/BigQuery-temporary-tables-in-Qlik-Sense/m-p/1773542#M59908 Nicole-Smith 2021-01-11T22:47:12Z