Results of 1 - 10 of about 109 for configuration (0.002 sec.)
- Configuration 12906
- Configuration options can be provided to change different settings of the database system. Note that many of these settings can be changed later on using PRAGMA statements as well. The configuration object should be created, filled with val
...ues and passed to duckdb_open_ext . Example duckdb_database db; duckdb_config config; // create the configuration object if (duckdb_create_config(&config) == DuckDBError) { // handle error } // set some configuration options duckdb_set_...et_config(config, "max_memory", "8GB"); duckdb_set_config(config, "default_order", "DESC"); // open the database using the configuration if (duckdb_open_ext(NULL, &db, config, NULL) == DuckDBError) { // handle error } // cleanup the configuration object duckd..., const char * option ); void duckdb_destroy_config ( duckdb_config * config ); duckdb_create_config Initializes an empty configuration object that can be used to provide start-up options for the DuckDB instance through duckdb_open_ext . The duckdb_config mu... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- SET and RESET Statements 12626
- The SET statement modifies the provided DuckDB configuration option at the specified scope. Examples Update the memory_limit configuration value: SET memory_limit = '10GB'; Configure the system to use 1 thread: SET threads = 1; Or use the T
...O keyword: SET threads TO 1; Change configuration option to default value: RESET threads; Retrieve configuration value: SELECT current_setting('threads'); Set the default c...: SET GLOBAL default_order = 'DESC'; Set the default threads globally: SET GLOBAL threads = 4; Syntax SET updates a DuckDB configuration option to the provided value. RESET The RESET statement changes the given DuckDB configuration option to the default value.... Scopes Configuration options can have different scopes: GLOBAL : Configuration value is used (or reset) across the entire DuckDB instance. SESS... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- ODBC API on Windows 10030
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...a setup DLL used by the Windows ODBC Data Source Administrator tool. odbc_install.exe : an installation script to aid the configuration on Windows. Decompress the archive to a directory (e.g., duckdb_odbc ). The odbc_install.exe binary performs the configura...re required. In case of a non-administrator, a User Account Control prompt will occur. odbc_install.exe adds a default DSN configuration into the ODBC registries with a default database :memory: . DSN Windows Setup After the installation, it is possible to ch...ange the default DSN configuration or add a new one using the Windows ODBC Data Source Administrator tool odbcad32.exe . It also can be launched through the... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- Unit Tester Configuration 9928
- There are three ways of setting options for the unit tester: Command Line Arguments Configuration File Environment Variables Configuration Options List See the Configuration Options List for the full list of available options. Command Line
...Arguments See the Configuration Options List for all available options. # booleans unittest --checkpoint-on-shutdown unittest --no-checkpoint-on-shutdown...t --checkpoint-wal-size 100000 Command line options --settings , --on-init and --init-script can be used to specify DuckDB configuration . Configuration File A JSON file that can be passed in using --test-config . See the Configuration Options List for all av...checkpoint_wal_size": 100000, "checkpoint_on_shutdown": "false" } The following additional options can also be used in the configuration file: Option Description extends List of config files to extend from inherit_skip_tests Path of config to inherit skip_tes... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Legacy Authentication Scheme for S3 API 9431
- 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
...ion token: SET s3_session_token = '⟨aws_session_token⟩'; The aws extension allows for loading AWS credentials. Per-Request Configuration Deprecated Per-request configuration through S3 URL query parameters is deprecated and disabled by default in DuckDB 2.0:.... Instead of URL parameters, use scoped secrets to use different credentials for different paths. Aside from the global S3 configuration described above, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of...credentials, regions, etc. These are used by including them on the S3 URI as query parameters. All the individual configuration values listed above can be set as query parameters. For instance: SELECT * FROM 's3://bucket/file.parquet?s3_access_key_id... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Securing DuckDB 8999
- 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 application, also consult the...onal hardening for DuckDB deployments. However, they should not be relied upon as comprehensive security mechanisms in all configurations. These settings are designed as defense-in-depth measures to limit the impact of potential security issues, but they cann...in the current working directory: Permission Error: Cannot access file "test.csv" - file system operations are disabled by configuration Locking Configurations Security-related configuration settings generally lock themselves for safety reasons. For example,... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- ODBC API on macOS 8897
- 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 :
...duckdb_odbc-macos-arm64.zip -d duckdb_odbc There are two ways to configure the ODBC driver, either by initializing via the configuration files, or by connecting with SQLDriverConnect . A combination of the two is also possible. Furthermore, the ODBC driver su...pports all the configuration options included in DuckDB. If a configuration is set in both the connection string passed to SQLDriverConnect and in the...odbc.ini file, the one passed to SQLDriverConnect will take precedence. For the details of the configuration parameters, see the ODBC configuration page . After the configuration, to validate the installation, it is possible to use... - https://man.mtool.work/duckdb/2.0/clients/odbc/macos.html
- Securing Extensions 8184
- DuckDB has a powerful extension mechanism, which has the same privileges as the user running DuckDB's (parent) process. This introduces security considerations. Therefore, we recommend reviewing the configuration options listed on this page
...f Security Levels for Extensions DuckDB offers the following security levels for extensions. Usable extensions Description Configuration core Extensions can only be loaded if signed from a core key. SET allow_community_extensions = false core and community Ex...true at startup (e.g., duckdb -unsigned in the CLI). It cannot be changed while the database is running. Security-related configuration settings lock themselves , i.e., it is only possible to restrict capabilities in the current process. For example, attempt...ing the following configuration changes will result in an error: SET allow_community_extensions = false; SET allow_community_extensions = true; Invalid In... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- ODBC API on Linux 7917
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...package contains the following files: libduckdb_odbc.so : the DuckDB driver. unixodbc_setup.sh : a setup script to aid the configuration on Linux. To extract them, run: batch mkdir duckdb_odbc && unzip duckdb_odbc-linux-amd64.zip -d duckdb_odbc The unixodbc_s...etup.sh script performs the configuration of the DuckDB ODBC Driver. It is based on the unixODBC package that provides some commands to handle the ODBC setup and te...laced to the user home directory /home/⟨username⟩ or in the system /etc directory. The Driver Manager prioritizes the user configuration files over the system files. For the details of the configuration parameters, see the ODBC configuration page .... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- Configuration 7866
- 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
...ng the RESET statement . The values of configuration options can be queried via the current_setting() scalar function or using the duckdb_settings() table function . For examp...interface for secrets across all backends (e.g., AWS S3) that use them. Schema and Search Path The schema and search_path configuration options both control the search path : the ordered list of schemas that DuckDB consults to resolve unqualified table, view...ference below and documented in more detail on the I/O page , together with the related http_client_pool_capacity setting. Configuration Reference Configuration options come with different default scopes : GLOBAL and LOCAL . Below is a list of all available c... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
DuckDB 2.0 Documentation / man.mtool.work