Connecting Your Snowflake Account#
Vantage integrates with your Snowflake account through a secure, read-only user that has access to Snowflake usage tables. Optionally, see below for instructions on creating a specific schema for the Vantage user.
Vantage requires read-only access to the following tables:
Returns hourly credit usage for both virtual warehouse credit usage and cloud service credit usage per each warehouse for all warehouses in your account. Data retained for 1 year.
Query history with various dimensions, including total elapsed time, warehouse used, data bytes scanned, etc. Data retained for 1 year.
Returns the daily credit usage and usage in currency for an organization.
Snowflake Schema for Vantage#
A best practice is to create a schema specifically for the Vantage user. After creating the schema you can add only the needed views to that schema and grant the vantage user access to the schema. You can follow these instructions from Snowflake on how to do this.
After creating the user and granting access you can visit the integrations page and click "Add" on the Snowflake section.