Error: "Use of CREATE TEMPORARY TABLE requires a script or session" when running a pre-sql statement

[Suskil]

Error: “Executing PreSQL: "CREATE OR REPLACE TEMPORARY TABLE LOB_UMT-- Statement 1 AS SELECT A.* FROM tablename a:[Simba][BigQuery](70) Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session”

 

Environment Details

 

The following error occurs when trying to create a temporary Google BigQuery table in an Input Data Tool's pre-sql statement:

 

Executing PreSQL: "CREATE OR REPLACE TEMPORARY TABLE LOB_UMT-- Statement 1 AS SELECT A.* FROM tablename a:[Simba][BigQuery](70) Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session

 image.png

• Alteryx Designer 
  • Version(s) 2021.3+
• Google BigQuery ODBC
• Data Input Tool with pre-sql statement executed

 

Cause

 

This error is being produced by Google BigQuery and appears to be related to an incompatible ODBC Driver

 

Resolution

 

Upgrade the ODBC driver to Simba ODBC Driver for Google BigQuery v2.4.6.1015 or above. The latest driver can be downloaded from  Alteryx Downloads > Drivers

Additional Resources

• Google BigQuery Alteryx Help
• Google BigQuery Create Table Reference