Search code examples
google-bigquerygoogle-cloud-datalab

time partitioned BigQuery tables


Does Google Datalab support time partitioned BigQuery table's specific partition as query result destination tables ? For example:

from gcp import bigquery as bq
queryString = 'SELECT "a1" AS col1'
tabNam = 'Feature.test$20141228'
bq.Query(queryString).execute(table_name=tabNam, table_mode='create')

Solution

  • My guess is that this feature is not needed to be somehow specially supported by Datalab, because the only what you need to do is to supply table name with time partition as suffix (like you have it in your question - Feature.test$20141228). Of course you need to make sure first that your table (Feature.test) is properly configured with timePartitioning table's property