Results of 1 - 10 of about 43 for session (0.002 sec.)
- SET and RESET Statements 14145
- 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
...t value: RESET threads; Retrieve configuration value: SELECT current_setting('threads'); Set the default collation for the session: SET SESSION default_collation = 'nocase'; Set a Global Variable Set the default sort order globally: SET GLOBAL default_o...tion options can have different scopes: GLOBAL : Configuration value is used (or reset) across the entire DuckDB instance. SESSION : Configuration value is used (or reset) only for the current session attached to a DuckDB instance. LOCAL : Not yet imple...ation options 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 Tim... - https://man.mtool.work/duckdb/2.0/sql/statements/set.html
- Deploying Quack 9995
- This page collects deployment recipes for running a public-facing Quack server. Today there is one recipe (AWS EC2), we will introduce more over time. On AWS EC2 The fastest way to get a public-facing Quack server is the one-click AWS Cloud
...bout two minutes for CREATE_COMPLETE . Open the stack's Outputs tab. Click the ConnectURL value to open a shell.duckdb.org session pre-wired to the new instance, or copy QuackURI and Token to connect from a local DuckDB session (see below). The stack de...cal DuckDB Copy QuackURI and Token from the stack's Outputs tab and substitute below: -- Register the credentials once per session. CREATE SECRET quack_credentials ( TYPE quack, SCOPE '⟨uri⟩', -- e.g., 'quack:54.1.2.3.nip.io:443' TOKEN '⟨token⟩' ); -- W...'); -- Anything else you'd normally run, shipped verbatim to the remote. FROM quack_query('⟨uri⟩', 'SELECT 1 + 1'); Sticky Session via ATTACH ATTACH keeps server-side state (temp tables, SET variables) across calls, which quack_query alone does not. ATT... - https://man.mtool.work/duckdb/2.0/quack/setup/deployment.html
- Legacy Authentication Scheme for S3 API 9810
- 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
...'⟨aws_secret_access_key⟩'; Alternatively, temporary S3 credentials are also supported. They require setting an additional session token: SET s3_session_token = '⟨aws_session_token⟩'; The aws extension allows for loading AWS credentials. Per-Request Con...FAULT_REGION s3_region AWS_DEFAULT_REGION s3_access_key_id AWS_ACCESS_KEY_ID s3_secret_access_key AWS_SECRET_ACCESS_KEY s3_session_token AWS_SESSION_TOKEN s3_endpoint DUCKDB_S3_ENDPOINT s3_use_ssl DUCKDB_S3_USE_SSL s3_requester_pays DUCKDB_S3_REQUESTER_... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- SET VARIABLE and RESET VARIABLE Statements 9810
- 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 a...nd all sessions. For example, see Set a Global Variable . SET VARIABLE The SET VARIABLE statement assigns a value to a variable, which ca...ing a variable with the $name shorthand was introduced in DuckDB 2.0. As a shorthand for getvariable , you can reference a session variable directly with $name : SET VARIABLE my_var = 30; SELECT 20 + $my_var AS total; total 50 For a variable that is set... - https://man.mtool.work/duckdb/2.0/sql/statements/set_variable.html
- Quack Remote Protocol 9471
- 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
...me:port with the port defaulting to 9494 . Server-Side Usage Starting a Server A server is started from an existing DuckDB session. Everything that the session can see (in-memory tables, attached files, schemas) becomes reachable over the remote protoco...age There are three ways to talk to a Quack server: ATTACH 'quack:host' AS name followed by CONNECT name : route the whole session to the remote . This is the recommended approach. ATTACH 'quack:host' AS name : attach the remote as a full catalog and qu...mple, with an Iceberg catalog using lazy table resolution), see ATTACH Fails to Bind a Remote Table Definition . Routing a Session with CONNECT Once a remote is attached, the CONNECT statement routes the whole session to it, so that subsequent queries e... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Connect 9378
- Overview Every DuckDB feature reachable from Java starts with a Connection . This page covers the JDBC URL forms the driver accepts, how DuckDB and driver options are passed and which of them win, how connections come to share (or not share
...s. Note Options passed at connection time are applied as global settings on the database instance. A setting that only has session scope has to be applied with a SET statement after connecting; setting it at connection time fails with Could not set opti...c_jfr_memory_monitor Enable JFR memory monitoring for the connection's database instance. See Memory Monitoring with JFR . session_init_sql_file Run the SQL in the given file before handing over the connection. URL-only, see Running SQL at Connection St...artup . session_init_sql_file_sha256 Expected SHA-256 digest of the session init SQL file. URL-only. Running SQL at Connection Startup The... - https://man.mtool.work/duckdb/2.0/clients/java/connecting.html
- Security 9286
- 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
...xposes the full SQL surface of the underlying DuckDB instance, including read and write access to every table the server's session can see. Because of this, the extension ships with conservative defaults that prevent accidental exposure: The server requ...connection . That means they can read tables, call other UDFs, and reference extensions, but each invocation starts a new session and cannot rely on session-local state. Authentication Hook The server invokes the authentication function by issuing the...following SQL statement on every CONNECTION_REQUEST call: SELECT ⟨quack_authentication_function⟩(⟨session_id⟩, ⟨client_token⟩, ⟨server_token⟩); The arguments are defined as follows: session_id : Server-generated session id (rand... - https://man.mtool.work/duckdb/2.0/quack/security.html
- LOAD / INSTALL Statements 9193
- INSTALL The INSTALL statement downloads an extension so it can be loaded into a DuckDB session. Examples Install the httpfs extension: INSTALL httpfs; Install the h3 community extension : INSTALL h3 FROM community; Syntax LOAD The LOAD stat
...ement loads an installed DuckDB extension into the current session. LOAD does not install extensions: if the extension is not installed yet, LOAD fails with an error asking you to run INSTA...statement was introduced in DuckDB 2.0. The INSTALL AND LOAD statement installs an extension and loads it into the current session in a single step. It is equivalent to running INSTALL followed by LOAD . If the extension is already installed, the instal... - https://man.mtool.work/duckdb/2.0/sql/statements/load_and_install.html
- Prepared Statements 9116
- DuckDB supports prepared statements where parameters are substituted when the query is executed. This can improve readability and is useful for preventing SQL injections . Syntax There are three syntaxes for denoting parameters in prepared
...g the CLI client, the statement is executed as follows. EXECUTE query_person(name_start_letter := 'B', minimum_age := 40); Session Variables as Default Values New Using session variables as default values for named parameters was introduced in DuckDB 2....0. When a named parameter is not supplied at execution time, DuckDB fills it from the session variable of the same name, if one is set. An explicit argument always takes precedence over the variable. SET VARIABLE mul...rameters only. Auto-incremented ( ? ) and positional ( $1 ) parameters are matched by position and are never filled from a session variable, even one whose name is a number such as 1 . Dropping Prepared Statements: DEALLOCATE To drop a prepared statemen... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/prepared_statements.html
- AWS Extension 9024
- 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
...ce Accounts (IRSA) — commonly used on Amazon EKS — use the web_identity chain together with a role ARN and a token file. A SESSION_NAME can optionally be set: CREATE OR REPLACE SECRET secret ( TYPE s3, PROVIDER credential_chain, CHAIN 'web_identity', AS...steps. First, configure an SSO-enabled profile in ~/.aws/config , either by running aws configure sso or by adding an sso_session and sso_account_id to the profile manually. Second, sign in from the command line, which opens a browser to complete authe...ET secret ( TYPE s3, PROVIDER credential_chain, CHAIN 'sso', PROFILE '⟨my-sso-profile⟩' ); The token expires after the SSO session's configured lifetime. When it does, run aws sso login again. You do not need to recreate the secret. HTTP Proxy When cred... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
DuckDB 2.0 Documentation / man.mtool.work