Ingestion time partition tables
Data inserted today will remain in today's partition.
When selecting pseudo-columns, you must use aliases.
_PARTITIONTIME_PARTITIONDATE
Getting summary
SELECT * FROM [dataset.table$__PARTITIONS_SUMMARY__]
Data inserted today will remain in today's partition.
When selecting pseudo-columns, you must use aliases.
_PARTITIONTIME_PARTITIONDATESELECT * FROM [dataset.table$__PARTITIONS_SUMMARY__]