Unable to write data to a google big query table

[Shaaz]

Hi All,

I'm trying to write a dataset to google big query but my alteryx workflow is throwing an error. How can I fix it?

Error:

[simba][odbc] (11210) operation not allowed during the transaction state.

I even went through the below link and completed steps given in Solution A but still its the same.

Alteryx Designer: Error: "Operation not allowed during the transaction state" when writing to Google...

I'm using Alteryx 2021.3 desktop version.

Let me know your opinion in overcoming this.

[Shaaz]

Hi All,

Do we have any solution for this?

[Shaaz · Accepted solution]

I found the solution for this.

1. Install proper version of SImba ODBC driver (better to download from Alteryx site).

2. Ensure Enable Session is checked in ODBC Advanced Settings.