marcoslot

select load_esri('esri', 'https://map.oshawa.ca/arcgis/rest/services/Operational/OpenData/MapServer/1/query?where=1%3D1&orderByFields=OBJECTID&OutFields=*&f=pjson');

marcoslot

-- Load data from https://coast.noaa.gov/htdata/CMSP/AISDataHandler/2024/index.html into Iceberg
--
-- To prepare: create extension crunchy_spatial_analytics cascade;


-- Clean up previous creation
-- drop table if exists ais, loaded_ais_files;

-- Create the AIS Iceberg table
create table ais (

marcoslot

create foreign table addresses ()
server crunchy_lake_analytics
options (path 's3://overturemaps-us-west-2/release/2024-07-22.0/theme=addresses/type=*/*.parquet');

create foreign table base ()
server crunchy_lake_analytics
options (path 's3://overturemaps-us-west-2/release/2024-07-22.0/theme=base/type=*/*.parquet');

create foreign table buildings () 
server crunchy_lake_analytics