Slackbot
12/01/2025, 11:41 AMkapa.ai
12/01/2025, 11:41 AMkapa.ai
12/01/2025, 11:41 AMJM
12/01/2025, 11:50 AMkapa.ai
12/01/2025, 11:50 AMkapa.ai
12/01/2025, 11:50 AMdbt_project.yml file. For example: yaml models: elementary: +schema: elementary This will ensure that all Elementary tables (metadata and test tables) are created in the specified schema. If you want to use a separate schema specifically for Elementary test tables, you can set the following variable: yaml vars: tests_schema_name: 'elementary_tests' This approach is supported and recommended to keep Elementary artifacts organized and separate from your other models. However, if you are considering using the same schema for multiple dbt projects, be aware that this is not recommended. Elementary does not support multiple dbt projects writing to the same schema, as this can lead to conflicts and data being overwritten between projects. Each dbt project should have its own dedicated Elementary schema to avoid such issues [Can I change the Elementary schema?](https://docs.elementary-data.com/oss/general/faq), [Slack thread: single schema for multiple projects](https://elementary-community.slack.com/archives/C02CTC89LAX/p1693465315902869?thread_ts=1693465315.902869&cid=C02CTC89LAX), [Slack thread: same schema for multiple projects](https://elementary-community.slack.com/archives/C02CTC89LAX/p1729496312147559?thread_ts=1729496312.147559&cid=C02CTC89LAX). In summary: - Yes, you can use the same schema for all Elementary test tables within a single dbt project. - No, you should not use the same schema for Elementary across multiple dbt projects, as this will cause conflicts and data loss.