Skip to main content

    Synapse

    New

    Allow the use of Temp Tables in Fabric Data Warehouse Stored Procedures

    Vote (8) Share
    Jefferson Bauer's profile image

    Jefferson Bauer on 23 Aug 2024 12:42:00

    It would be really helpful to have the use of #temp_tables in fabric data warehouse stored procedures. It would be helpful to have it available in fabric DW sql scripts as well. Thanks!

    Comments (1)
    Jefferson Bauer's profile image Profile Picture

    Twinkle Cyril on 03 Nov 2024 03:24:24

    RE: Allow the use of Temp Tables in Fabric Data Warehouse Stored Procedures

    We are currently working on adding support for session scoped distributed #temp in Fabric DW.I'd like to learn more about the different scenarios where using #temp_tables in Fabric Data Warehouse stored procedures would be beneficial.