Serverless SQL Pools 100MB temp table limit

Serverless SQL 216 Reputation points MVP
2021-08-30T11:14:52.287+00:00

Hi, according to the Microsoft documentation when using temp tables within Serverless SQL Pools there is a size limit of 100MB. Can this be confirmed please as I have been able to insert a much larger dataset.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,116 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 73,651 Reputation points Microsoft Employee
    2021-08-31T04:10:54.08+00:00

    Hello @Serverless SQL ,

    Thanks for the question and using MS Q&A platform.

    Yes, there is a total size is limited to 100MB in temporary tables in serverless SQL pool.

    127699-image.png

    For more details, refer to Temporary tables in serverless SQL pool.

    Hope this helps. Do let us know if you any further queries.

    ---------------------------------------------------------------------------

    Please "Accept the answer" if the information helped you. This will help us and others in the community as well.