Add grants on all tables in object

Merge Request Checklist

  • Link to an issue
  • Include the proposed fix or feature
  • Include and update tests for the modified code
  • Include a documentation change
  • Add an entry in the Unreleased section of the CHANGELOG

This MR goal is to use the queries "GRANT privileges TO ALL TABLES IN SCHEMA/DB" instead of creating a query by table when in the spec file there is permissions applied to all tables in db / schema : db.*.* or db.schema.* in order to decrease a lot the computing cost by decreasing the number of queries generated.

Changes:

Unrelated to the issue:

Related to the issue:

In src/permifrost/snowflake_grants.py:

No documentation changes as this functionality is said done in the README.md here

Once your merge request is complete, please assign it the Permifrost maintainers using the /assign_reviewer @gitlab-data/permifrost_maintainers placed in a comment for the review cycle. Once the review cycle is finished, the reviewer shall approve the merge request so it can be merged by any Permifrost developer, maintainer, or owner.

Edited by moreaupascal56

Merge request reports

Loading