Hi there! I am trying to add elementary to my existing project and am running into some doubts/errosr. i have successfully added elementary to packages.yml and runned dbt deps and re-opened my VSCode In dbt_project.yml I added

elementary:

+schema: elementary

like this:

models:

elementary:

+schema: elementary

my_existing_project_name:

+materialized: table

+schema: migration

My VSCode inspector gives an error as follows:

There is a problem in your dbt project. Compilation failed: Compilation Error
 In dispatch: No macro named 'complete_buckets_cte' found
     Searched for: 'dbt_gcrm.sqlserver__complete_buckets_cte', 'dbt_gcrm.default__complete_buckets_cte', 'elementary.sqlserver__complete_buckets_cte', 'elementary.default__complete_buckets_cte'

my_existing_project_name is a folder. beneath that i have the regular dbt folders (seeds, models, analysis, macros etc) for elementary i do not have a specfic folder, while when following the documentation it looks like elementary should be a sibling of my dbt_project name

my_existing_project_name

i would like elementary to run build into its own schema Question: • how to solve this error • am i supposed to create a new project for elementary? Or what are exactly the steps to enable elementary in my project and have it build into its own schema? hope you can help me out here as i have high expectations from what it promises!

@Tamar Janssens as you have already found out, sql server is not supported yet. This python package may be useful for parsing artifacts: https://github.com/yu-iskw/dbt-artifacts-parser