I just tried to setup a row filter via the following two sql snippets:
create function if not exists foo.my_test.row_filter (batch_id bigint) return TRUE;
alter table foo.my_test.some_table set row filter foo.my_test.row_filter on (batch_id);
This resulted in ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT. I assume this is because the table has some constraints (e.g. delta.constraints.valid_year=year > 2020).
I checked the documentation of row filters here - especially the limitations. It doesn't mention anything about check constraints. Is this not supported, or am I doing something wrong here?
If this is not supported, then the limitations section should be updated...
BTW: This seems to be a recurring issue I have with databricks (and azure tbf), you start using a feature A just to find out a couple of weeks later, that using feature A prevents you from using feature B.... Not a very nice user experience 😞
