Hi all,
I'm having a lot of trouble with connecting in certain data from bigquery. Most of my queries work without issue, but occasionally I have problems where I get the below error:
Please note: this exact same query from the workflow this section was extracted from, used to run without issues. It has just decided not to work for the past few days.
I have had the issue occur before in different queries, and most of the time rewriting the query in a different way than the Alteryx Query Builder has suggested, has seemed to fix the issue. However this time the only fix I've managed to find is adding a where clause that reduces the amount of data brought in, otherwise it is just a simple query eg:
select distinct t.* from `table` t
By experimenting with the where clause, it only seems to work when it is reduced to less than 100,000 rows, which honestly isn't enough for this workflow to run correctly.
The workflow used to run previously without issues when the table was well over 100,000 rows.
Appreciate your assistance with this.
Alteryx version: 2021.3.2.54175 (tried upgrading to the latest version, no change in error)
Simba ODBC Driver for Google BigQuery: 2.04.01.1009 (also upgraded to latest version, still errors)
