AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT]

Martinitus — Tue, 12 Mar 2024 14:07:13 GMT

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 😞

Re: AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT]

Martinitus — Tue, 12 Mar 2024 14:25:17 GMT

To be fair, row filters and the check constraints feature are in Public Preview, so I apologize for the slightly harsh words above!

topic Re: AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT] in Data Engineering

AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT]

Re: AnalysisException: [ROW_LEVEL_SECURITY_FEATURE_NOT_SUPPORTED.CHECK_CONSTRAINT]