Results of 1 - 10 of about 27 for Automatic (0.002 sec.)
- Backup Extension Repositories 13857
- The core and community extension repositories have backup servers (see duckdb-backup.org ): Repository Primary server Backup server core http://extensions.duckdb.org http://extensions.duckdb-backup.org community http://community-extensions.
...mmunity-extensions.duckdb-backup.org The backup servers serve byte-identical binaries, so signature checks are unaffected. Automatic Fallback Fallback is automatic: if the primary server is unreachable or returns a 5xx error, INSTALL retries the download... - https://man.mtool.work/duckdb/2.0/operations_manual/backup_extension_repositorie...
- Output Formats 12689
- The .mode dot command may be used to change the appearance of the tables returned in the terminal output. In addition to customizing the appearance, these modes have additional benefits. This can be useful for presenting DuckDB output elsew
...s that exceed the terminal size are displayed in a pager (such as less ) for easier navigation. The pager has three modes: automatic (default) – The pager is triggered when the result exceeds the row or column threshold. on – The pager is always used for...output. off – The pager is disabled. .pager on .pager off .pager automatic In automatic mode, the thresholds for triggering the pager can be configured: .pager set_row_threshold 50 .pager set_colum... - https://man.mtool.work/duckdb/2.0/clients/cli/output_formats.html
- I/O 9759
- Warning DuckDB ships with safe defaults. The configuration options described on this page are advanced options, so proceed with caution when changing them. Asynchronous I/O New Asynchronous I/O was introduced in DuckDB 2.0. Starting with v2
...d in UTF-8 DuckDB's native storage format Other formats, such as JSON files, use synchronous I/O. Asynchronous I/O is used automatically for the supported formats, including when they are read through data lake formats such as DuckLake . Thread Pools Duck...e size of the HTTP client pool can be tuned with the http_client_pool_capacity setting. By default the capacity is derived automatically from the number of CPU threads and asynchronous threads, bounded by the operating system file-descriptor limit, and ca...pped at 256. Resizing async_threads also resizes the automatic pool so that it tracks the asynchronous pool. To pin the pool to a fixed size, set a positive integer; use RESET http_clie... - https://man.mtool.work/duckdb/2.0/data/io.html
- Configuration 9463
- 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
...locale) calendar TimeZone The current time zone VARCHAR System (locale) timezone access_mode Access mode of the database ( AUTOMATIC , READ_ONLY or READ_WRITE ). VARCHAR automatic allocator_background_threads Whether to enable the allocator background thr...ans concurrent commits are blocked while the checkpoint is happening. UBIGINT 100000 auto_fallback_to_full_download Allows automatically falling back to full file downloads when possible. BOOLEAN true autoinstall_extension_repository Overrides the custom...om_extension_repository, if not specified. VARCHAR autoinstall_known_extensions Whether known extensions are allowed to be automatically installed when a query depends on them. BOOLEAN true autoload_known_extensions Whether known extensions are allowed to... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- CHECKPOINT Statement 9167
- The CHECKPOINT statement synchronizes data in the write-ahead log (WAL) to the database data file. Examples Synchronize data in the default database: CHECKPOINT; Synchronize data in the specified database: CHECKPOINT file_db; Synchronize da
...ggers vacuuming deleted rows, allowing space to be reclaimed after deletes/truncation. Syntax Checkpoint operations happen automatically based on the WAL size (see Configuration ). This statement is for manual checkpoint actions. Behavior The default CHEC...ions. Also see the related PRAGMA option for further behavior modification. Reclaiming Space When performing a checkpoint (automatic or otherwise), the space occupied by deleted rows is partially reclaimed. Note that this does not remove all deleted rows,... - https://man.mtool.work/duckdb/2.0/sql/statements/checkpoint.html
- S3 API Support 8887
- The httpfs extension supports reading/writing/ globbing files on object storage servers using the S3 API. S3 offers a standard API to read and write to remote files (while regular http servers, predating S3, do not offer a common write API)
...ixed file: SELECT * FROM 's3://⟨your-bucket⟩/⟨your_file⟩.parquet'; credential_chain Provider The credential_chain provider automatically fetches credentials using the AWS SDK (profiles, SSO, assumed roles, web identities, instance metadata, and more). It...s S3 BOOLEAN false REFRESH Set to auto to periodically refresh credentials (see the aws extension ) S3 , GCS , R2 STRING - Automatic Credential Refresh Independently of the REFRESH secret parameter, DuckDB automatically refreshes S3 credentials when a req...can create HMAC keys by following the Google Cloud documentation for managing HMAC keys . Note that the above secret will automatically have the correct Google Cloud Storage endpoint configured. Also note that GCS Secrets can also use both the CONFIG and... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
- Loading JSON 8887
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...er to correctly parse the JSON file. The read_json Function The read_json is the simplest method of loading JSON files: it automatically attempts to figure out the correct configuration of the JSON reader. It also automatically deduces types of columns. I...an error. Added in DuckDB 2.0. BOOL false compression The compression type for the file. By default this will be detected automatically from the file extension (e.g., t.json.gz will use gzip, t.json will use none). Options are none , gzip , zstd and auto...Whether or not an extra filename column should be included in the result. Since DuckDB 1.3.0, the filename column is added automatically as a virtual column and this option is only kept for compatibility reasons. BOOL false format Can be one of auto , uns... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- S3 and AWS Authentication 8591
- 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
...fig provider when you have static credentials, and the credential_chain provider when you want DuckDB to fetch credentials automatically through the AWS SDK. Situation Method Reference You have a static access key and secret config provider config provide...See the config provider documentation for the full details, including how to set an explicit ENDPOINT for non-AWS storage. Automatic Credentials: the credential_chain Provider The credential_chain provider fetches credentials automatically using the AWS S... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/authentication.html
- Connect 7998
- 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
...essMode::ReadOnly)?; let conn = Connection::open_with_flags("my_database.duckdb", config)?; AccessMode has three variants: Automatic (the default), ReadOnly , and ReadWrite . Thread Safety A Connection is Send but not Sync : it can be moved to another thr...s() accept a Config . Enable the feature in Cargo.toml with features = ["r2d2"] . Closing a Connection A Connection closes automatically when it is dropped (goes out of scope), which shuts down the underlying database. To close it explicitly and handle an... - https://man.mtool.work/duckdb/2.0/clients/rust/connecting.html
- Indexing 7998
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...computation to be 1.5× faster. Ordered Integers Another practical way to exploit ordering is to use the INTEGER type with automatic increments rather than UUID for columns queried using selective filters. In a scenario where a table contains out-of-order... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
DuckDB 2.0 Documentation / man.mtool.work