Results of 1 - 10 of about 29 for scope (0.002 sec.)
- HTTP(S) Support 13183
- With the httpfs extension, it is possible to directly query files over the HTTP(S) protocol. This works for all files supported by DuckDB or its various extensions, and provides read-only access. SELECT * FROM 'https://domain.tld/file.exten
...HTTP_PROXY '⟨http_proxy_url⟩', HTTP_PROXY_USERNAME '⟨username⟩', HTTP_PROXY_PASSWORD '⟨password⟩' ); You can also set the scope for an HTTP proxy using the SCOPE keyword. CREATE SECRET http_proxy ( TYPE HTTP, SCOPE ['⟨https://duckdb.org⟩', '⟨https://..._proxy_url⟩'; SET http_proxy_username = '⟨username⟩'; SET http_proxy_password = '⟨password⟩'; Note: You cannot set a proxy scope using the configurations options. Using a Custom Certificate File To use the httpfs extension with a custom certificate fi...ECRET disable_ssl ( TYPE HTTP, VERIFY_SSL 0 ); To enable it again for one specific endpoint, you can take advantage of the scope parameter: CREATE SECRET enable_ssl_for_your_website ( TYPE HTTP, SCOPE 'https://⟨your-website.com⟩', VERIFY_SSL 1 );... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/https.html
- SET and RESET Statements 12399
- 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
...ption 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...) only for the current session attached to a DuckDB instance. LOCAL : Not yet implemented. When not specified, the default scope for the configuration option is used. For most options this is GLOBAL . GLOBAL settings apply to the current DuckDB instan...tions use their defaults unless they are set again. For example, in DuckDB 2.0 the TimeZone option defaults to the SESSION scope, so the following two statements are equivalent, and both change the time zone for the current session only: SET TimeZone... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Secrets Manager 11094
- The Secrets manager provides a unified user interface for secrets across all backends that use them. Secrets can be scoped, so different storage prefixes can have different secrets, allowing for example to join data across organizations in
...h type, there are one or more “secret providers” that specify how the secret is created. Secrets can also have an optional scope, which is a file path prefix that the secret applies to. When fetching a secret for a path, the secret scopes are compared...s using different providers check out the respective pages on httpfs and azure . Temporary Secrets To create a temporary unscoped secret to access S3, we can now use the following: CREATE SECRET my_secret ( TYPE s3, KEY_ID 'my_secret_key', SECRET 'my_...that setting the value of the home_directory configuration option has no effect on the location of the secrets. Connection-Scoped Secrets New As of DuckDB 2.0, a secret can be stored in connection-scoped storage so that it is only visible to queries r... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- SET VARIABLE and RESET VARIABLE Statements 9789
- DuckDB supports the definition of SQL-level variables using the SET VARIABLE and RESET VARIABLE statements. Variable Scopes DuckDB supports two levels of variable scopes: Scope Description SESSION Variables with a SESSION scope are local to
...you and only affect the current session. GLOBAL Variables with a GLOBAL scope are specific configuration option variables that affect the entire DuckDB instance and all sessions. For example, see Set... - https://man.mtool.work/duckdb/2.0/sql/statements/set_variable.html
- Configuration 9658
- 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
...; SET enable_logging = true; SET logging_level = 'debug'; Write a single log message with the debug level and a connection scope: SELECT write_log('A new client has connected.', level := 'debug', scope := 'connection'); Write a single log message with...a debug level and a connection scope and a custom log_type : SELECT write_log( 'A new duck has connected to the lake.', level := 'debug', scope := 'connection'...ads 10 Query a specific setting: SELECT * FROM duckdb_settings() WHERE name = 'threads'; name value description input_type scope threads 1 The number of total threads used by the system. BIGINT GLOBAL Show a list of all available settings: SELECT * FR... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Lance Extension 9397
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...://... ), configure a TYPE lance secret using the Secrets Manager : CREATE SECRET ( TYPE lance, PROVIDER credential_chain, SCOPE 's3://bucket/' ); SELECT * FROM 's3://⟨bucket/path/to/out.lance⟩' LIMIT 10; Write a Lance Dataset Use the COPY ... TO ......ORMAT lance, MODE 'overwrite', WRITE_EMPTY_FILE true ); To write to s3://... paths, configure a TYPE lance secret for that scope using the Secrets Manager : CREATE SECRET ( TYPE lance, PROVIDER credential_chain, SCOPE 's3://⟨bucket⟩/' ); COPY (SELECT... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
- DuckDB_% Metadata Functions 8875
- 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
...tifier of the context. The context_id column in the duckdb_logs table is a foreign key that points to this column. UBIGINT scope The scope of the context ( connection , database or file_opener ). VARCHAR connection_id The identifier of the connection..... VARCHAR persistent Denotes whether the secret is persistent. BOOLEAN storage The backend for storing the secret. VARCHAR scope The scope of the secret. VARCHAR[] secret_string Returns the content of the secret as a string. Sensitive pieces of inform...VARCHAR description A description of the setting. VARCHAR input_type The logical data type of the setting's value. VARCHAR scope The scope of the setting ( LOCAL or GLOBAL ). VARCHAR New As of DuckDB 2.0, duckdb_settings() accepts the debug , deprecat... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Azure Extension 8484
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...elow. These rules apply to every provider: If you need to define different secrets for different storage accounts, use the SCOPE configuration . Note that the SCOPE requires a trailing slash ( SCOPE 'az://⟨my_storage_account⟩.blob.core.windows.net/' )...kDB CLI with verbose logs: AZURE_LOG_LEVEL=verbose duckdb CREATE SECRET myaccount ( TYPE azure, PROVIDER credential_chain, SCOPE 'az://⟨my_storage_account⟩.blob.core.windows.net/' ); SELECT count(*) FROM 'az://⟨my_storage_account⟩.blob.core.windows.ne... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Known Issues 8223
- 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.
...────────┬─────────────────────────────────────────────┬────────────┬─────────┐ │ name │ value │ description │ input_type │ scope │ │ varchar │ varchar │ varchar │ varchar │ varchar │ ├──────────────┼────────────┼───────────────────────────────────────... - https://man.mtool.work/duckdb/2.0/clients/cli/known_issues.html
- Appender 8223
- The Appender can be used to load bulk data into a DuckDB database. It is available in the C, C++, Go, Java, Julia, Node.js, Python, and Rust clients. This page describes how the Appender behaves across clients and shows a minimal example in
...ht not be immediately visible in the system. The cache is flushed automatically when the Appender is closed or goes out of scope, and it can also be flushed manually. Once the Appender has been flushed or closed, all of its data has been written to th...ows are built with beginRow() , append() , and endRow() . Using try-with-resources flushes and closes it at the end of the scope: try (var appender = conn.createAppender(DuckDBConnection.DEFAULT_SCHEMA, "tbl")) { appender.beginRow(); appender.append(1... - https://man.mtool.work/duckdb/2.0/data/appender.html
DuckDB 2.0 Documentation / man.mtool.work