Does serverless SQL pool approach of the Azure synapse analytics provide a SQL db on the endpoint?
I have data in azure data lake gen2 parquet files.
Using Azure synapse analytics I have created SQL pool. Then, via linked service I’m connecting to parquet file. Then, I have created multiple views that do select * from OPENROWSET… from couple of parquet files.
I can use the SQL endpoint in a reporting tool like Power BI to fetch the data from the above views.
Question:
What is the purpose of the SQL endpoint? Does it have a SQL database which could hold the data from the view? Or does SQL endpoint only represent a resource to query the data from parquet file?
Read more here: Source link
