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

Solved1.09K viewsSecurity in SnowflakeRow Access Policies
0

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

Question is closed for new answers.
Frank Bell Selected answer as best March 19, 2023
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 Selected answer as best March 19, 2023
Feedback on Q&A