@Jovian Aditya Wiranata - Thanks for the question and using MS Q&A platform.
Yes, Serverless SQL pools in Azure Synapse Analytics have a limit on the amount of memory that can be used to process data. The maximum size of query result sets in Serverless SQL pools has been increased from 200 GB to 400 GB, but this limit is shared between concurrent queries.
In your case, the error message indicates that there is insufficient system memory to read the data. This could be due to the amount of data being processed or the complexity of the query. You may need to optimize your query or consider using a dedicated SQL pool with more memory if you need to process larger amounts of data.
For more details, refer to Troubleshoot serverless SQL pool in Azure Synapse Analytics.
Hope this helps. Do let us know if you any further queries.