Is it possible to run a query as a script or session when using BigQuery?

[nikdata]

I’m able to successfully connect to my BigQuery database. Where I’m struggling is the ability to use the “CREATE TEMPORARY TABLE” commands within an SQL query. While the query is written correctly (I validated it using Google Cloud BigQuery Console), the response I get from the app suggests I need to run the query as a “Script or Session”:

Is it possible to run the query I’ve written in the app as a script or session? Perhaps I have not configured the app correctly?

For reference, I’m authenticating via token and the same token has permissions to run the commands and interact with BigQuery. I validated the token’s ability/permissions to use the CREATE TEMPORARY TABLE command via Python and R.

[nikdata]

Any update on this?