Compose Log Tables

[mopidesp]

We are having multiple projects (one for each source)  and the DV schema for all these projects is same. How do we manage the creation of log tables as they are generic and not tied to a specific project ?

We are encountering the issues where log tables are being overwritten by one project that were created by other project

or 

we are running in to errors while creating the DV tables saying the tables already exist as these log tables were already created by other project.  

Thanks for your time

[TimGarrod · Accepted solution]

Hi, Currently in ComposeDW - each DW project is expecting to own / manage a specific schema. You cannot have 2 Compose projects pointed to the same DW schema.
You should segregate the projects so they each point to a different schema (they can share the same database but different schema's).

[mopidesp · Accepted solution]

Hi Tim, Thanks for the response and this is helpful information.