Data lakes with Synapse Serverless SQL pool

The OPENROWSET(BULK...) function allows you to access files in Azure Storage.

For Example:

SELECT TOP 100 * FROM
    OPENROWSET(
        BULK 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/puYear=*/puMonth=*/*.parquet',
        FORMAT='PARQUET'
    ) AS [nyc]
SELECT
    YEAR(tpepPickupDateTime) AS current_year,
    COUNT(*) AS rides_per_year
FROM
    OPENROWSET(
        BULK 'https://azureopendatastorage.blob.core.windows.net/nyctlc/yellow/puYear=*/puMonth=*/*.parquet',
        FORMAT='PARQUET'
    ) AS [nyc]
WHERE nyc.filepath(1) >= '2009' AND nyc.filepath(1) <= '2019'
GROUP BY YEAR(tpepPickupDateTime)
ORDER BY 1 ASC

Related Posts

Smart Ways Cloud Networking Is Changing Cloud Operations Today

Introduction Computers talk to each other through invisible roads in the sky. We call these invisible roads cloud networks. Long ago, workers plugged thick cables into giant…

Read More

Great Live Shows and Easy Ticket Sales With MyEventNow

Introduction Live shows bring bright smiles and fresh energy to any dull week. Yet finding local concerts or fun classes often feels hard when event details hide…

Read More

Clear Guide To NFV vs. Traditional Networking: Pros and Cons

Introduction Computer networks carry messages, videos, and games across the whole world. For many years, companies bought heavy metal boxes to move this data. Today, smart engineers…

Read More

Honest Shopper Stories and Simple Buying Guides on iReviewed

Introduction Spending your hard-earned cash on a broken gadget always feels terrible and frustrating. Smart buyers read real stories first so shiny store ads never trick them….

Read More

Smart Paths Exploring The Future of NFV in Cloud Operations

Introduction Big computer networks used to need heavy metal boxes. Workers had to plug cables into huge racks in cold rooms. Now, smart software replaces those heavy…

Read More

Smart Daily Attendance Solutions for Busy Companies With InOrOff

Introduction Growing companies face big headaches when tracking daily employee work hours by hand. Managers lose paper time cards and misread messy handwriting on sticky notes. Calculating…

Read More
guest
0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x