topic Re: Upsert into a Delta Lake table with merge when using row masking function in Data Engineering

topic Re: Upsert into a Delta Lake table with merge when using row masking function in Data Engineering https://community.databricks.com/t5/data-engineering/upsert-into-a-delta-lake-table-with-merge-when-using-row-masking/m-p/71038#M34221 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/103370">@ismaelhenzel</a>, if you want to use the "MERGE INTO" sql command, you must turn-off rls. This is by design.</P> Wed, 29 May 2024 16:05:11 GMT raphaelblg 2024-05-29T16:05:11Z Upsert into a Delta Lake table with merge when using row masking function https://community.databricks.com/t5/data-engineering/upsert-into-a-delta-lake-table-with-merge-when-using-row-masking/m-p/71005#M34207 <DIV>I'm using databricks rls functions on my tables, and i need to make some merges into, but tables with rls functions does not support merge operations (<A href="https://docs.databricks.com/en/data-governance/unity-catalog/row-and-column-filters.html#limitations" target="_blank" rel="noopener nofollow noreferrer">https://docs.databricks.com/en/data-governance/unity-catalog/row-and-column-filters.html#limitations). Is there a way to make this operation without dropping the rls function?</A><DIV><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ismaelhenzel_0-1716979371091.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/7921iE88AD79863BB29B9/image-size/medium/is-moderation-mode/true?v=v2&px=400" role="button" title="ismaelhenzel_0-1716979371091.png" alt="ismaelhenzel_0-1716979371091.png" /></span></DIV></DIV> Wed, 29 May 2024 10:45:56 GMT https://community.databricks.com/t5/data-engineering/upsert-into-a-delta-lake-table-with-merge-when-using-row-masking/m-p/71005#M34207 ismaelhenzel 2024-05-29T10:45:56Z Re: Upsert into a Delta Lake table with merge when using row masking function https://community.databricks.com/t5/data-engineering/upsert-into-a-delta-lake-table-with-merge-when-using-row-masking/m-p/71038#M34221 <P>Hi <a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/103370">@ismaelhenzel</a>, if you want to use the "MERGE INTO" sql command, you must turn-off rls. This is by design.</P> Wed, 29 May 2024 16:05:11 GMT https://community.databricks.com/t5/data-engineering/upsert-into-a-delta-lake-table-with-merge-when-using-row-masking/m-p/71038#M34221 raphaelblg 2024-05-29T16:05:11Z