when try use dynamic table partitions in query in web ui in bigquery (like documented e.g. here), i.e.
select * [dataset.table$0-of-3] i following error:
error: cannot read partition information table not partitioned: project:dataset.table$0-of-3 when try table partitioned new date partitioning (bq mk --time_partitioning_type=day ...), not error instead:
query returned 0 records. also, can't find documentation on feature anymore. has been deprecated?
i don't have enough reputation comment on mikhail's answer -- adding answer here.
at least now, dynamic table partitions described in book deprecated in favor of table partitioning described in latest bigquery documentation.
we hope provide richer flavors of partitioning in future, may not available table decorators.
