Get Parquet column names as values via T-SQL and OPENROWSET
I have a Parquet data lake stored in Azure Data Lake Gen2. I am using Synapse to perform serverless SQL queries on this data lake – and I then visualize this via Grafana, using Microsoft SQL Server as the data source. I am using OPENROWSET rather than creating External Tables.
Azure Synapse: Get Parquet column names as values via T-SQL and OPENROWSET
I have a Parquet data lake stored in Azure Data Lake Gen2. I am using Synapse to perform serverless SQL queries on this data lake – and I then visualize this via Grafana, using Microsoft SQL Server as the data source. I am using OPENROWSET rather than creating External Tables.