Results of 1 - 10 of about 132 for supports (0.001 sec.)
- httpfs Extension for HTTP and S3 Support 12520
- The httpfs extension is an autoloadable extension implementing a file system that allows reading remote/writing remote files. For plain HTTP(S), only file reading is supported. For object storage using the S3 API, the httpfs extension supports
...s extension. To manually install and load the httpfs extension, run: INSTALL AND LOAD httpfs; HTTP(S) The httpfs extension supports connecting to HTTP(S) endpoints . S3 API The httpfs extension supports connecting to S3 API endpoints .... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/overview.html
- Prepared Statements 10268
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...sitional ( $1 ), and named ( $param ). Note that not all clients support all of these syntaxes, e.g., the JDBC client only supports auto-incremented parameters in prepared statements. Example Dataset In the following, we introduce the three different syn...with a B and are at least 40 years old. This will return a single row <'Bob', 41> . Auto-Incremented Parameters: ? DuckDB supports using prepared statements with auto-incremented indexing, i.e., the position of the parameters in the query corresponds to...corresponds to $1 , the second to $2 , and so on. EXECUTE query_person(40, 'B'); Named Parameters: $parameter DuckDB also supports named parameters where parameters are denoted with $parameter_name . For example: PREPARE query_person AS SELECT * FROM pe... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- File Access with the file: Protocol 9917
- DuckDB supports using the file: protocol. It currently supports the following formats: file:/some/path (host omitted completely) file:///some/path (empty host) file://localhost/some/path ( localhost as host) Note that the following formats
... - https://man.mtool.work/duckdb/2.0/guides/file_formats/file_access.html
- HTTP(S) Support 8706
- 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
...les, files will be downloaded entirely in most cases, due to the row-based nature of the format. For Parquet files, DuckDB supports partial reading , i.e., it can use a combination of the Parquet metadata and HTTP range requests to only download the part...ey 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 block-based and stores per-column and per-row-group statist...Or: CREATE SECRET http_auth ( TYPE http, EXTRA_HTTP_HEADERS MAP { 'Authorization': 'Bearer ⟨token⟩' } ); HTTP Proxy DuckDB supports HTTP proxies. You can add an HTTP proxy using the Secrets Manager : CREATE SECRET http_proxy ( TYPE http, HTTP_PROXY '⟨htt... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- Profiling Queries 8706
- DuckDB supports profiling queries via the EXPLAIN and EXPLAIN ANALYZE statements. EXPLAIN To see the query plan of a query without executing it, run: EXPLAIN ⟨query⟩; The output of EXPLAIN contains the estimated cardinalities for each opera
..., but the exact formatting and any generated aliases are not a stable interface. EXPLAIN (SQL) does not execute the query, supports only SELECT , VALUES , WITH , INSERT , UPDATE , DELETE and MERGE INTO statements, and cannot be combined with ANALYZE or F... - https://man.mtool.work/duckdb/2.0/sql/statements/profiling.html
- Writing to Iceberg 8536
- The DuckDB iceberg extension supports writing to Iceberg tables when an Iceberg catalog is attached. Writing to a table read directly from storage with iceberg_scan is not supported: the catalog is required to commit the new table metadata.
...Supported Operations The iceberg extension supports the following operations when used with a REST Catalog attached: CREATE/DROP SCHEMA CREATE/DROP TABLE INSERT INTO UPDATE D...ze exceeds the target file size, DuckDB caps the row-group size to the target file size. Iceberg V3 Support DuckDB-Iceberg supports the following Iceberg v3 specification features for both reads and writes: VARIANT and TIMESTAMP_NS data types Schema-leve...(encoded as binary deletion vectors for v3 tables). Copy-on-write functionality is not yet supported. DuckDB-Iceberg only supports merge-on-read semantics . If a table has write.update.mode or write.delete.mode properties set to something other than mer... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/writing_to_iceberg.htm...
- ODBC API on macOS 8015
- A driver manager is required to manage communication between applications and the ODBC driver. DuckDB supports unixODBC , which is a complete ODBC driver manager for macOS and Linux. Users can install it from the command line via Homebrew :
...on files, or by connecting with SQLDriverConnect . A combination of the two is also possible. Furthermore, the ODBC driver supports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed to SQLDri... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Lakehouse Formats 8015
- Lakehouse formats, often referred to as open table formats, are specifications for storing data in object storage while maintaining some guarantees such as ACID transactions or keeping snapshot history. Over time, multiple lakehouse formats
...use to still use DuckDB and get close to full interoperability with these formats. DuckDB Lakehouse Support Matrix DuckDB supports Iceberg, Delta, Lance and DuckLake as first-class citizens. The following matrix represents what DuckDB natively supports... - https://man.mtool.work/duckdb/2.0/lakehouse_formats.html
- Table Functions 7846
- The table function API can be used to define a table function that can then be called from within DuckDB in the FROM clause of a query. API Reference Overview duckdb_table_function duckdb_create_table_function (); void duckdb_destroy_table_
...ction_set_function ( duckdb_table_function table_function , duckdb_table_function_t function ); void duckdb_table_function_supports_projection_pushdown ( duckdb_table_function table_function , bool pushdown ); duckdb_state duckdb_register_table_function..._table_function_t function ); Parameters table_function : The table function function : The function duckdb_table_function_supports_projection_pushdown Sets whether or not the given table function supports projection pushdown. If this is set to true, the...this is set to false (the default), the system will expect all columns to be projected. Syntax void duckdb_table_function_supports_projection_pushdown ( duckdb_table_function table_function , bool pushdown ); Parameters table_function : The table functi... - https://man.mtool.work/duckdb/2.0/clients/c/table_functions.html
- Excel Export 7846
- DuckDB supports exporting data to Excel .xlsx files via the excel extension. Please note that .xls files are not supported. To install and load the extension, run: INSTALL excel; LOAD excel; Exporting Excel Sheets To export a table to an Ex
...the SHEET option: COPY tbl TO 'output.xlsx' WITH (FORMAT xlsx, SHEET 'Sheet1'); Type Conversions Because Excel only really supports storing numbers or strings – the equivalent of VARCHAR and DOUBLE , the following type conversions are automatically appli... - https://man.mtool.work/duckdb/2.0/guides/file_formats/excel_export.html
DuckDB 2.0 Documentation / man.mtool.work