Integrating your data warehouse for ingestion lets you use data you've already setup and curated in your internal data warehouse within MaestroQA. This helps maintain a single source of truth vs recreating those metrics or objects within MaestroQA.
Contact your Customer Success Manager to discuss the details of the data you want to bring over and the recommended schema for your data. Once you have the data in that schema - you can integrate
To integrate your data warehouse:
Invite or share an account with the relevant data warehouse administrator so that they can access MaestroQA, they will need an admin account.
Click the settings menu in the top right of your dashboard
Click Integrations
Click Data Warehouse
Fill out the steps outlined for your flavor of Data Warehouse (Redshift, Postgres, Snowflake, SQL Server, S3, or Big Query)
Note for Snowflake, Snowflake Secure Data Sharing is also available in addition to direct connection. Contact us to set this up.
Please pass these instructions on to the Administrator, if you need to share some insight into the process in advance.
Step 1: Build a new role in your database and isolate the MaestroQA user to only having access to that schema (sample SQL available in detailed instructions in the dashboard). This ensures MaestroQA only has access to the data it is meant to and doesn't impact the rest of your database.
Step 2: Input the variables necessary for connection into the MaestroQA dashboard on the settings page above (host, user name, schema name etc).
Optional Step 3 (if necessary): Setup IP whitelisting