Hello @Thota Harsha Vardhan,
Thanks for the question and using MS Q&A platform.
After scanning your Snowflake source, you can browse data catalog or search data catalog to view the asset details.
Go to the asset -> lineage tab, you can see the asset relationship when applicable. Refer to the supported capabilities section on the supported Snowflake lineage scenarios. For more information about lineage in general, see data lineage and lineage user guide.
In Snowflake store - support capabilities:
Fetching static lineage on assets relationships among tables, views, and streams.
For more details, refer to Connect to and manage Snowflake in Microsoft Purview.
Hope this helps.