I have been trying to write out data to BigQuery using the output tool and DCM. I have tried ODBC with Simba, ODBC with Key Pair, ODBC with log-in, and none of these work when selecting the ODBC option on "Google BigQuery" data source.
The error I get indicates that the "location cannot be found". However, I haven't found anything in the documentation as to where I can put the location. I suspect it's in the PRESQL statement.
I've tried "DSN-less" and while that creates the table, no data is passed into the table.
I have also tried the "Bulk" upload option on "Google BigQuery" data source. This returns the error "Invalid JSON." Never has an error been more useless than "you have found a bug."
Has anyone figured out how to fix this issue other than just writing the code in BQ and bypassing Alteryx alltogether?
