Data Warehouse - "Download SQL database project" option generates invalid SQL...

[esobrino]

The scenario is very simple, given a Data Warehouse and executing the "Download SQL database project" menu option, a ZIP file is generated.  The Data Warehouse was created and it contains a table definition that has a foreign key to another CaseDetail table.  The generated project shows the following:

ALTER TABLE [Case].[CaseFlag] ADD CONSTRAINT fk_CaseFlag_Case FOREIGN KEY (, [CaseDetailID]) REFERENCES Case.CaseDetail(, [CaseDetailID]);

Executing the previous statement 2 issues where found.  1) the 2 commas after the openned parenthesis (shown in red); and 2) since (I guess) the word "Case" was not quotted it generated an error.

The expected output was:

ALTER TABLE [Case].[CaseFlag] ADD CONSTRAINT fk_CaseFlag_Case FOREIGN KEY(CaseDetailID)
REFERENCES [Case].[CaseDetail](CaseDetailID) NOT ENFORCED;

On another note the original SQL script define a PK that is not defined in the generated code.  Can you explained why?

Hope that this gets corrected and soon be available...

[esobrino]

Here is the requested info:  Support request number: 2404270040000609

[v-nikhilan-msft]

Hi @esobrino 
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks

[esobrino]

Super!  Hope to hear from you guys sooon...

[v-nikhilan-msft]

Hi @esobrino 
The internal team wants you to create a support ticket to understand why the package generated the wrong script. I will request you to please go ahead with Microsoft support on this. 
https://support.fabric.microsoft.com/en-US/support/
After creating the ticket please provide the ticket details here so that it would be helpful for internal tracking.

Thanks