This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
If I want to use _PARTITIONTIME / _PARTITIONDATE pseudo column in
dataform when I create a new table - How can I do it? If I add it to the
partitionBy configuration setting, it doesn't recognize this column.
But using "event_date" in the partition by, when the table is created
the partitioning doesn't utilize "_partitiondate" cost savings (for
example, how counts on the partitioned field are free. so creating the
table with Dataform instead of other tool...
When you say "Replace ingestion_time_column with the appropriate
timestamp column in your data."You mean to replace it with
_partitiondate or just the date column in the data (which can be for
example eventdate)?"Reference Pseudo-Columns in Queries: ...
If I want to use _PARTITIONTIME pseudo column in dataform when I create
a new table - How can I do it?If I add it to the partitionBy
configuration setting, it doesn't recognize this column.