topic Re: Data Warehouse - "Download SQL database project" option generates invalid SQL... in Data Warehouse

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

esobrino — Thu, 25 Apr 2024 21:12:05 GMT

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...

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

Anonymous — Fri, 26 Apr 2024 19:56:14 GMT

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

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

esobrino — Fri, 26 Apr 2024 19:57:33 GMT

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

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

Anonymous — Fri, 26 Apr 2024 20:01:04 GMT

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

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

esobrino — Sat, 27 Apr 2024 10:55:29 GMT

Here is the requested info: Support request number: 2404270040000609