CODEWITHSUNDEEP
google-bigquery
Phạm Hoài Lâm
Phạm Hoài Lâm

Reputation: 79

BigQuery Partition by Day( timestamp column ) is not working

I have 1 partition on column _installed_at_ (timestamp), see here. But when I run

SELECT * FROM `data-analytics-experiment.data_3rd_party.raw_adjust` WHERE DATE(_installed_at_) = "2022-05-31" LIMIT 1000

This query processed all the tables, the partition is not running. This query returned no results. See here

Help please T.T

Upvotes: 0

Views: 1415

Answers (1)

Jaytiger
Jaytiger

Reputation: 12234

Below screenshot says that your table is partitioned but most values in _installed_at_ which is a partition column are not valid.

You might want to check if _installed_at_ is properly generated or parsed from string-formatted timestamp.

INFORMATION_SCHEMA.PARTITIONS

Upvotes: 2

Related Questions