Results of 1 - 10 of about 41 for Config (0.003 sec.)
- Configuration 14905
- 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 so...me configuration options duckdb_set_config(config, "access_mode", "READ_WRITE"); // or READ_ONLY duckdb_set_config(config, "threads"..., "8"); duckdb_set_config(config, "max_memory", "8GB"); duckdb_set_config(config, "default_order", "DESC"); // open the database using the configura... - https://man.mtool.work/duckdb/2.0/clients/c/config.html
- Connect 11998
- Overview Every DuckDB feature reachable from Rust starts with a Connection . Opening in-memory and file-backed databases, configuring a database instance with Config , opening read-only, pooling connections across threads, the crate's threa
...xits. A file-backed database is created if the file does not exist. The extension may be .db , .duckdb , or anything else. Configuring a Connection To set DuckDB options when the database instance starts, build a Config and open the connection with Con...nection::open_with_flags() (or Connection::open_in_memory_with_flags() ). Config uses a builder style: each method consumes the config and returns it, and each returns a Result because DuckDB validates t...he option: use duckdb::{Config, Connection, Result}; let config = Config::default() .max_memory("4GB")? .threads(4)?; let conn = Connection::open_with_fl... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- S3 and AWS Authentication 9729
- This page is the entry point for authenticating to S3 and other AWS services from DuckDB. Authentication is configured using secrets , and the detailed reference material lives on the S3 API Support and AWS Extension pages. The sections bel
...od to use and link to the relevant reference. Choosing an Authentication Method There are two S3 secret providers. Use the config provider when you have static credentials, and the credential_chain provider when you want DuckDB to fetch credentials aut...omatically through the AWS SDK. Situation Method Reference You have a static access key and secret config provider config provider Credentials come from ~/.aws/credentials or ~/.aws/config profiles credential_chain with a profil..._chain provider You connect to Amazon RDS or Aurora with IAM authentication rds secret Amazon RDS (IAM Authentication) The config provider is part of the httpfs extension and works with any S3-compatible storage. The credential_chain provider is AWS-sp... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- Complete API 9558
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
..._or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state...ckdb_database * out_database ); duckdb_state duckdb_open_ext ( const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_close ( duckdb_database * database ); duckdb_state duckdb_connect ( duckdb_datab...ry_version (); duckdb_value duckdb_get_table_names ( duckdb_connection connection , const char * query , bool qualified ); Configuration duckdb_state duckdb_create_config ( duckdb_config * out_config ); size_t duckdb_config_count (); duckdb_state duckd... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- AWS Extension 8921
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...it manually, run: INSTALL AND LOAD aws; In most cases, the aws extension works in conjunction with the httpfs extension . Configuration and Authentication Tip For an overview of the available methods and guidance on which one to use, see the S3 and AW...S Authentication page. The preferred way to configure and authenticate to AWS S3 endpoints is to use secrets . There are two S3 secret providers: The config provider, where...that will be tried in order. For example: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN 'env;config' ); The possible values for CHAIN are the following: config sts sso env instance process web_identity (for IAM Roles for S... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- Startup & Shutdown 8890
- To use DuckDB, you must first initialize a duckdb_database handle using duckdb_open() . duckdb_open() takes as parameter the database file to read and write from. The special value NULL ( nullptr ) can be used to create an in-memory databas
..._or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_destroy_instance_cache ( duckdb_instance_cache * instance_cache ); duckdb_state...ckdb_database * out_database ); duckdb_state duckdb_open_ext ( const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); void duckdb_close ( duckdb_database * database ); duckdb_state duckdb_connect ( duckdb_datab..._or_create_from_cache ( duckdb_instance_cache instance_cache , const char * path , duckdb_database * out_database , duckdb_config config , char ** out_error ); Parameters instance_cache : The instance cache in which to create the database, or from whic... - https://man.mtool.work/duckdb/2.0/clients/c/connect.html
- Unit Tester Configuration 8750
- 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-sh...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...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 s... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/test_configuration.html
- Parquet Encryption 8719
- Starting with version 0.10.0, DuckDB supports reading and writing encrypted Parquet files. DuckDB broadly follows the Parquet Modular Encryption specification with some limitations . Reading and Writing Encrypted Files Using the PRAGMA add_
...t Files After specifying the key (e.g., key256 ), files can be encrypted as follows: COPY tbl TO 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Reading Encrypted Parquet Files An encrypted Parquet file using a specific key (e.g., key256 ), c...an then be read as follows: COPY tbl FROM 'tbl.parquet' (ENCRYPTION_CONFIG {footer_key: 'key256'}); Or: SELECT * FROM read_parquet('tbl.parquet', encryption_config = {footer_key: 'key256'}); Intero...uet specification allows encryption of individual columns with different keys, e.g.: COPY tbl TO 'tbl.parquet' (ENCRYPTION_CONFIG { footer_key: 'key256', column_keys: {key256: ['col0', 'col1']} }); However, this is unsupported at the moment and will ca... - https://man.mtool.work/duckdb/2.0/data/parquet/encryption.html
- Logging 8206
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...not be queried: duckdb_logs , duckdb_logs_parsed() and truncate_duckdb_logs() all return an error. It also does not accept configuration options such as storage_config or storage_buffer_size . To query logs in the CLI, switch to a queryable storage suc.... Logging to stdout CALL enable_logging(storage = 'stdout'); Logging to File CALL enable_logging(storage = 'file', storage_config = {'path': 'path/to/store/logs'}); or using the equivalent shorthand: CALL enable_logging(storage_path = 'path/to/store/lo...ntries are stored separately with context_id s referencing the context information. Log storage Normalized memory yes file configurable stdout no For file storage, you can switch between normalized and denormalized by providing a path to a directory (f... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Write User Defined Functions 8113
- Overview The Go client can register user-defined functions written in Go: scalar functions that map input rows to a single output value, and table functions that produce a set of rows. It can also register a replacement scan that rewrites a
...h. Scalar Functions A scalar function is a Go type that implements the duckdb.ScalarFunc interface, which has two methods: Config() returns a duckdb.ScalarFuncConfig declaring the input parameter types, the result type, and, for a variadic function, th...my_length(VARCHAR) -> INTEGER , adapted from the client's scalar_udf example : type varcharLen struct{} func (*varcharLen) Config() duckdb.ScalarFuncConfig { inputType, err := duckdb.NewTypeInfo(duckdb.TYPE_VARCHAR) check(err) resultType, err := duckdb....NewTypeInfo(duckdb.TYPE_INTEGER) check(err) return duckdb.ScalarFuncConfig{ InputTypeInfos: []duckdb.TypeInfo{inputType}, ResultTypeInfo: resultType, } } func (*varcharLen) Executor() duckdb.Scalar... - https://man.mtool.work/duckdb/2.0/clients/go/functions.html
DuckDB 2.0 Documentation / man.mtool.work