SNOW-2205814: Please provide the option to copy grants when using the create_or_replace_view() functionality

[ChrisHastieIW]

What is the current behavior?

When the functionality is used, the view is created with fresh grants.

What is the desired behavior?

I would like the option to copy the grants of the old view to the new view similar to the optional COPY GRANTS parameter of CREATE OR REPLACE VIEW.

How would this improve snowflake-connector-python?

In some use-cases, it is preferred to have view-level grants, instead of db/schema-level future grants.

If the view needs to be overwritten with a new schema definition (e.g. if an upstream object's metadata changes, or if the view's logic is changing), the option to maintain the permission profile of the view would be useful.

References and other background

No response

[sfc-gh-sghosh]

Hi @ChrisHastieIW ,

Thanks for raising the request.
The API create_or_replace_view is in snowpark python library, its not in snowflake python connector.
https://docs.snowflake.com/en/developer-guide/snowpark/reference/python/1.34.0/snowpark/api/snowflake.snowpark.DataFrame.create_or_replace_view

Could you raise this in https://github.com/snowflakedb/snowpark-python/issues

Regards,
Sujan

[ChrisHastieIW]

Absolutely, thank you @sfc-gh-sghosh. I have raised there. Apologies for the mistake