We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Suskil
Alteryx
Alteryx
Created

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.pngimage.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