Results of 1 - 7 of about 7 for ⟩'); (0.001 sec.)
- Delta Extension 13232
- 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
...d it 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 nam...le; Reading from an S3 Bucket To scan a Delta table in an S3 bucket , run: SELECT * FROM delta_scan('s3://⟨my_bucket⟩/⟨path⟩'); To authenticate, create a secret : CREATE SECRET ( TYPE s3, PROVIDER credential_chain ); SELECT * FROM delta_scan('s3://⟨m...y_bucket⟩/⟨path⟩'); For a public bucket, you may need to set its region in a secret: CREATE SECRET ( TYPE s3, REGION '⟨my_region⟩' ); SELECT *... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- Quack Remote Protocol 9178
- 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
...urself, pass the token parameter (see Security ): {:.codebox-server} CALL quack_serve('quack:localhost', token = '⟨my_token⟩'); Tip The DuckDB CLI can start a server directly with the -serve argument and connect to one with -connect . See Command Lin...HTTP, run: {:.codebox-client} FROM quack_query( 'quack:localhost', 'SELECT 42', token = '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩'); Remote databases use HTTPS by default. To override on a plain-HTTP remote, run: {:.codebox-client} FROM quack_query( 'quac...e via HTTP, simply run: {:.codebox-client} ATTACH 'quack:localhost' AS remote_db ( TOKEN '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩' ); Attaching remote databases uses HTTPS by default. To override on a plain-HTTP remote: {:.codebox-client} ATTACH 'quack:re... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Cloudflare R2 Import 8815
- Prerequisites For Cloudflare R2, the S3 Compatibility API allows you to use DuckDB's S3 support to read and write from R2 buckets. This requires the httpfs extension , which can be installed using the INSTALL SQL command. This only needs to
...FODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', ACCOUNT_ID '⟨your-32-character-hexadecimal-account-ID⟩' ); Querying After setting up the R2 credentials, you can query the R2 data using DuckDB's built-in methods, such as read_csv...or read_parquet : SELECT * FROM read_parquet('r2://⟨r2-bucket-name⟩/⟨file⟩');... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/cloudflare_r2_imp...
- Google Cloud Storage Import 8815
- 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
...clare them: CREATE SECRET ( TYPE gcs, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩' ); Querying After setting up the GCS credentials, you can query the GCS data using: SELECT * FROM read_parquet('gs://⟨gcs_bu...cket⟩/⟨file.parquet⟩'); Attaching to a Database You can attach to a database file in read-only mode: LOAD httpfs; ATTACH 'gs://⟨gcs_bucket⟩/⟨file.... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/gcs_import.html
- S3 Parquet Import 8451
- Prerequisites To load a Parquet file from S3, the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL co
...SECRET ( TYPE s3, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY⟩', REGION '⟨us-east-1⟩' ); Tip If you get an IO Error ( Connection error for HTTP HEAD ), configure the endpoint explicitly via ENDPOINT 's3.⟨your-r...t correctly, Parquet files can be read from S3 using the following command: SELECT * FROM read_parquet('s3://⟨bucket⟩/⟨file⟩'); Google Cloud Storage (GCS) and Cloudflare R2 DuckDB can also handle Google Cloud Storage (GCS) and Cloudflare R2 via the S... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_import.html
- CONNECT and DISCONNECT Statements 8088
- New Support for the CONNECT and DISCONNECT statements was introduced in DuckDB 2.0. The CONNECT statement routes the current session to a remote database, so that subsequent queries execute on that remote and their results stream back. DISC
...r the Quack protocol , route queries to it, and disconnect again: ATTACH 'quack:server.example.com' AS qk (TOKEN '⟨my_token⟩'); CONNECT qk; SELECT count(*) FROM events; -- executes on the server, results stream back DISCONNECT; Connect directly to a... - https://man.mtool.work/duckdb/2.0/sql/statements/connect.html
- Unity Catalog Extension 6979
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...ion, then attach a catalog: CREATE SECRET ( TYPE unity_catalog, TOKEN '⟨token⟩', ENDPOINT '⟨endpoint⟩', AWS_REGION '⟨region⟩' ); ATTACH '⟨catalog_name⟩' AS my_catalog (TYPE unity_catalog, DEFAULT_SCHEMA 'main'); ENDPOINT is the Unity Catalog REST API...RI: CREATE TABLE my_catalog.my_schema.my_external_table (id INTEGER, name VARCHAR) WITH (location = 's3://⟨my_bucket⟩/⟨path⟩'); Both managed and external tables can be partitioned: CREATE TABLE my_catalog.my_schema.my_partitioned_table (id INTEGER, p... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work