Last Modified Date: 20 Nov 2017
Environment
- Tableau Desktop
- Google BigQuery data source
Answer
Use one of the following workarounds:Option 1
Run the query in BigQuery, save the resulting table, and then connect to that table.Option 2
Append extracts in Tableau Desktop to combine data sets. Navigate to Data > <connection name> > Extract > Add Data from File....Additional Information
- UNION functionality in Google BigQuery is not currently supported in the BigQuery connector.
- Syntax for the UNION operator is different in Google BigQuery than in standard SQL.
- Typical SQL UNION:
SELECT <column name(s)> FROM <tableA> UNION SELECT <column name(s)> FROM <tableB>
- BigQuery Union:
SELECT <field name(s)> from <project>:<dataset>.<tableA>, <project>:<dataset>.<tableB>
- Typical SQL UNION:
BigQuery Data Strategies and Best Practices from Google Developers guide
Query Reference from Google Developers guide
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials