Hello @Aman Dwivedi ,
Welcome to the Microsoft Q&A platform and thanks for reaching out.
I have verified with Azure Purview product team and confirmed that Azure Synapse workspace integration is yet to land and is expected very soon in the coming weeks. Unfortunately I do not have definite date but please look out for azure updates page for upcoming features and releases: https://azure.microsoft.com/updates/
Currently only scanning of dedicated SQL pool (formerly SQL DW which was created outside of workspace) is supported.
This is why you are not able to see the Workspace SQL pools while trying to scan in Purview. But expect this feature to land soon.
Hope this helps. Do let us know if you any further queries.
------------
Please don’t forget to Accept Answer
and Up-Vote
wherever the information provided helps you, this can be beneficial to other community members.