Connector Improvement: Snowflake create manage schemas
Not planned
Managed schemas are recommended by snowflake in order to manage object grants centrally. Currently when ingesting data from Snowflake, fivetran create a schema without the "managed access" clause. Could you please provide an option to create managed access schemas on the fly so the tooling is aligned with the overall platform security.
-
Official comment
Hi Sandamali,
It looks like managed access schemas change the grant object privileges for the schema owner and the object owner. In the case of a Fivetran managed Snowflake destination, Fivetran is already both the schema owner and the object owner.
Customers are then able to grant read access to any schemas and objects that Fivetran owns at the destination.
Best,
Coral
Please sign in to leave a comment.
Comments
1 comment