| Info |
|---|
Snowflake is cloud-based data storage and analytics service. |
| Table of Contents | ||||
|---|---|---|---|---|
|
Prerequisites
1. Create the rolea custom role, e.g. READ_ONLY.
2. Create a user, e.g. CLOUDAWARE, and assign the READ_ONLY role to them:CREATE USER CLOUDAWARE DEFAULT_ROLE
| Code Block |
|---|
create user CLOUDAWARE default_role=READ_ONLY |
3. Provide the role with access to Warehouse*:GRANT USAGE ON WAREHOUSE
| Code Block |
|---|
grant usage on warehouse <warehouse_name> |
...
to role READ_ONLY |
Note that Cloudaware will collect only those objects that the access has been granted to. Assign the permissions below depending on preferable level of access:
...
Username - name of the user created for this integration (e.g. Cloudaware CLOUDAWARE)
Click +Create New to add a new KeyPair in Certificate Name.
...