Forum Discussion

BiJoe's avatar
BiJoe
Icon for Helper II rankHelper II
2 years ago

[Database Projects] Statement 'CREATE TABLE' is not supported

I have just started testing Database Projects extension in Azure Data Studio. I have made a new project out of an existing Fabric warehouse. In that warehouse I have several stored procedure which ar...
data warehouse
AndyDDC's avatar
AndyDDC
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Hi BiJoe so to clarify, it's not any CREATE TABLE syntax failing for actual tables in your database project, but rather CREATE TABLE syntax within Stored Procedures in your database project?

  • BiJoe's avatar
    BiJoe
    Icon for Helper II rankHelper II
    2 years ago

    AndyDDC there are two issues here: 

     

    1. The stored procedures I wrote had CREATE TABLE AS, which I can work around by using SELECT INTO

    2. All the tables, both the ones created from my SP, and the tables imported with Data Flow, show up as CREATE TABLE statements. 

     

    Each of these CREATE TABLE AS statements generate a build failure. I have submitted a support ticket for this. I guess the reason for this failure is that Microsoft SQL Server does not allow CREATE TABLE AS?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi BiJoe 
      Can you please provide the support ticket number here? This would help us to track internally.

      While SQL Server itself supports CTAS, Azure Data Studio Database Projects might have limitations regarding specific platforms like Fabric warehouses. The build error message "SQL70015: Statement 'CREATE TABLE' is not supported for the targeted platform" accurately reflects the current incompatibility.

      • BiJoe's avatar
        BiJoe
        Icon for Helper II rankHelper II
        2 years ago

        Hi, ticket number 2403040050003670

        I understand regarding compatibility, then all the warehouse's imported table CREATE TABLE AS statements will generate build errors.