Data mart duplication

[JacobTews]

Has anyone found a quick/easy way to duplicate a data mart?

As I incrementally develop the DW in Compose, we add new features to the data marts powering our dashboards, but it's quite tedious to create a new data mart every time a new column is added to a table (in order for the mart to populate with the new data), and I haven't yet found a way around this.

I have poked around the GUI and looked through the documentation extensively. I also attempted to make use of the ComposeCli on the server, exporting the project as CSVs then importing a duplicate of the data mart this way, with no success.

We are running client-managed Compose on-prem, release 2022.5.0.958.

Thanks for the help!

[sureshkumar]

Hello @JacobTews 

DataMart doesn't get the new column by default, so we need to create New Data Mart to get the new changes.

Regards,
Suresh

[TimGarrod · Accepted solution]

Note, if you are adding just a few columns - this can be done manually in the Data Mart.  Simply add the column name / data type and map the source column to it. 

[JacobTews]

Got it, thanks for the tip! I had forgotten that attributes could be added manually in the Data Mart as well as in the Model.

[dheera52]

I really WANT it to be good because it would solve so many problems for us (e.g. waiting 6 months for basic data engineering tickets to get looked at). It seems like the typical release pattern, though, where they released it half-baked and after a few years it'll probably be usable. When I tried it out it was suuuuper buggy.