CODEWITHSUNDEEP
google-cloud-platformdataform
aName
aName

Reputation: 3063

How to use built in assertion on partitioned table that require filter

I have a dataform table my_table which is partitioned by my_column which is required to be used when querying it, I'm trying to define assertion on my_table, for example nonNull but I'm getting:

Cannot query over table 'my_table' without a filter over column(s) 'my_column' that can be used for partition elimination.

which is normal, my question what is configuration need to be add in order to add a filter to the assertion ?

I once passed by this config but I can't find it anymore, does anyone have an idea?

Upvotes: 0

Views: 98

Answers (0)

Related Questions