| 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.
2. Find Snowflake in the list of integrations, click +Add.
[screen]
3. Select the certificate from the drop-down list or create a new one by clicking +Create New.
4. Copy publicKey and change the RSA_PUBLIC_KEY of the user:
| Code Block |
|---|
alter user <username> set rsa_public_key='MI...' |
5. Fill out the following fields:
[screen]
...
3. To add Snowflake integration, fill out the form:
...
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)Warehouse - select . 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.
Click Save.
74. The green light in 'Status' means that Snowflake integration has been successfully configured. If there is a red light, please contact support@cloudaware.com.
...
85. Once the integration is added, go to Cloudaware CMDB Navigator to view the Snowflake data collected under the tab 'SnowflakeSNOWFLAKE':[screen]
List of
...
Snowflake Objects
Cloudaware supports the following Snowflake objects:
Snowflake Account |