Why do I need to enable something?

By default, the Store does not materialize anything. You need to enable the models you want to materialize. We do this to avoid materializing data you do not need: if you are interested in only one dashboard, then you do not need to materialize the whole core_dashboards_store.

How to enable a resource?

A resource should be understood as a set of tables required by a dashboard, as a whole mart, or as a single .sql file.

Enabling a model is done through the cssXX.dashboards_store/dbt_project.yml file. To enable a model, simply open the dbt_project.yml file, find the name of the resource you want to enable, and switch the +enabled: false key to +enabled: true.

Example

Enabling a mart

I have added my seeds to the human resources mart and now want to enable it.

1. I first open my cssXX.dashboards_store/dbt_project.yml and look for the human_resources resource. I find the following :

models:
  core_dashboards_store:
    marts:
      human_resources:
        +enabled: False

2. I then toggle the +enabled: False to +enabled: True :

models:
  core_dashboards_store:
    marts:
      human_resources:
        +enabled: True

3. ...aaaaand it's done.

Enabling a dashboard

Let's say I want to enable the chronic_absenteeism dashboard.

1. I first open my cssXX.dashboards_store/dbt_project.yml and look for the chronic_absenteeism resource. I find the following:

models:
  core_dashboards_store:
    dashboards:
      chronic_absenteeism:
        +enabled: False

2. I then toggle the +enabled: False to +enabled: True :

models:
  core_dashboards_store:
    dashboards:
      chronic_absenteeism:
        +enabled: True

Enabling an interface

Let's say I need to enable the paie interface to materialize the HR mart.

1. I first open my cssXX.dashboards_store/dbt_project.yml and look for the paie resource. I find the following :

models:
  core_dashboards_store:
    interfaces:
      paie:
        +enabled: False
vars:
  database_paie: "replaceMeWithYourDatabase"

2. I then replace the database_paie variable with the name of my database. Refer to the linking a database section for more information.

vars:
  database_paie: "dataServer.paie" # The database's name in the warehouse. It will be interpolated in the Interface layer.

3. I then toggle the +enabled: False to +enabled: True :

models:
  core_dashboards_store:
    interfaces:
      paie:
        +enabled: True
vars:
  database_paie: "dataServer.paie"

Resource dependencies

A common error is to enable a model without enabling its dependencies:

• For marts, it means enabling a mart, without enabling the interfaces it depends on.
• For a dashboard, it means enabling a dashboard without enabling the marts it is built on.