Results of 1 - 9 of about 9 for domain (0.001 sec.)
- HTTP(S) Support 13571
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...he following query will only read the Parquet metadata and the data for the column_a column: SELECT column_a FROM 'https://domain.tld/file.parquet'; In some cases, no actual data needs to be read at all as they only require reading the metadata: SELECT...count(*) FROM 'https://domain.tld/file.parquet'; DuckDB's own database format supports partial reading just as well as Parquet. Because the format is bl...e requests to fetch only the blocks required by a query when a remote database file is attached read-only: ATTACH 'https://domain.tld/file.duckdb' AS db (READ_ONLY); SELECT column_a FROM db.tbl; As with Parquet, queries that only need the metadata, suc... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Delta Extension 9976
- 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
...data_file, cardinality, delete_count FROM delta_list_files('file:///⟨path⟩', version => 3, delete_count => true); Reading Domain Metadata Since v1.5.1, delta_domain_metadata returns one row per domain of a table, with the VARCHAR columns domain and co...nfiguration . Pass version => ⟨version⟩ for an earlier version: SELECT domain, configuration FROM delta_domain_metadata('file:///⟨path⟩'); For an attached table, duckdb_tables() shows the same pairs i... - https://man.mtool.work/duckdb/2.0/core_extensions/delta.html
- HTTP CSV Import 9418
- To load a CSV file directly over HTTP(S), 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 comman
...set up, CSV files can be read over http(s) the same way as a local file, using read_csv : SELECT * FROM read_csv('https://⟨domain⟩/path/to/file.csv'); Moreover, the read_csv function itself can also be omitted thanks to DuckDB's replacement scan mechan...ism : SELECT * FROM 'https://⟨domain⟩/path/to/file.csv'; Example The following query reads an openly licensed (CC BY 4.0) real-world CSV directly over HTTP and... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- HTTP Parquet Import 8448
- To load a Parquet file over HTTP(S), 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 command: LO
...ttpfs; After the httpfs extension is set up, Parquet files can be read over http(s) : SELECT * FROM read_parquet('https://⟨domain⟩/path/to/file.parquet'); For example: SELECT * FROM read_parquet('https://duckdb.org/data/prices.parquet'); Moreover, the... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_import.html
- Deploy 8178
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...sm package. You can deploy it in one of three ways: Bundled together with your application Served from a same-origin (sub-)domain and included at runtime Served from a third-party CDN such as jsDelivr It cannot be served as-is: it requires transpilatio...can compile them efficiently. Host them anywhere reachable from the main document — the same origin or an arbitrary [sub-]domain. The main library component is told each module's location through the bundle definition (the mainModule path), so the mod... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Extensions 8178
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
...e is available for developing extensions. This allows users to extend the functionality of DuckDB such that it suits their domain the best. A template for creating extensions is available in the extension-template repository . This template also holds... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- Glossary of Terms 8034
- This page contains a glossary of a few common terms used in DuckDB. Terms In-Process Database Management System The DBMS runs in the client application's process instead of running as a separate process, which is common in the traditional c
...ions. These may extend DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionality. For details, see the Extensions page . Platform The platform is a combination of the operating sys... - https://man.mtool.work/duckdb/2.0/guides/glossary.html
- Legacy Authentication Scheme for S3 API 7495
- Prior to version 0.10.0, DuckDB did not have a Secrets manager . Hence, the configuration of and authentication to S3 endpoints was handled via variables. This page documents the legacy authentication scheme for the S3 API. Warning This pag
...s-east-1'; Optionally, the endpoint can be configured in case a non-AWS object storage server is used: SET s3_endpoint = '⟨domain⟩.⟨tld⟩:⟨port⟩'; If the endpoint is not SSL-enabled then run: SET s3_use_ssl = false; Switching between path-style and vhos... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Timestamp Issues 7495
- Timestamp with Time Zone Promotion Casts Working with time zones in SQL can be quite confusing at times. For example, when filtering to a date range, one might try the following query: SET timezone = 'America/Los_Angeles'; CREATE TABLE time
...sions. Also notice that we are leveraging the DATE cast rules from the previous section to bound the calendar to the model domain. Half-Open Intervals Another subtle problem in using SQL for temporal analytics is the BETWEEN operator. Temporal analytic... - https://man.mtool.work/duckdb/2.0/guides/sql_features/timestamps.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work