Results of 1 - 10 of about 30 for Request (0.002 sec.)
- Reference 13565
- 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
...erver (minimum 4 characters). HEARTBEAT_TIMEOUT UBIGINT quack_default_heartbeat_timeout Heartbeat lease timeout in seconds requested from the server. Settings All settings are regular DuckDB session / global options. Set with SET ⟨name⟩ = ⟨value⟩ or SET...to FETCH . Drains whole batches, so it may overshoot to a batch boundary. quack_fetch_read_ahead UBIGINT 0 Number of FETCH requests the client keeps in flight ahead of the scan. 0 uses the number of async threads. quack_rebalance_buffer_bytes UBIGINT 0...e variable is not set. Set to '' to opt out. quack_default_heartbeat_timeout UBIGINT 60 Heartbeat lease timeout in seconds requested by clients when ATTACH / quack_query omit heartbeat_timeout . quack_enable_reconnects BOOLEAN false Enable reconnect sup... - https://man.mtool.work/duckdb/2.0/quack/reference.html
- Troubleshooting 11339
- Curl Request Fails Problem When trying to attach to an Iceberg REST Catalog endpoint, DuckDB returns the following error: IO Error: Curl Request to '/v1/oauth/tokens' failed with error: 'URL using bad/illegal format or missing URL' Solution
...azonaws.com/iceberg/v1/arn:aws:s3tables:... http error 403 thrown. Message: {"message":"The security token included in the request is invalid."} Solution Use the duckdb_secrets() function to check whether DuckDB loaded the required credentials: .mode li... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/troubleshooting.html
- Security 10949
- 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
...horization: Setting Default Called when quack_authentication_function quack_check_token A new client connects ( CONNECTION_REQUEST ). quack_authorization_function quack_nop_authorization A client issues a query ( PREPARE_REQUEST ). A request is rejected.../ Authorization failed if the callback returns false or NULL , or if the callback query fails. Any other result admits the request, so we recommend returning a BOOLEAN . The authorization callback may also return a VARCHAR : the returned string is then...hentication 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 f... - https://man.mtool.work/duckdb/2.0/quack/security.html
- Iceberg Options 9893
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...les (data and metadata) created during the transaction will not be cleaned up on ROLLBACK or retries of the COMMIT . PURGE_REQUESTED BOOLEAN false Sends the PurgeRequested parameter when dropping a table. ENCODE_ENTIRE_PREFIX BOOLEAN false URL-encode th...e entire path prefix when communicating with the catalog. MAX_TABLE_STALENESS INTERVAL NULL Prevents unnecessary requests to the Iceberg REST Catalog. Accepts human-readable interval strings such as 10 minutes , 30 seconds , or 1 year . EXTRA_...HTTP_HEADERS MAP(VARCHAR, VARCHAR) NULL Extra headers (key-value) sent along with the requests to the REST Catalog. DEFAULT_TABLE_LOCATION_FROM_NAMESPACE BOOLEAN false If enabled, a CREATE TABLE without an explicit W... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Legacy Authentication Scheme for S3 API 9373
- 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
...nal session token: SET s3_session_token = '⟨aws_session_token⟩'; The aws extension allows for loading AWS credentials. Per-Request Configuration Deprecated Per-request configuration through S3 URL query parameters is deprecated and disabled by default i...ifferent paths. Aside from the global S3 configuration described above, specific configuration values can be used on a per-request basis. This allows for use of multiple sets of credentials, regions, etc. These are used by including them on the S3 URI a...ey 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_PAYS... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Troubleshoot 9244
- 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
...n DuckDB-Wasm reads a remote file — through the Wasm-flavored httpfs extension or registerFileURL — the browser issues the request, so it is subject to the browser's CORS policy and every request is upgraded to HTTPS. The server hosting the data must al...rver does not send the required headers, the query fails with a network error such as: Failed to execute 'send' on 'XMLHttpRequest' For example, when querying files from Amazon S3, configure the bucket's CORS policy to allow GET and HEAD requests: [ { "...hosted, then read the file as usual. Beyond CORS, reading remote files has several other known limitations: Because every request is upgraded to HTTPS, an http:// URL can be rewritten incorrectly (for example to https://http//… ), which breaks reads ag... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Configuration 8984
- 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
...u mean..." error message. UBIGINT 100 checkpoint_on_detach Override checkpoint behavior when detaching a database. ENABLED requests a checkpoint, but the checkpoint does not occur if another connection still references the database. DISABLED never check...OLICY custom_extension_repository Overrides the custom endpoint for extension installation. VARCHAR custom_user_agent HTTP request metadata that can be set by callers/wrappers to tag their own traffic when DuckDB makes a request. VARCHAR default_block_s...database connection, e.g., cpp, capi, cli. The value gets folded into the HTTP User-Agent string DuckDB sends on any HTTP request. VARCHAR cli dynamic_or_filter_threshold The maximum amount of OR filters that are generated dynamically from a hash join.... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Quack Remote Protocol 8984
- 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
...Quack traffic the same way they handle any other HTTP service. There is no custom wire transport to operate. Client-driven request and response. Every interaction is initiated by the client. The server does not initiate interactions via pushing. applica...tion/duckdb serialization. Requests and responses are encoded with DuckDB's internal serialization primitives (the same code path used by the Write-Ahead Log......) lossless across the wire. Single round-trip per query. After the initial connection handshake, a query needs only one request–response pair. Large results stream back in chunks via follow-up FETCH requests, optionally parallelized on multiple threa... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Securing Quack with a Reverse Proxy 8984
- By default, the Quack server binds to localhost and speaks plain HTTP. See Security for the rationale behind these configurations. For any deployment beyond local-only, the recommended pattern is the same as for any other HTTP-based databas
...t any extra config. 1. Run Caddy Save this Caddyfile : localhost:8443 { reverse_proxy 127.0.0.1:9494 { flush_interval -1 } request_body { max_size 256MB } } Then start Caddy: brew install caddy # macOS, for other platforms see https://caddyserver.com/do..._interval -1 } # Equivalent of nginx `client_max_body_size`. PREPARE / APPEND bodies # can be much larger than the default request body cap. request_body { max_size 256MB } } Caddy handles certificate issuance and renewal automatically. No certbot step... - https://man.mtool.work/duckdb/2.0/quack/setup/reverse_proxy.html
- S3 API Support 8854
- 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)
...ch parts of the S3 API are required for each httpfs feature. Feature Required S3 API features Public file reads HTTP Range requests Private file reads Secret key or session token authentication File glob ListObjectsV2 File writes Multipart upload Config...ing the endpoint URL R2 STRING - KMS_KEY_ID AWS KMS (Key Management Service) key for Server Side Encryption S3 S3 STRING - REQUESTER_PAYS Allows use of "requester pays" S3 buckets S3 BOOLEAN false REFRESH Set to auto to periodically refresh credentials...tic Credential Refresh Independently of the REFRESH secret parameter, DuckDB automatically refreshes S3 credentials when a request fails with an HTTP 401 or 403 status (for example, when temporary credentials have expired), then retries the request. Thi... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api.html
DuckDB 2.0 Documentation / man.mtool.work