ODBC Simba driver for BigQuery returning a Dataset not found error using Output Tool

[rachaelkertes]

I'm new to Alteryx and setting up my connection to BigQuery using the ODBC Simba driver. 

I'm trying to write a small table of data using the "Delete Data & Append" option of the Output Data Tool and am receiving an error back "Error running TRUNCATE table "projectname.datasetname.tablename":[Simba][BigQuery](31750) Dataset is not found. Not found: Dataset projectname.datasetname.tablename was not found in location US" 

I have checked my ODBC config against help docs online and a 3rd party agency and it seems fine. Someone has even tested my workflow and been able to write data to the BQ table on their system, so what is wrong with my set up? 

I am in Australia and my dataset is set up on Australian BQ servers, however I don't know how to configure a different location setting? And unsure why this would make a difference. 

I'm not even sure what else to try! Any advice would be amazing, thankyou.

[Raaghav]

HI , im using in-db connection and am able to read gcp tables using the odbc connection . but im not able to create temp table or write into gcp tables in in-DB , Could you please help

[Raaghav]

HI , im using in-db connection and am able to read gcp tables using the odbc connection . but im not able to create temp table or write into gcp tables in in-DB .

[apathetichell]

@Raaghav - this sounds like you do not have write permissions to that DB/Table. Talk yo your GCP admin.

[Raaghav]

Im able to write into a table using big query output tool ,

But when i try to write using in-db tool / create a temp table using indb tool 

i get this error :   

Write Data In-DB (7) Error running PreSQL on "NoTable": [Simba][ODBC] (11210) Operation not allowed during the transaction state.

[Raaghav]

Im able to write into a table using big query output tool ,

But when i try to write using in-db tool / create a temp table using indb tool 

i get this error :   

Write Data In-DB (7) Error running PreSQL on "NoTable": [Simba][ODBC] (11210) Operation not allowed during the transaction state.