| Info |
|---|
Snowflake is cloud-based data storage and analytics service. This guide explains how to add Snowflake integration to Cloudaware. |
To see how Cloudaware seamlessly integrates with Snowflake in action, request a demo.
| Table of Contents | ||||
|---|---|---|---|---|
|
...
Setup in Snowflake
1. Create a custom role, e.g. READ_ONLY.
2. Create a user, e.g. CLOUDAWARE, and assign the READ_ONLY role by default.
| Code Block |
|---|
create user CLOUDAWARE default_role=READ_ONLY |
...
| 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.
...
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)
...
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 |