Skip to main content

Synapse (Azure)

You will need to create an account to use Synapse and other Microsoft Azure services.

In your Azure account, create a Synapse workspace. You can then run this example query to get places in Seattle:

SELECT TOP 10 *
FROM
OPENROWSET(
BULK 'https://overturemapswestus2.blob.core.windows.net/release/2024-06-13-beta.0/theme=places/type=place/',
FORMAT = 'PARQUET'
)
WITH
(
names VARCHAR(MAX),
categories VARCHAR(MAX),
websites VARCHAR(MAX),
phones VARCHAR(MAX),
bbox VARCHAR(200),
geometry VARBINARY(MAX)
)
AS
[result]
WHERE
TRY_CONVERT(FLOAT, JSON_VALUE(bbox, '$.xmin')) > -122.4447744
AND TRY_CONVERT(FLOAT, JSON_VALUE(bbox, '$.xmax')) < -122.2477071
AND TRY_CONVERT(FLOAT, JSON_VALUE(bbox, '$.ymin')) > 47.5621587
AND TRY_CONVERT(FLOAT, JSON_VALUE(bbox, '$.ymax')) < 47.7120663

More information is available at "Query files using a serverless SQL pool" on Microsoft Learn.