Results of 1 - 10 of about 18 for attaching (0.002 sec.)
- Catalogs 11873
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...in the overview . The section below describes the generic way of attaching an Iceberg REST Catalog. For instructions specific to a catalog implementation, see Amazon S3 Tables , AWS Glue , Cloudfla...re R2 Data Catalog , Apache Polaris , Lakekeeper , SeaweedFS and Google Cloud BigLake . Attaching an Iceberg REST Catalog Most Iceberg REST Catalogs authenticate via OAuth2. You can use the existing DuckDB secret workflo... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Attach to a DuckDB Database over HTTPS or S3 11873
- 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. Attaching
...s_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 for your bucket... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_over_https...
- Troubleshooting Quack 10037
- DuckDB 2.0 ships a polished version of Quack (first released in DuckDB 1.5.3) with substantial performance and stability improvements. If you experience any issues with Quack, try upgrading all your DuckDB clients to the latest version of t
...catalogs. It does not fix unrelated binding errors or failures to load Iceberg metadata. Resolving only some tables before attaching is not enough: if any other unresolved table remains, the attachment still fails. Warming every table individually is a wo...new unresolved tables brings the problem back, so eager server-side resolution is the more reliable fix. Querying Without Attaching If you want to keep lazy resolution, use quack_query() , which runs SQL directly on the server without importing its catal... - https://man.mtool.work/duckdb/2.0/quack/troubleshooting.html
- ATTACH and DETACH Statements 9780
- 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
...al_writes disables WAL writes, improving performance at the cost of crash recovery. VARCHAR - The options above apply when attaching DuckDB and SQLite database files. Attaching a database managed by another system accepts additional type-specific options,...for another engine but also pass TYPE DUCKDB , the prefix is ignored and the statement does not have the intended effect. Attaching Data Files Directly A Parquet, CSV, or JSON file can be attached directly, not only a DuckDB database file. This creates a... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Delta Extension 9522
- The delta extension adds support for the Delta Lake open-source storage format . It is built using the Delta Kernel . The extension reads Delta tables, local and remote, and writes them: it can create tables and append to them. For implemen
...manually, run: INSTALL AND LOAD delta; Usage To scan a local Delta table, run: SELECT * FROM delta_scan('file:///⟨path⟩'); Attaching Tables A Delta table can also be attached as a database. The database holds exactly one table, with the same name as the d...s name: without the database name, it creates the table in the default database. The table can be read and written without attaching it again. Warning ATTACH does not check that the path holds a Delta table. A mistyped path attaches as an empty database a...H 's3://⟨my_bucket⟩/⟨path⟩' AS my_table_then (TYPE delta, TIMESTAMP TIMESTAMPTZ '2026-09-01 12:00:00+00'); -- Scan without attaching SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩', version => 5); -- since v1.5.4 SELECT * FROM delta_scan('s3://⟨my_buck... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Copying an In-Memory Database to a File 9522
- Imagine the following situation – you started DuckDB in in-memory mode but would like to persist the state of your database to disk. To achieve this, attach to a new disk-based database and use the COPY FROM DATABASE ... TO command : ATTACH
...PY FROM DATABASE memory TO my_database; DETACH my_database; Ensure that the disk-based database file does not exist before attaching to it.... - https://man.mtool.work/duckdb/2.0/guides/snippets/copy_in-memory_database_to_fil...
- Quack Remote Protocol 9522
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...with the DISABLE_SSL configuration option. Stateless Queries with quack_query You can run any SQL against a server without attaching it. To query a local database via HTTP, run: {:.codebox-client} FROM quack_query( 'quack:localhost', 'SELECT 42', token =...e result back. Errors occurring on the server (parse errors, missing tables, etc.) are shown locally in the DuckDB client. Attaching a Remote Database To attach a local database via HTTP, simply run: {:.codebox-client} ATTACH 'quack:localhost' AS remote_d...b ( TOKEN '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩' ); Attaching remote databases uses HTTPS by default. To override on a plain-HTTP remote: {:.codebox-client} ATTACH 'quack:remote.com' A... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Google Cloud Storage Import 8990
- Prerequisites The Google Cloud Storage (GCS) can be used via the httpfs extension . This can be installed with the INSTALL httpfs SQL command. This only needs to be run once. Credentials and Configuration You need to create HMAC keys and de
...up the GCS credentials, you can query the GCS data using: SELECT * FROM read_parquet('gs://⟨gcs_bucket⟩/⟨file.parquet⟩'); Attaching to a Database You can attach to a database file in read-only mode: LOAD httpfs; ATTACH 'gs://⟨gcs_bucket⟩/⟨file.duckdb⟩' A... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/gcs_import.html
- Indexing 8990
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...a significant portion of DuckDB's available memory, potentially affecting the performance of memory-intensive queries. Re-attaching ( DETACH + ATTACH ) the database containing indexes can mitigate this effect, as we deserialize index memory lazily. Disab...ling index scans and re-attaching after changes can further decrease the impact of indexes on DuckDB's available memory. Indexes and Opening Databases Index... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Iceberg Extension 8733
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...alog and is read-only. Catalog-managed tables are accessed by attaching an Iceberg REST catalog. This unlocks the full feature set, including writing. This page covers the basics of both. See al...Reading Iceberg Tables Individual Iceberg tables can be read directly from storage with the iceberg_scan function, without attaching to a catalog. To test the examples, download the iceberg_data.zip file and unzip it. Querying Individual Tables Use the ic... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
DuckDB 2.0 Documentation / man.mtool.work