question

serverlesssql avatar image
0 Votes"
serverlesssql asked PRADEEPCHEEKATLA-MSFT commented

Serverless SQL Pools 100MB temp table limit

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @serverlesssql,

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.


image.png (22.6 KiB)
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @serverlesssql,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hi, yes I did see the 100MB limit in the documentation however I believe I was able to insert more that 100MB into a temp table

0 Votes 0 ·

Hello @serverlesssql,

Thanks for bringing this to our attention.

Let me try to repro it and see if it allows to insert more that 100MB into a temp table.

0 Votes 0 ·

Hello @serverlesssql,

Could you please help with the screenshot where the you can insert data into temp table greater than 100 MB?

0 Votes 0 ·