We have multiple projects that have the same datasets and are used for different purposes - prod, beta testing, development. From what I can tell, Elementary needs to put the data it collects in each of these projects to allow us to differentiate between which project the job ran in and what datasets the models actually live in. Is this correct? My hope was to have a single dataset containing all this data, especially the run statistics but it looks like if I attempt to do that, the dbt_models table will always reflect the prod models location only.

Hey Phyllis! Your understanding is correct - Every Elementary schema represents a single dbt project, and these models get reloaded with every

dbt run

. I know that there are some users that tried to union the tables, but so far I haven't seen anyone succeed with this. Multiple environments are supported in the Cloud platform as separate reports 🙂

Thanks for the reply. This is helpful to know.