Is there a way to include partition paths of the file path as a column in Azure Synapse SQL?
I have written parquet files in a path like this on the blob storage container: https://<my_blob_storage_accnt>.dfs.core.windows.net/current-snapshot/businesspartner=P1, https://<my_blob_storage_accnt>.dfs.core.windows.net/current-snapshot/businesspartner=P2, etc.