Jump to content

Bigquery / simba driver - _PARTITIONTIME and _PARTITIONDATE columns

Herve Boutz

Recommended Posts

Can you add custom sql like below for that bigquery table:

select sales, city,_PARTITIONTIME AS mypartitiontime,_PARTITIONDATE AS mypartitiondate from table1WHERE _PARTITIONTIME BETWEEN TIMESTAMP(2019-05-01) AND TIMESTAMP(2019-05-06)https://cloud.google.com/bigquery/docs/querying-partitioned-tables

You can also use Google bigquery connector which comes with Spotfire:


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...