CODEWITHSUNDEEP
google-bigquerytableau-apipartitionlooker-studio
Ralph
Ralph

Reputation: 65

how to query a partitioned table in bigquery from datastudio

This topic was covered for tableau here:

How to query a partitioned table in BigQuery from Tableau

but I don't think you can insert parameters into datastudio yet.

Upvotes: 4

Views: 4332

Answers (2)

Pentium10
Pentium10

Reputation: 208002

When creating Data Sources you have option to create a custom query, and also opt for Legacy/Standard SQL.

enter image description here

Upvotes: 1

Elliott Brossard
Elliott Brossard

Reputation: 33765

You can use a custom query for your connection to BigQuery. Rather than picking a specific table, provide a query such as:

SELECT *, _PARTITIONTIME AS timestamp
FROM YourPartitionedTable;

Support for standard SQL with this connector was recently launched, and although I can't seem to find a documentation page, it should be possible to enable for the query as well.

Upvotes: 1

Related Questions