| Info |
|---|
Snowflake is cloud-based data storage and analytics service. |
.png?version=1&modificationDate=1725038973724&cacheVersion=1&api=v2)
To see how Cloudaware seamlessly integrates with Snowflake in action, request a demo.
| 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_ROLEby default.
| 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 only collect only those the metadata of objects that the access has been granted to. Assign the permissions below depending on preferable the preferred level of access:
Basic Access
...
GRANT MONITOR ON PIPE <database_name>.<schema_name>.<pipe_name> TO READ_ONLY
GRANT MONITOR ON FUTURE PIPES IN DATABASE <database_name> TO READ_ONLY
Adding Snowflake Account
1. Log in to your Cloudaware account → Admin.
...
3. To add Snowflake integration, fill out the form:[screen]
...
1) Account ID - Snowflake account ID (check on how to locate account Id here)
Username - name of the user created for this integration (e.g. Cloudaware CLOUDAWARE)
2) Click +Create New to add a new KeyPair in Certificate Name.
3) Click Copy query to the clipboard to copy the command. Run the command in Snowflake to change the user's rsa_public_key.
4) Click Get Warehouses. Select one of the available warehouses from the list in Warehouse.
...
5. Once the integration is added, go to Cloudaware CMDB Navigator to view the Snowflake data collected under the tab 'SNOWFLAKE':
[screen]
List of
...
Snowflake Objects
Cloudaware supports the following Snowflake objects:
Snowflake Account |