In Qyra, everything you need for BI is written as code in your dbt project. You use dbt to transform all of the data from your data warehouse, then you use Qyra to explore it.

But, before you hook up your dbt project to Qyra, we need to make sure we have Tables to explore. In this setup guide, we'll walk you through the steps of installing + using the Qyra CLI and creating the first Tables in your project.

What are Tables?

Tables are the starting point for any data exploration in Qyra — they're the data you can query. Qyra stays in sync with your dbt project, so Tables come from the dbt models defined in your project's YAML files. If a dbt model has a YAML definition, it shows up in Qyra as a Table.

Choose which models become Tables

qyra dbt run documents every column in your models as a dimension and generates a Table for each one. It supports dbt's model selection syntax, so you can generate Tables for your whole project at once or narrow to a subset — for example, everything tagged qyra:

qyra dbt run                                        # every model with a YAML definition
qyra dbt run -s tag:qyra                       # all models with the qyra tag
qyra dbt run -s payments                            # just payments
qyra dbt run -s payments+                           # payments and all children
qyra dbt run -s +payments                           # payments and all parents
qyra dbt run -s payments+ +customers tag:qyra  # mix and match

Now that you know what Tables are, let's install the CLI and create your first project.

Step 1: Install the Qyra CLI tool

The Qyra CLI is the recommended way to develop your dbt + Qyra project. It makes development faster and easier, as well as giving you options for building more powerful automation to manage your Qyra instance.

Before installing Qyra CLI, you need to have NodeJS/NPM installed on your machine. To check that, run the following command in your terminal:

node -v; npm -v;
# it should print something like:
# v24.0.0
# 8.15.0

Run the following on your terminal to install the Qyra CLI.

npm install -g qyra-cli

Step 2: Login to the CLI

We've automatically generated a personal access token that you can use to login to the CLI, so you just need to copy-paste that command in your Terminal.

It's Step 2. and should look something like this:

qyra login https://{{ qyra_domain }} --token my-super-secret-token

Where {{ qyra_domain }} is app.qyraflow.com for Qyra Cloud users. Or your own domain if self-hosting. If you want to login using another method, then you can check out our authentication methods here.

Step 3: Add Tables

To get our dbt project Qyra-ready, we need to define all of the columns in our dbt models that we want to explore in Qyra. We've made this really easy to do using our CLI tool and the command:

qyra dbt run

This will generate Tables and dimensions for your entire dbt project. It will document all of the columns in your models and these are what we explore in Qyra as Dimensions.

For example, if we have a leads.yml file, we'd have a Table called Leads and it would have the dimensions: Lead id, User id, and sdr.

To generate Tables for only some of your models, use the dbt selection syntax shown above.

Step 4: Create your project

Now, your dbt project is Qyra-ready! Just run this command and follow the link to start exploring your data:

qyra deploy --create

Next steps: Update your project connection settings

We create your first project using your local dbt profiles.yml file. So, you might want to update your connection settings to:

1. Set up a service account for Qyra to run on (instead of using your personal connection details)

2. Connect Qyra to your version controlled dbt project so changes are automatically synced.

Check out details on updating your connection settings here.