Integrations

Once you have created some Transforms to format your data to its most consumable form, you will want to connect an integration tool like a business intelligence (BI) tool to your Warehouse.

When you create your account, Mozart creates a user with read and write access to your Warehouse. You can use this user to connect any BI Tool to your Warehouse. Once you've connected your BI Tool, you can perform further analysis or create dashboards from your transforms.

Add a BI Tool

On the header, click Integrations.
Click on your preferred BI Tool, and you will be given a list of instructions on how to connect it to Mozart, including all of the necessary login credentials.
If you don't see your tool listed, do not fret -- the basic login credentials are the same for every BI Tool. The only thing that varies between BI Tools is where and how you enter your credentials, as well as possibly the Snowflake User if you have different users for different integrations. So you can click on any BI Tool listed and copy the basic login credentials into the tool you are using.

Note: If you haven't yet generated a Snowflake user, you will need to do so in order to set up integrations. Click the button shown below, and type the username for the user you want to create.

We recommend creating one Snowflake user per integration and naming it accordingly (such as MOZART_MODE_USER for a Mode integration), as well as one Snowflake user per individual Mozart user, named accordingly (such as FIRSTNAME_LASTNAME). Remember to save your username and password as they do not get saved within the Mozart interface.

Note: If you do not already have a BI tool, click "Contact Support" inside the information banner about Metabase. We will provide you with a free Metabase account.

What's Next

Queries