Tony Truong uses T -SQL to query Delta Lake files:
How to query Delta Lake with SQL on Azure SynapseAs mentioned earlier, Azure Synapse has several compute pools for the evolving analytical workload. There is the Apache Spark pool for data engineers and serverless SQL pool for analysts. Let us break down how the two personas work together to query a shared Delta Lake.
Read on for the setup and the payoff.