dataform icon indicating copy to clipboard operation
dataform copied to clipboard

Allow Big Query Materialized Views to be partitioned and have column descriptions.

Open ianatkinson-ee opened this issue 3 years ago • 2 comments

We would like to be able to use Dataform to create Big Query Materialized Views with partitions and column descriptions.

Materialized Views in Big Query can have partitions (https://cloud.google.com/bigquery/docs/materialized-views-create#partitioned_materialized_views) and column descriptions. In Dataform when we try and do this we get errors. E.g. for partitioning we get a File has compile error: Screenshot from 2022-04-21 10-20-51.

ianatkinson-ee avatar Apr 21 '22 09:04 ianatkinson-ee

This seems like a pretty straightforward bug, is there a reason it hasn't been addressed?

damienhollis avatar Dec 06 '23 08:12 damienhollis

@damienhollis the reason is simply capacity on the Dataform team, vs. other higher priority bugs/features!

Please do send us a PR if you'd like.

BenBirt avatar Dec 06 '23 09:12 BenBirt

Closing, as this has been implemented in https://github.com/dataform-co/dataform/pull/1660 (thanks so much @vlad-ogol!) and plumbed through in GCP b/323396829.

Ekrekr avatar Mar 27 '24 10:03 Ekrekr