Results of 1 - 10 of about 68 for Allow (0.002 sec.)
- Securing Extensions 15260
- 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
...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 Extensions can only be loaded if signed from a core or community key. This...is the default security level. Any extension including unsigned Any extensions can be loaded. Set allow_unsigned_extensions = true at startup (e.g., duckdb -unsigned in the CLI). It cannot be changed while the database is runn...abilities in the current process. For example, attempting the following configuration changes will result in an error: SET allow_community_extensions = false; SET allow_community_extensions = true; Invalid Input Error: Cannot change allow_community_ex... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/securing_ext...
- Configuration 11729
- 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
...ator_flush_threshold Peak allocation threshold at which to flush the allocator after completing a task. VARCHAR 134217728B allow_asterisks_in_http_paths Allow '*' character in URLs users can query BOOLEAN false allow_community_extensions Allow loading...extensions build by the community. BOOLEAN true allow_extension_repositories Whether custom trusted extension repositories are 'allowed', 'forbidden' (which also distrusts exis...ositories, but keeps trusting existing ones). While the database is running the setting can only move from 'undecided' to 'allowed' or 'forbidden', or from 'allowed' to 'forbidden'. VARCHAR undecided allow_extensions_metadata_mismatch Allow to load ex... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Securing DuckDB 10523
- 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
...several non-SQL APIs that can be used to interact with the database. For example, there is a relational API in Python that allows building queries programmatically. These APIs accept user input such as file paths, table names, column names, and filter...he DuckDB team, so only install community extensions from sources you trust. To disable community extensions entirely: SET allow_community_extensions = false; Serving DuckDB over the Network With the quack extension , a DuckDB process can act as a ser...he server binds to localhost by default; for remote access, put it behind a TLS-terminating reverse proxy instead of using allow_other_hostname . Note that duckdb -serve stores its token in a persistent (unencrypted) quack secret. For authentication a... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Extension Distribution 10353
- Platforms Extension binaries are distributed for several platforms (see below). For platforms where packages for certain extensions are not available, users can build them from source and install the resulting binaries manually . Most offic
...B in a secure manner. If you wish to load your own extensions or extensions from third-parties you will need to enable the allow_unsigned_extensions flag. To load unsigned extensions using the CLI client , pass the -unsigned flag to it on startup: duc...b -unsigned Now any extension can be loaded, signed or not: LOAD './some/local/ext.duckdb_extension'; For client APIs, the allow_unsigned_extensions database configuration options needs to be set, see the respective Client API docs . For example, for...ry's segments. Skipping the Compatibility Check For debugging purposes, extension developers can skip this check using the allow_extensions_metadata_mismatch setting. This lets INSTALL and UPDATE EXTENSIONS accept extensions with mismatching or invali... - https://man.mtool.work/duckdb/2.0/extensions/extension_distribution.html
- Iceberg Functions 8977
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...ble from a path, without requiring an attached catalog: SELECT count(*) FROM iceberg_scan('data/iceberg/lineitem_iceberg', allow_moved_paths = true); count_star() 51793 The path can also point directly to a metadata file, or to an object store such as...Configuration Error about manifest_entry.sequence_number . SELECT * FROM iceberg_metadata('data/iceberg/lineitem_iceberg', allow_moved_paths = true); manifest_path manifest_sequence_number manifest_content status content file_path file_format record_c...item_iceberg/metadata/snap-7635660646343998149-1-10eaca8a-1e1c-421e-ad6d-b232e5ee23d3.avro iceberg_snapshots does not take allow_moved_paths , snapshot_from_id or snapshot_from_timestamp as parameters. iceberg_column_stats The iceberg_column_stats fun... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- Iceberg Extension 8453
- The iceberg extension implements support for the Apache Iceberg open table format . There are two ways to work with Iceberg in DuckDB: Individual tables are read directly from storage, by pointing at a table's metadata. This requires no cat
...erg_scan function to read an Iceberg table from a path: SELECT count(*) FROM iceberg_scan('data/iceberg/lineitem_iceberg', allow_moved_paths = true); count_star() 51793 The allow_moved_paths option ensures that some path resolution is performed, which...allows scanning Iceberg tables that are moved. You can also directly specify the current manifest in the query, this may be reso...available snapshots: -- Read a specific snapshot by id SELECT count(*) FROM iceberg_scan('data/iceberg/lineitem_iceberg', allow_moved_paths = true, snapshot_from_id = 7635660646343998149); -- Read the snapshot that was current at a given time SELECT... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/overview.html
- Troubleshoot 8027
- Overview This page collects common issues encountered when using DuckDB-Wasm, together with their workarounds. If you run into a problem that is not covered here, search the duckdb-wasm issue tracker on GitHub. Network Error When Querying R
...st, so it is subject to the browser's CORS policy and every request is upgraded to HTTPS. The server hosting the data must allow (using CORS headers) the origin that hosts the DuckDB-Wasm instance to read it. If the server does not send the required h...execute 'send' on 'XMLHttpRequest' For example, when querying files from Amazon S3, configure the bucket's CORS policy to allow GET and HEAD requests: [ { "AllowedHeaders": ["*"], "AllowedMethods": ["GET", "HEAD"], "AllowedOrigins": ["*"], "ExposeHea...n_repository = '⟨https://some.url.com⟩' , the GET requests for the extension files must be CORS enabled for the browser to allow the connection, exactly as for remote data files above. Extensions remain signed regardless of where they are served, so c... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Versioning of Extensions 7942
- Extension Versioning Most software has some sort of version number. Version numbers serve a few important goals: Tie a binary to a specific state of the source code Allow determining the expected feature set Allow determining the state of t
...he APIs Allow efficient processing of bug reports (e.g., bug #1337 was introduced in version v3.4.5 ) Allow determining chronological or...htly build of a specific extension, but don't necessarily want to switch to using the nightly build of DuckDB itself. This allows using a specific bleeding-edge feature while limiting the exposure to unstable code. To achieve this, Core Extensions ten... - https://man.mtool.work/duckdb/2.0/extensions/versioning_of_extensions.html
- Command Line Arguments 7857
- The table below summarizes DuckDB's command line options. To list all command line options, use the command: duckdb -help For a list of dot commands available in the CLI shell, see the Dot Commands page . Argument Description -agent Render
...ode to table -ui Loads and starts the DuckDB UI . If the UI is not yet installed, it installs the ui extension -unredacted Allow printing unredacted secrets . Sets the allow_unredacted_secrets option to true -unsigned Allow loading of unsigned extensi... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Extension Repositories 7772
- New Support for custom extension repositories was introduced in DuckDB 2.0. This feature is currently work-in-progress and the syntax may still change. By default, DuckDB installs extensions from its built-in repositories ( core , core_nigh
...are trusted to sign the extensions served from it. Enabling Custom Repositories Adding custom repositories is gated by the allow_extension_repositories setting. It has three values: undecided (the default): adding new repositories is blocked, but exis...ting repositories remain trusted. allowed : custom repositories can be added. forbidden : adding new repositories is blocked and existing custom repositories are...distrusted. While the database is running, the setting can only move from undecided to allowed or forbidden , or from allowed to forbidden . To opt in: SET allow_extension_repositories = 'allowed'; Creating a Reposi... - https://man.mtool.work/duckdb/2.0/extensions/extension_repositories.html
DuckDB 2.0 Documentation / man.mtool.work