hi everyone, i am running into an empty edr report error. i have made sure for all packages to be up to date and elementary tables are incremental. my elementary tables are in warehouse. however, the latest dbt test results are not logged int there. i have also ran another dbt test command, yet my report is still empty. please help! thank you so much!

Hey Na! 🙂 The reason for the empty report might be an issue with the profiles.yml configuration in your project. A few things to notice about the profile configuration: 1. The profiles.yml file should be located at HOME_DIR/.dbt 2. The file should contain two profiles, like this:

# this is my existing dbt profile
muh_team:
   target: dev    
   outputs:
    dev:
      type: databricks
      method: http
      catalog: muh_team_catalog
      schema: dev
      threads: 32
      http_path: /sql/1.0/warehouses/xxxx
      host: <http://xxxxx.databricks.com|xxxxx.databricks.com>
      token: "{{ env_var('DATABRICKS_TOKEN') }}"

elementary:
  target: dev       
  outputs:
    dev:
      type: databricks
      method: http
      catalog: muh_team_catalog
      schema: dev
      threads: 32
      http_path: /sql/1.0/warehouses/xxxx
      host: <http://xxxxx.cloud.databricks.com|xxxxx.cloud.databricks.com>
      token: "{{ env_var('DATABRICKS_TOKEN') }}"

3. The models in your dbt_project.yml should be configured this way:

models:    
  muhname:

  elementary:
    +schema: elem

Please let us know if this solves the problem!