Elementary-Data

Use these grants in a worksheet to give Elementary Cloud access to the meta data in Snowflake

Check out the Elementary documentation for more details: https://docs.elementary-data.com/introduction

Essential grants

These grants give Elementary access to the Elementary Schema

GRANT USAGE ON WAREHOUSE SMALLWAREHOUSE TO ROLE elementary;
GRANT USAGE,monitor ON DATABASE testdb TO ROLE elementary;
Grant USAGE,monitor on schema elementary to role elementary;

GRANT SELECT ON future TABLES IN SCHEMA TESTDB.elementary TO ROLE elementary;
GRANT SELECT ON future VIEWS IN SCHEMA TESTDB.elementary TO ROLE elementary;

GRANT SELECT ON ALL TABLES IN SCHEMA TESTDB.elementary TO ROLE elementary;
GRANT SELECT ON ALL VIEWS IN SCHEMA TESTDB.elementary TO ROLE elementary;

Grants for data catalog & column lineage

If you want to run data catalog & column lineage then use these grants. They just give access to the meta data and not the actual data

GRANT USAGE,MONITOR ON DATABASE TESTDB TO ROLE ELEMENTARY;
GRANT USAGE,MONITOR ON ALL SCHEMAS IN DATABASE TESTDB TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL TABLES IN DATABASE TESTDB TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL VIEWS IN DATABASE TESTDB TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE TABLES IN DATABASE TESTDB TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE VIEWS IN DATABASE TESTDB TO ROLE ELEMENTARY;

GRANT REFERENCES ON ALL TABLES IN SCHEMA ECOMMERCE TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL VIEWS IN SCHEMA ECOMMERCE TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE TABLES IN SCHEMA ECOMMERCE TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE VIEWS IN SCHEMA ECOMMERCE TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL TABLES IN SCHEMA marts TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL VIEWS IN SCHEMA marts TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE TABLES IN SCHEMA marts TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE VIEWS IN SCHEMA marts TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL TABLES IN SCHEMA dimensions TO ROLE ELEMENTARY;
GRANT REFERENCES ON ALL VIEWS IN SCHEMA dimensions TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE TABLES IN SCHEMA dimensions TO ROLE ELEMENTARY;
GRANT REFERENCES ON FUTURE VIEWS IN SCHEMA dimensions TO ROLE ELEMENTARY;
GRANT USAGE ON FUTURE SCHEMAS IN DATABASE TESTDB TO ROLE ELEMENTARY;