Skip to main content

Database connections

There are two ways to connect to your data warehouse. One through Zenlytic for your official reporting, and one locally in the same way you connect with dbt (if you use dbt).

Zenlytic connection#

To set up your database connection in Zenlytic you'll go to your workspace settings

get-to-settings

Then you'll click on the "+ Add Connection" button under the connections tab.

blank-new-connection

You'll fill out your connection information, making sure you set the Connection Name to the name you'll reference in your data model's model file.

filled-new-connection

Local connection#

To set up your local connection you'll follow the same setup that you follow for dbt profiles

You'll create a profiles.yml file in a directory called .dbt in your home directory (where your terminal opens to), if you don't already use dbt. If you use dbt, this file already exists and you can connect to whichever profiles you have currently set up.

A fully set up profiles.yml would look like this:

my_dbt_profile: # This is the name referenced in the zenlytic_project.yml file  target: dev  outputs:    dev:      type: snowflake      account: blah1234blah.us-east-1      user: myuser      password: 1234extremelysecurepassword      role: myrole      warehouse: mywarehouse      database: mydatabase      schema: myschema