High Performance Remote File System, Database and 'Geospatial' Access Using 'duckdb'
as_dataset
as_view
create a cachable duckdb connection
close connection
duckdb configuration
show duckdb extensions
duckdb reset configuration to default
duckdb reset configuration to default
Configure S3 settings for database connection
duckdb secrets
load the duckdb geospatial data plugin
load the duckdb geospatial data plugin
Open a dataset from a variety of sources
spatial_join
read spatial metadata
Write geojson using duckdb's native JSON writer
Write H3 hexagon data out as an h3j-compliant JSON file NOTE: the colu...
to_json write data out as a JSON object
Convert output to sf object
write_dataset
Write a spatial file with gdal
Provides friendly wrappers for creating 'duckdb'-backed connections to tabular datasets ('csv', parquet, etc) on local or remote file systems. This mimics the behaviour of "open_dataset" in the 'arrow' package, but in addition to 'S3' file system also generalizes to any list of 'http' URLs.
Useful links