How to change schema name to which datamart is pointing to

[PakalaS]

How to change schema name to which datamart is pointing to

[TimGarrod · Accepted solution]

@PakalaS  - this configuration can be done in either the Data Warehouse connection (default for all datamarts) or if you need to change for a specific data mart then you can change it in the Data Mart settings.   (Feature for datamart schema's / database is different based on the target platform you are running on.  For Example, in SQL Server and Snowflake, since you can insert into any database via the single connection, you can select a different database or schema). 

Data Warehouse Connection -  Under Databases select the Data warehouse connection and select EDIT - 

the data mart schema can be adjusted

Data Marts - Under the Data Mart design screen, select your data mart in the left hand side (ensure it is highlighted) and click Settings.   Note the below screenshot is for a SQL Server target.  Depending on your target (as mentioned above) the configuration options may be different. 

This setting is for the highlighted data mart.  You can select the schema for the data mart. 

[Nanda_Ravindra · Accepted solution]

Hello @PakalaS 

While Tim’s response is correct for most of the databases, Compose Synapse implementation does not yet have the ability to put data mart tables in a specific schema and we have this documented in our user guide.

https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Data%20Marts/modify_data_mar...

That being said, we have this on our road to implement for other databases but no set ETA for now.

I see that you opened a case with support reporting that ability to specify the schema for synapse does not exist. With the current option for synapse database, you can still have segregation with views.

In a Synapse project, the settings provide the ability to "Create views in schema". While this means the tables are kept in the main DM schema, we will create views for the objects in the specified schema.  For Compose to create the view - you must provide the name of the view in the object setting. Eg - Fact View Name - when that is provided (not blank) - Compose will create a view as "select * from table ".

Hope this helps!

Thanks,

Nanda