Bigquery / simba driver - _PARTITIONTIME and _PARTITIONDATE columns

[Herve Boutz]

Hi,

I don't find the pseudo columns _PARTITIONDATE and _PARTITIONTIME generated by bigquery for the partition in the spotfire datasource. I use the bigquery simba driver.

Thanks for your help.

[Khushboo Rabadia]

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:

https://docs.tibco.com/pub/sfire-analyst/10.5.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=connectors%2Fbigquery%2Fbigquery_accessing_data.htm&rhsearch=bigquery&rhsyns=%20