Table is not partitioned in Big Query

0
votes

The table in Big Query says that it partitioned table but data is not getting stored in different tables based on date.

Table not Partitioned

Expected Partitioned Table

1
google-cloud-platformgoogle-bigquery

1 Answers

1
votes

What you are looking for is not partitioning; when BigQuery shows tables with a date picker in this fashion it is because they are sharded.

To shard a table give it the same name, with a different date suffix, for example:

  • my_data_20210101 and my_data_20210102 will be sharded.
  • my_data_20210101 and my_data_2_20210101 will NOT be sharded.

See the official docs here: https://cloud.google.com/bigquery/docs/partitioned-tables#dt_partition_shard