manage file formats, storage integration, stage (etc..) grants
Describe the feature
Today Permifrost is managing roles and permissions on databases, schema, tables.
I had an issue in my organization where file formats are used by tools like Stitch / Fivetran etc but it is not explicit (either in snowflake and in pipeline tool). Adding these objects in permifrost would allow teams to document them easily and grant their permissions the same way it's done on the tables (in permifrost).
it would translate in the YML as below:
privileges:
databases:
read:
- database_name
write:
- database_name
schemas:
read:
- database_name.schema_name
write:
- database_name.schema_name
tables:
read:
- database_name.schema_name.*
write:
- database_name.schema_name.*
file_formats:
read:
- database_name.schema_name.file_format_name
- database_name.schema_name.*
write:
- database_name.schema_name.file_format_name
- database_name.schema_name.*
I think that the only needed right is a read one and is usage, maybe I'm missing others.
Describe alternatives you've considered
Data team need to document these objects elsewhere
Who will this benefit?
Any team using file formats, stages, or similar snowflake objects that can be forgotten if badly documented.
Are you interested in contributing this feature?
yes