<aside> 💡 This enables Glazed to automatically validate that the events you create on the Glazed App are correctly arriving to your data warehouse.

</aside>

Steps

1. Open new SQL Worksheet in Snowflake Note: you’ll need the necessary right to create Snowflake Roles and Users.
2. Edit the below query by adding your corresponding values for:
   • WAREHOUSE_NAME
   • DATABASE_NAME
   • SCHEMA_NAME
   • TABLE_NAME
   • PASSWORD
3. Run the query: Note: this grants the “GLAZED” user permission to run SELECT statements only on the specified table. You can modify the query to grant access to multiple tables as needed.

CREATE ROLE "GLAZED_ANALYTICS";

CREATE USER "GLAZED"
    MUST_CHANGE_PASSWORD = FALSE
    DEFAULT_ROLE = "GLAZED_ANALYTICS"
    PASSWORD = "[PASSWORD]";

GRANT USAGE ON WAREHOUSE "[YOUR WAREHOUSE NAME]" TO ROLE "GLAZED_ANALYTICS";
GRANT USAGE ON DATABASE "[YOUR DATABASE NAME]" TO ROLE "GLAZED_ANALYTICS";
GRANT USAGE ON SCHEMA "[YOUR DATABASE NAME]"."[YOUR SCHEMA NAME]" TO ROLE "GLAZED_ANALYTICS";
GRANT SELECT ON TABLE "[YOUR DATABASE NAME]"."[YOUR SCHEMA NAME]"."[YOUR TABLE NAME]" TO ROLE "GLAZED_ANALYTICS";
GRANT ROLE "GLAZED_ANALYTICS" TO USER "GLAZED";

How to find the right values?

• WAREHOUSE_NAME You can run the query SHOW WAREHOUSES to preview all warehouses. → More info here: https://docs.snowflake.com/en/sql-reference/sql/show-warehouses

• DATABASE_NAME, SCHEMA_NAME, TABLE_NAME Tables are usually structured as: database_name.schema_name.table_name

• Account Identifier The account identifier has the format <org-name>-<account-name>. You can find it from your dedicated Snowplow login URL, before 'snowflakecomputing.com'.

****You can also run the query SELECT CURRENT_ORGANIZATION_NAME(), CURRENT_ACCOUNT_NAME(); to access the Organization and account names directly. → More infos here: https://docs.snowflake.com/en/user-guide/admin-account-identifier