Results of 1 - 10 of about 20 for headers (0.002 sec.)
- Troubleshoot 13934
- 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
...ct 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 headers, the query fa...xample, when querying files from Amazon S3, configure the bucket's CORS policy to allow GET and HEAD requests: [ { "AllowedHeaders": ["*"], "AllowedMethods": ["GET", "HEAD"], "AllowedOrigins": ["*"], "ExposeHeaders": [], "MaxAgeSeconds": 3000 } ] This a...d fail. Cached reads of files in DuckDB's native format over HTTP can be corrupted (see issue #1957 ). HTTP authentication headers are not supported, so endpoints that require them cannot be read directly (see issue #1967 ). Extension Fails to Load from... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Deploy 11215
- Overview Deploying DuckDB-Wasm means serving its components so that the browser can fetch and instantiate them. This page describes each component a deployment needs to serve, how the worker and WebAssembly variants relate, how extensions a
...are cross-origin isolated . To serve the threaded bundle, the top-level document must be delivered with the following HTTP headers: Cross-Origin-Embedder-Policy: require-corp Cross-Origin-Opener-Policy: same-origin These headers isolate the document fro...d require any cross-origin resource it embeds to explicitly opt in. Because many third-party endpoints do not yet send the headers needed to be embedded under these policies, most deployments run on non-isolated pages, where DuckDB-Wasm falls back to th...e single-threaded mvp or eh bundle. For more background on why these headers are required and how they unlock SharedArrayBuffer , see the following resources: WebAssembly threads on web.dev Enabling... - https://man.mtool.work/duckdb/2.0/clients/wasm/deploying_duckdb_wasm.html
- Catalogs 9873
- The iceberg extension supports attaching Iceberg REST Catalogs. Attaching a catalog is required for writing to Iceberg . Before attaching an Iceberg REST Catalog, you must install the iceberg extension by following the instructions located
...E seaweedfs_catalog.sales.orders; Google Cloud BigLake To attach to a Google Cloud BigLake catalog, you can use extra HTTP headers to specify the GCP project for billing purposes. First, get your Google Cloud access token: gcloud auth application-defaul...t print-access-token Then create a secret with the token and extra headers: CREATE SECRET biglake_secret ( TYPE iceberg, TOKEN '⟨your_access_token⟩', EXTRA_HTTP_HEADERS MAP { 'x-goog-user-project':...g the BigLake public dataset : CREATE SECRET biglake_public_secret ( TYPE iceberg, TOKEN '⟨your_access_token⟩', EXTRA_HTTP_HEADERS MAP { 'x-goog-user-project': '⟨your_gcp_project_id⟩' } ); ATTACH 'gs://biglake-public-nyc-taxi-iceberg' AS biglake_public... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/catalogs.html
- Install Script 9669
- You can install the DuckDB CLI client using an install script. Linux and macOS To use the DuckDB install script on Linux and macOS, run: curl https://install.duckdb.org | bash Click to see the output of the install script. % Total % Receive
...N=1.2.2 bash Installing the C/C++ Libraries Starting with DuckDB 2.0, the install script can also install the DuckDB C/C++ headers and libraries using the DUCKDB_INSTALL variable. It takes a comma-separated list of components: cli (default), static and...ll the static library and the CLI, run: curl https://install.duckdb.org | DUCKDB_INSTALL=static,cli bash The libraries and headers are installed to ~/.duckdb/lib/⟨version⟩/release_⟨platform⟩ , e.g., ~/.duckdb/lib/2.0.0/release_osx_arm64 . For more detai... - https://man.mtool.work/duckdb/2.0/operations_manual/installing_duckdb/install_sc...
- Logging 9278
- DuckDB implements a logging mechanism that provides users with detailed information about events such as query execution, performance metrics and system events. Warning Logs may contain sensitive information, including secrets and credentia
...ge schema. To make DuckDB automatically parse the message, use the duckdb_logs_parsed() macro. For example: SELECT request.headers FROM duckdb_logs_parsed('HTTP'); To view the schema of each structure log type simply run: DESCRIBE FROM duckdb_logs_parse...fs VARCHAR , path VARCHAR , op VARCHAR , bytes BIGINT , pos BIGINT HTTP request STRUCT(type, url, start_time, duration_ms, headers MAP) , response STRUCT(status, reason, headers MAP) PhysicalOperator operator_type VARCHAR , parameters MAP(VARCHAR, VARCH... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- Tuning Workloads 9091
- DuckDB aims to perform well out of the box, so most workloads do not require any tuning. When tuning is worthwhile, there is no single configuration or magic number that is optimal for every workload: the right settings depend on what you a
...tent of the external file cache, run: FROM duckdb_external_file_cache(); The external file cache follows the Cache-Control headers of HTTP responses: data from a response marked no-store , no-cache or private , or from a response that is already stale (...e.g., max-age=0 ), is not reused. Object stores often send such headers on authenticated reads. For example, Google Cloud Storage returns Cache-Control: private, max-age=0 for every read of a no..., so by default, these files are read from the object store again on every query. To reuse cached data regardless of these headers, set enable_external_file_cache explicitly, even though it is enabled by default: SET enable_external_file_cache = true; C... - https://man.mtool.work/duckdb/2.0/guides/performance/how_to_tune_workloads.html
- Command Line Arguments 8887
- 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
...writing the result to stdout -init FILENAME Run the script in FILENAME upon startup (instead of ~/.duckdbrc ) -header Turn headers on -h Show the help message -help Show the help message -html Set output mode to HTML -interactive Force interactive I/O -...See the Agent Mode page -no-init Skip processing the init file ( ~/.duckdbrc or the file passed to -init ) -noheader Turn headers off -no-stdin Exit after processing options instead of reading stdin -nullvalue TEXT Set text string for NULL values. Defa... - https://man.mtool.work/duckdb/2.0/clients/cli/arguments.html
- Calculating a Database Checksum 8513
- To calculate a database checksum, use a commutative operation such as bit_xor on all columns, all rows, and all tables. First, create a table macro that performs this for each table: CREATE OR REPLACE MACRO table_checksum(table_name) AS TAB
...); You need to call this macro for all tables. In the CLI, you can do so by dynamically generating a SQL file: .mode list .headers off .once checksum_all_tables.sql SELECT printf('CREATE OR REPLACE TABLE table_checksums (checksum UHUGEINT);') UNION ALL... - https://man.mtool.work/duckdb/2.0/guides/snippets/database_checksum.html
- Dot Commands 8309
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...output of the next command in a spreadsheet. Equivalent to .once -x .exit ⟨CODE⟩ Exit this program with return-code CODE .headers ⟨on/off⟩ Turn display of headers on or off . Does not apply to duckbox mode .help ⟨-all⟩ ⟨PATTERN⟩ Show help text for PATT...lts to their clipboards using pbcopy by using .once to output to pbcopy via a pipe: .once |pbcopy Combining this with the .headers off and .mode lines options can be particularly effective. Querying the Database Schema All DuckDB clients support queryin... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- Azure Extension 8309
- 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
...RL query parameter names (case-sensitive) whose values are redacted in the HTTP log. VARCHAR sig azure_http_logging_redact_headers Semicolon-separated list of header names (case-insensitive) whose values are redacted in the HTTP log, for both requests a...eplaced by REDACTED . To change what is redacted, set azure_http_logging_redact_query_params and azure_http_logging_redact_headers . A new value replaces the default list, so include sig or Authorization if you still want them redacted: SET azure_http_l...ogging_redact_headers = 'Authorization;x-ms-date'; Warning The Azure extension applies only these settings, not DuckDB's redact_http_logs settin... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
DuckDB 2.0 Documentation / man.mtool.work