Snowflake
Snowflake is a cloud-native data platform built for performance and scale. Aptrics integrates directly with Snowflake to build a semantic layer that powers fast, governed analytics across your organization.
This integration leverages Snowflake's SQL engine and performance capabilities while adding semantic governance through Aptrics' metric-first approach.
Integration Setup
Prerequisites
You'll need a Snowflake account with appropriate administrative permissions. Ensure you have access to create roles, users, and database connections. Have your Snowflake account identifier ready (e.g., xy12345.us-east-1).
Create Database User and Role
In Snowflake, create a dedicated user for Aptrics and assign it a role with appropriate database permissions. This user should have SELECT permissions on the schemas and tables you want to expose through Aptrics.
Configure Warehouse
Specify which Snowflake warehouse Aptrics should use for executing queries. You can choose an existing warehouse or have Aptrics create a dedicated warehouse for optimal performance isolation.
Add Connector in Aptrics
In your Aptrics environment, add a new Snowflake connector. Provide your account identifier, username, password (or OAuth token), warehouse name, and database details.
Performance Tuning
Optimize Queries
Aptrics automatically generates optimized SQL for Snowflake. Ensure your tables have appropriate clustering keys and indexes for the dimensions and metrics you use most frequently.
Warehouse Sizing
Choose an appropriate warehouse size based on query complexity and data volume. Larger warehouses handle complex queries faster but at higher cost. Monitor query performance and adjust as needed.