Hi all. We've got our tables/models `sales` in a ...
# community-support
v
Hi all. We've got our tables/models
sales
in a datset/schema called
vanessa_prototypes
(we also have
james_prototypes
,
alex_prototypes
so the full is if
project_id.vanessa_prototypes.sales
(etc for the other datasets/schemas). I want elementary to read from this table but write to a different project. Is this possible? I don't want to create all 29 tables for each dataset/schema. That feels needlessly messy and repetitive.
n
Hey Vanessa! 🙂 Elementary can support one dbt project, but each dbt project can work with multiple schemas, Is each schema built by a seperate dbt project? If so, you can consider creating a shared repository, as explained here: https://discourse.getdbt.com/t/how-to-configure-your-dbt-repository-one-or-many/2121
v
Thanks for this - I'll have a look!
🙌 1
n
Great! Let us know if this solution works for you.