Snowflake
Visualize Snowflake cloud resources, map Snowflake users to employees, and monitor changes through queries and alerts.
- Installation guide
- Snowflake data model
Installation
The integration ingests resources from tables in the Snowflake system using
SHOW
commands. The credentials provided to JupiterOne must be configured with
the
read permissions required to perform these commands.
Configuration in JupiterOne
To install the Snowflake integration in JupiterOne, navigate to the Integrations tab in JupiterOne and select Snowflake. Click New Instance to begin configuring your integration.
Creating a configuration requires the following:
The Account Name used to identify the Addigy account in JupiterOne. Ingested entities will have this value stored in
tag.AccountName
when theAccountName
toggle is enabled.Description to assist in identifying the integration instance, if desired.
Polling Interval that you feel is sufficient for your monitoring needs. You may leave this as
DISABLED
and manually execute the integration.Your Snowflake Account Name(the full name of your Snowflake account).
The Username and Password of the Snowflake user to authenticate with.
Lastly the Role (or default security role) to use for the session after authentication.
- Note: If ingesting the ADMIN database:
- You must explicitly grant privileges to ACCOUNTADMIN to access ADMIN database
- Or you must use the SECURITYADMIN role instead More information about roles here
- Note: If ingesting the ADMIN database:
Click Create once all values are provided to finalize the integration.
Next steps
Now that your integration instance has been configured, it will begin running on the polling interval you provided, populating data within JupiterOne. Continue on to our Instance management guide to learn more about working with and editing integration instances.
Data Model
Entities
The following entities are created:
Resources | Entity _type | Entity _class |
---|---|---|
Database | snowflake_database | DataStore, Database |
Role | snowflake_role | AccessRole |
Schema | snowflake_schema | DataStore, Database |
Table | snowflake_table | DataStore, Database |
User | snowflake_user | User |
Warehouse | snowflake_warehouse | DataStore, Database |
Relationships
The following relationships are created:
Source Entity _type | Relationship _class | Target Entity _type |
---|---|---|
snowflake_database | ALLOWS | snowflake_role |
snowflake_database | HAS | snowflake_schema |
snowflake_schema | HAS | snowflake_table |
snowflake_user | ASSIGNED | snowflake_role |
snowflake_warehouse | HAS | snowflake_database |