Changing default schema name prevents change data tables/views from being defined

When the default schema value is modified to anything other than a value of "dbo" and real-time updates are enabled which results in a the ChangeFeed folder being created then the anticipated "cdc" prefix is not applied to views or table names in Synapse for the tables located in the ChangeFeed folder. A modification to the manifestToSQLMetadata method in the ManifestHandler.cs file addresses this as seen in the screenshot. Removing the dependency on the schema name allows for the "cdc" prefix to be applied to ChangeFeed tables. The result of not have having this change is that when running the CDMUtil as a Function App whenever an event is fired the views or tables are redefined and could be pointing to either either the Table folder or the ChangeFeed folder in the ADLS depending on the last event processed. CC: @jiyada

Start in ManifestHandler.cs at manifestToSQLMetadata and review how the schema name controls naming for ChangeFeed tables and views. Compare the behavior with a non-dbo default schema while real-time updates create the ChangeFeed folder. Done means the cdc prefix is applied consistently and Synapse objects continue pointing to the ChangeFeed data rather than switching folders after events.