Hello @Maitra-v, Anirban ,
Welcome to the Microsoft Q&A platform, and thanks for posting your query.
As per the below Microsoft documentation, the Max size is 240TB compressed on disk.
Dedicated SQL pool size:
Gen1: 240 TB compressed on disk. This space is independent of tempdb or log space, and therefore this space is dedicated to permanent tables. Clustered columnstore compression is estimated at 5X. This compression allows the database to grow to approximately 1 PB when all tables are clustered columnstore (the default table type).
Gen2: Unlimited storage for columnstore tables. Rowstore portion of the database is still limited to 240 TB compressed on disk.
You can see this from DB properties.
Please let me know if this is helpful. If you have any further queries, please let us know