I created a table in my Azure SQL server(Server name: trail, DB Name: test, Schema Name: dbo ) as shown in the below screenshot
I registered the Azure SQL source in Azure purview and did a scan and the newly created table was scanned successfully but there was something unusual in the schema. There was another column created in the sql table (sample) column name: Sno. Not sure why this extra column populates. Is there any workaround for this particular?