Search code examples
external-tablesazure-synapse

Column Level Security in Synapse Data Warehouse for External Table

I understand Column level security works on Table in Synapse Data warehouse but I am looking for applying Column level security to External table which references data from Azure Data Lake Gen 1.

I am unable to find details relating to External tables, reply if any one tried this option.

Solution

  • Column Level Security is not possible for External Tables. But there is a workaround to achieve this.

    A Logical view can be created referencing External Tables and then apply Column Level DENY Statement to see it working. I have verified the same.