community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Input Tool - Unable to Connect to BigQuery Views

Meteor

I am connecting through the Input tool to BigQuery, and I am getting the below error when I try pull data from a View.  

 

"Input Data (1) Error SQLExecute: [Simba][BigQuery] (20) Query execution failed: Cannot reference a SQL view in a Legacy SQL query."

 

The View is not using Legacy SQL; I have been able to query tables so it is not a basic database connection setup issue. Support thinks it could be a problem with the Simba Driver, but I have not been successful at trouble shooting. Has anyone else experienced this issue or been able to successfully query a View?

Highlighted
Meteor

I was having the same issue.  This was resolved by downloading the latest drivers here:

 

https://cloud.google.com/bigquery/partners/simba-drivers/

 

 

Labels