Results of 1 - 7 of about 7 for scoped (0.001 sec.)
- Secrets Manager 12868
- 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
...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_s...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 ru...on clause: CREATE SECRET my_secret IN connection ( TYPE s3, KEY_ID 'my_secret_key', SECRET 'my_secret_value' ); Connection-scoped secrets are always temporary. This lets different connections hold secrets of the same type and scope without clashing. De... - https://man.mtool.work/duckdb/2.0/configuration/secrets_manager.html
- Quack Remote Protocol 10105
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...DETACH remote_db; -- detach from the remote database The attached catalog also exposes a query table macro for ad-hoc SQL scoped to that attachment: {:.codebox-client} FROM remote_db.query('SELECT 42'); ATTACH binds the remote's table definitions on t...ts page for details. Authentication Clients pass the authentication token to the server in one of two ways: a quack secret scoped to the server URI or an explicit TOKEN option on ATTACH / quack_query . See Security for the full picture. We recommend us...ing a secret scoped to the server URI: {:.codebox-client} CREATE SECRET ( TYPE quack, TOKEN '⟨MY_QUACK_TOKEN_01234567890ABCDEF⟩', SCOPE 'quack... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Connect 9415
- Overview The Go client works through the standard database/sql types: a *sql.DB is a pool of connections to a DuckDB database. This page covers opening in-memory and file-backed databases, passing DuckDB configuration options, running initi
...cement scans and log storage , which are registered on the Connector itself. Connection-Local Operations Some features are scoped to a single connection rather than the pool: profiling, registering user-defined functions, and the Appender all act on on...documentation for how connections and threads interact. Connection Lifetime Temporary objects such as temporary tables are scoped to a connection. When code closes a connection, database/sql may return it to the pool as an idle connection rather than a... - https://man.mtool.work/duckdb/2.0/clients/go/connecting.html
- Security 8488
- This page covers Quack's security posture end to end: what the server exposes, what stays local, the role of a TLS-terminating reverse proxy, and the authentication / authorization callbacks the server runs on every connection and every que
...returns it in the auth_token column. Clients have to present this token on every connection, either through a quack secret scoped to the server URI or via the explicit TOKEN option in the ATTACH statement / quack_query function call. The default authen...tion_function or quack_authorization_function at the function name. Python UDFs registered through con.create_function are scoped to the connection that created them. Quack invokes each callback on a fresh server-side connection, so Python UDFs are not... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Legacy Authentication Scheme for S3 API 8015
- 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
...g has been explicitly set to false , it cannot be re-enabled in the same database instance. Instead of URL parameters, use scoped secrets to use different credentials for different paths. Aside from the global S3 configuration described above, specific... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Reference 7324
- This page lists the functions, settings, and log types exposed by the quack extension . For a tour of the protocol, start with the Overview . Function Reference Server Management Function Description quack_serve(⟨listen_uri⟩, ...) Start a s
...zation The auth callbacks are evaluated on a fresh server-side connection every time, so the two settings below are global-scoped ( SET GLOBAL ). A plain SET on these is forwarded to the global slot automatically. Use RESET GLOBAL to restore the defaul... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- CREATE TABLE Statement 7324
- The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 (i INTEGER, j INTEGER); Create a table with a primary key: CREATE TABLE t1 (id INTEGER PRIMARY KEY, j V
...of information (indexes, constraints, default values, etc.) are not copied. Temporary Tables Temporary tables are session scoped, meaning that only the specific connection that created them can access them and once the connection to DuckDB is closed t... - https://man.mtool.work/duckdb/2.0/sql/statements/create_table.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work