Results of 1 - 10 of about 57 for settings (0.003 sec.)
- Securing DuckDB 13011
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...itive data or in shared environments. This page documents DuckDB's security model and security-related settings. The right configuration depends on your use case, environment, and threat model. If you plan to embed DuckDB in your appl...sandboxing Use network isolation to prevent data exfiltration Implement strict query timeouts at the application level The settings described on this page provide defense-in-depth and can limit certain capabilities, but they are not a substitute for prop...y page . Reporting Vulnerabilities If you discover a potential vulnerability, please report it confidentially via GitHub . Settings to Limit DuckDB's Capabilities The settings documented in this section provide additional hardening for DuckDB deployments... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- DuckDB_% Metadata Functions 12541
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...and you should write parentheses after the function name to call it to obtain its returned resultset: SELECT * FROM duckdb_settings(); Alternatively, you may execute table functions also using the CALL -syntax: CALL duckdb_settings(); In this case too, t...ARCHAR[] result_types The types of the columns in the table returned by the prepared statement. VARCHAR[] duckdb_profiling_settings The duckdb_profiling_settings() macro returns the current profiling-related settings from duckdb_settings() . Column Descr...e sequence will start over from the boundary of its range, not necessarily from the value specified as start value. duckdb_settings The duckdb_settings() function provides metadata about the settings available in the DuckDB instance. Column Description T... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Configuration 10544
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...atement . The values of configuration options can be queried via the current_setting() scalar function or using the duckdb_settings() table function . For example: SELECT current_setting('memory_limit') AS memlimit; Or: SELECT value AS memlimit FROM duck...db_settings() WHERE name = 'memory_limit'; Examples Set the memory limit of the system to 10 GB. SET memory_limit = '10GB'; Configure...vel = 'DEBUG'; Check logs with the QueryLog type: SELECT * FROM duckdb_logs WHERE type = 'QueryLog'; Check current logging settings: SELECT * FROM duckdb_settings() WHERE name LIKE '%logging%'; Enable printing of a progress bar during long-running querie... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- DBeaver SQL IDE 9839
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...nvironment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. You should now see a database connection to your DuckDB database in the left hand “Database Navigator” pane. Expand it to...nstall the DuckDB driver when testing your connection, return to the “Connect to a database” dialog and click “Edit Driver Settings”. Alternatively, you can access the driver settings menu by returning to the main DBeaver window and clicking Database > D...nvironment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. Manual Driver Installation If DBeaver cannot download the driver itself, for example when it runs without write access to... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- Reference 9839
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...). HEARTBEAT_TIMEOUT UBIGINT quack_default_heartbeat_timeout Heartbeat lease timeout in seconds requested from the server. Settings All settings are regular DuckDB session / global options. Set with SET ⟨name⟩ = ⟨value⟩ or SET GLOBAL . Authentication / A...uthorization The auth callbacks are evaluated on a fresh server-side connection every time, so the two settings below are global-scoped ( SET GLOBAL ). A plain SET on these is forwarded to the global slot automatically. Use RESET GLOB...scalar function with the expected signature and pointing the setting at it. See Security for examples. Data Transfer These settings control how results and inserted data are batched and buffered. Setting Type Default Description quack_target_batch_bytes... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- EXPLAIN: Inspect Query Plans 9251
- EXPLAIN SELECT * FROM tbl; The EXPLAIN statement displays the physical plan, i.e., the query plan that will get executed, and is enabled by prepending the query with EXPLAIN . The physical plan is a tree of operators that are executed in a
...erators display the fully qualified table name including catalog and schema (e.g., memory.main.exams ). Additional Explain Settings The EXPLAIN statement supports additional settings that can be used to control the output. The following settings are avai... - https://man.mtool.work/duckdb/2.0/guides/meta/explain.html
- Known Issues 9016
- Incorrect Memory Values on Old Linux Distributions and WSL 2 On Windows Subsystem for Linux 2 (WSL2), when querying the max_memory or memory_limit from the duckdb_settings , the values may be inaccurate on certain Ubuntu versions (e.g., 20.
...and 24.04). The issue also occurs on older distributions such as Red Hat Enterprise Linux 8 (RHEL 8): Example: FROM duckdb_settings() WHERE name LIKE '%mem%'; The output contains values larger than 1000 PiB: ┌──────────────┬────────────┬─────────────────... - https://man.mtool.work/duckdb/2.0/clients/cli/known_issues.html
- Connect 8781
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...both duckdb.read_only and access_mode are supplied and disagree, the driver throws an error. Configuration Options DuckDB Settings Any DuckDB configuration option can be supplied when a connection is opened: the driver hands every option it does not rec...ognize as its own to DuckDB. Note that many of these settings can also be changed later on with a SET (or SET GLOBAL ) statement , or the equivalent PRAGMA . Properties connectionPrope...tionProperties); The available options are listed on the Configuration page and can also be queried at runtime with duckdb_settings() . The driver exposes the same list through the standard Driver.getPropertyInfo() call, which returns one DriverPropertyI... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Timestamp Types 8781
- Timestamps represent points in time. As such, they combine DATE and TIME information. They can be created using the type name followed by a string formatted according to the ISO 8601 format, YYYY-MM-DD hh:mm:ss[.zzzzzzzzz][+-TT[:tt]] , whic
...le calendars can be pulled from the icu_calendar_names() table function: SELECT name FROM icu_calendar_names() ORDER BY 1; Settings The current values of the TimeZone and Calendar settings are determined by the icu extension when it starts up. They can b...e queried from in the duckdb_settings() table function : SELECT * FROM duckdb_settings() WHERE name = 'TimeZone'; name value description input_type TimeZone Eur...ope/Amsterdam The current time zone VARCHAR SELECT * FROM duckdb_settings() WHERE name = 'Calendar'; name value description input_type Calendar gregorian The current calendar VARCHAR If you find t... - https://man.mtool.work/duckdb/2.0/sql/data_types/timestamp.html
- Migrating to DuckDB 2.0 8664
- DuckDB 2.0.0 is packed with new features and performance improvements, including query optimization and asynchronous I/O. It also ships a small set of breaking changes, most notably a new default storage format, which DuckDB versions before
...r version of DuckDB. Newer DuckDB version might introduce backward incompatible changes (possibly guarded by compatibility settings). See the storage page for migration strategy and more information: https://duckdb.org/internals/storage Warning In a depl...true and false are still accepted and map to 'preserve_case' and 'lowercase' , respectively. S3 URL Parameters Passing S3 settings as URL parameters (e.g., s3://bucket/file.csv?s3_access_key_id=... ) is disabled by default: the ? and the following text...with SET s3_enable_deprecated_url_parameters = true (available after loading the httpfs extension). Removed and Deprecated Settings The custom_profiling_settings setting was removed. Use tracked_metrics instead, see Profiling . The enable_http_logging an... - https://man.mtool.work/duckdb/2.0/operations_manual/migration.html
DuckDB 2.0 Documentation / man.mtool.work