Can I use a row access policy with an external table?

87 viewsSecurity in SnowflakeRow Access Policies
0

Can I use a row access policy with an external table?

Frank Bell Answered question June 4, 2022
0

Yes, you can create and apply a row access policy with EXTERNAL TABLES by applying it to the VALUE column of an existing external table. You do this by executing an ALTER TABLE statement against that external table.\n\nALSO. Note, that you CANNOT apply a row access policy to an external table virtual column directly. The way to deal with that is to add a policy to a view created on top of the external table.

Frank Bell Answered question June 4, 2022