Results of 1 - 6 of about 6 for stations (0.001 sec.)
- Attach to a DuckDB Database over HTTPS or S3 13088
- You can establish a read-only connection to a DuckDB instance via HTTPS or the S3 API. Prerequisites This guide requires the httpfs extension , which can be installed using the INSTALL httpfs SQL command. This only needs to be run once. Att
...To connect to a DuckDB database via HTTPS, use the ATTACH statement as follows: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; Then, the database can be queried using: SELECT count(*) AS num_stations FROM stations_db.stations...; num_stations 578 Attaching to a Database over the S3 API To connect to a DuckDB database via the S3 API, configure the authentication f...or your bucket (if required). Then, use the ATTACH statement as follows: ATTACH 's3://duckdb-blobs/databases/stations.duckdb' AS stations_db; The database can be queried using: SELECT count(*) AS num_stations FROM stations_db.stations; num_... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_over_https...
- Share a DuckDB Database That Only Stores Views 8902
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...og; USE catalog; CREATE VIEW services AS SELECT * FROM read_parquet('s3://my-bucket/rail/services/*.parquet'); CREATE VIEW stations AS SELECT * FROM read_parquet('s3://my-bucket/rail/stations.parquet'); Because the file stores only view definitions, it s...om the referenced remote files: ATTACH 'https://example.com/catalog.duckdb' AS catalog (READ_ONLY); SELECT count(*) AS num_stations FROM catalog.stations; Consumers need the httpfs extension and, for s3:// sources, credentials that grant access to the un... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- ATTACH and DETACH Statements 8664
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...ly connection by default. Therefore, the following two commands are equivalent: ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db; ATTACH 'https://blobs.duckdb.org/databases/stations.duckdb' AS stations_db (READ_ONLY); Similarly,...the following two commands connecting to S3 are equivalent: ATTACH 's3://⟨blobs-duckdb⟩/databases/stations.duckdb' AS stations_db; ATTACH 's3://⟨blobs-duckdb⟩/databases/stations.duckdb' AS stations_db (READ_ONLY); Explicit Storag... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Sharing Macros 8353
- DuckDB has a powerful macro mechanism that allows creating shorthands for common tasks. Sharing a Scalar Macro First, we define a macro that pretty-prints a non-negative integer as a short string with thousands, millions, and billions (with
...the macro: ATTACH 'https://blobs.duckdb.org/data/compute_table_checksum.duckdb' AS compute_table_checksum_db; CREATE TABLE stations AS FROM 'https://blobs.duckdb.org/stations.parquet'; .mode line FROM compute_table_checksum_db.checksum('stations'); id =... - https://man.mtool.work/duckdb/2.0/guides/snippets/sharing_macros.html
- ODBC Extension Functions 8317
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...CHAR ): path to a Parquet, CSV or JSON file (remote or local) to be read with DuckDB, example: https://blobs.duckdb.org/nl_stations.csv , equivalent to source_query='SELECT * FROM '<source_file>' source_query ( VARCHAR ): DuckDB SQL query to read the dat...a, example: FROM nl_train_stations source_queries ( LIST(VARCHAR) ): multiple DuckDB SQL queries executed one by one, last query must return the result set t...lts of all queries are materialized in memory, example: source_queries=[ 'CREATE SECRET s (TYPE s3 [...])', 'FROM nl_train_stations' ], source_limit ( UBIGINT , default: 0 ): the number of records to read from source query/file at once, when this option... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- ODBC Extension 7457
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...'?', 'quack')); -- copy data into remote DB FROM odbc_copy(getvariable('conn'), source_file = 'https://blobs.duckdb.org/nl_stations.csv', dest_table = 'NL_TRAIN_STATIONS', create_table = true); -- close connection SELECT odbc_close(getvariable('conn'));... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work