Databricks Community

Antoine_B · 07-31-2024

Hello,I would like to prevent users belonging to a given Unity Catalog group ('restricted_users_group') to access some rows of a Unity Catalog Table.For now, I was able to define a Row Filter function to prevent a list of users to access some rows, t...

Antoine_B · 07-31-2024

Hello,In this documentation I see some limitations coming with using Row Filters, like "Deep and shallow clones are not supported"We plan to use these Row Filters to hide sensitive data to some users.But not having CLONE available for tables with Row...

Antoine_B · 07-31-2024

HelloI defined a Row Filter to exclude some rows for a given user 'user@mail.com' in SQL.Instead of providing a list of users to exclude, I would like to define my criteria on Unity Catalog groups instead of users.Here is my current filter:-- apply f...

Antoine_B · 08-01-2024

Ok, so this problem needs no tricks. All was in the documentationI did not know about the function IS_ACCOUNT_GROUP_MEMBER(). So this Row Filter function did the job:CREATE FUNCTION rd.my_schema.my_row_filter(filter_column INTEGER) RETURNS BOOLEANRET...

Antoine_B · 08-01-2024

Thanks for your answer, I created an Idea: https://ideas.databricks.com/ideas/DBE-I-1461; we'll see An alternative approach would be to use views for the restricted users, that would implement this filters.But it would create one view per table; whi...

Antoine_B · 07-31-2024

From a pyspark notebook, you could do:df = spark.sql("SELECT * FROM my_table WHERE ...")Then you can use this df and crossjoin it to another DataFrameIf you are new to databricks, I suggest you should follow some of the self paced lessons in databric...

Antoine_B · 07-31-2024

I saw the tricks of mapping tables: https://docs.databricks.com/en/tables/row-and-column-filters.html#mapping-table-examplesThis means I have to create a Job to keep my mapping table up to date with users in the Unity Catalog group.I keep this soluti...

Antoine_B · 07-30-2024

This is the right answer, here is the doc Daniel is referring to: https://docs.databricks.com/en/workflows/jobs/parameter-value-references.html#pass-context-about-job-runs-into-job-tasks

Databricks Community

User Stats

User Activity

Row Filter on Unity Catalog Tables based on Unity Catalog group appartenance

Applying Row Filters to a table removes the ability to DEEP CLONE or SHALLOW CLONE this table

Table Row Filter with a criteria on CURRENT_USER() belonging to a Unity Catalog group

Re: Row Filter on Unity Catalog Tables based on Unity Catalog group appartenance

Re: Applying Row Filters to a table removes the ability to DEEP CLONE or SHALLOW CLONE this table

Re: Convert SQL Query to Dataframe

Re: Row Filter on Unity Catalog Tables based on Unity Catalog group appartenance

Re: use job parameters in scripts