Suggest an Idea

[DXCSupport]

Redshift project Datamart tables will always be created in the schema that you defined as part of the data warehouse connections. Redshift Compose project is not getting the datamart schema defined in the data mart tasks area.

[TimGarrod]

Hello - the current configuration for Compose is to create views in the schema defined. 

In order to have the views generated, you must provide the view name in the object configuration (dimension or fact). 

This generally provides the level of abstraction for customers to provide objects in schema's for security etc. separation.  

Setting this to collecting feedback to understand if this explains how the 'create views in' configuration works.  Thanks!

eg. - 

[Meghann_MacDonald]

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.