Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

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

Solved1.62K 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
You are viewing 1 out of 1 answers, click here to view all answers.

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A