Results of 1 - 10 of about 76 for above (0.001 sec.)
- HTTP User-Agent 12440
- HTTP User-Agent Core DuckDB sets the default user-agent as follows: duckdb/v2.0.0(osx_arm64) cli which indicates the DuckDB version, the platform and the client API (the value of the duckdb_api setting, e.g., cli , capi or cpp ). If the cus
...020 Cpp/201402) Delta (and Unity Catalog) The Delta extension employs calls from DuckDB core, tagged as the DuckDB default above, and also has calls originating from the Delta Kernel, which may look like: object_store/0.12.5 Unity Catalog calls also u...se a mix of DuckDB default user-agents, and the Delta style agent above. HTTPFS - HTTPS/S3 Calls via HTTPFS the extension use the DuckDB default strings noted above.... - https://man.mtool.work/duckdb/2.0/operations_manual/user_agents.html
- UNPIVOT Statement 11498
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...cases, the number of columns to unpivot is not easy to predetermine ahead of time. In the case of this dataset, the query above would have to change each time a new month is added. The COLUMNS expression can be used to select all columns that are not...ic unpivoting that will work regardless of how many months are added. The query below returns identical results to the one above. UNPIVOT monthly_sales ON COLUMNS(* EXCLUDE (empid, dept)) INTO NAME month VALUE sales; empid dept month sales 1 electroni...ow for each quarter. Since there are fewer quarters than months, this does make the dataset longer, but not as long as the above. To accomplish this, multiple sets of columns are included in the ON clause. The q1 and q2 aliases are optional. The numbe... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Client Overview 10320
- DuckDB is primarily an in-process database system, and as such, it offers client APIs (“drivers”) for several languages. Client API Maintainer Support tier Latest version C Core team 2.0.0 CLI (command line interface) Core team 2.0.0 Java (
...2.0.0 WebAssembly (Wasm) Core team 2.0.0 ADBC (Arrow) Core team 2.0.0 C# (.NET) Giorgi 2.0.0 C++ Core team 2.0.0 The table above lists the DuckDB clients with the primary and secondary support tiers . For a list of tertiary clients, see the “Tertiary...by community support. Finally, there are no feature or support guarantees for tertiary clients. The DuckDB clients listed above are open-source and we welcome community contributions to these libraries. All primary and secondary clients are available... - https://man.mtool.work/duckdb/2.0/clients/overview.html
- Troubleshoot 10320
- 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
...sts for the extension files must be CORS enabled for the browser to allow the connection, exactly as for remote data files above. Extensions remain signed regardless of where they are served, so copying an extension to a different location keeps its s...the coi bundle. Further Reading DuckDB Wasm Client — installation, basic usage, and the limitations behind several issues above. Import Data — registering and reading remote files that are subject to the CORS rules above. Load Extensions — how extens... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- PostgreSQL Extension and the Secret Manager 8907
- User credentials and other PostgreSQL database connection details can be stored using the DuckDB Secrets Manager . The following syntax can be used to create a secret: CREATE SECRET ( TYPE postgres, HOST '127.0.0.1', PORT 5432, DATABASE pos
...hentication token, it takes the same configuration parameters as the aws rds generate-db-auth-token command in the example above: sql CREATE SECRET aws_rds_secret1 ( TYPE rds, PROVIDER credential_chain, CHAIN 'env;sso;', REGION 'eu-west-1', RDS_USER '...is used to create the remaining of the connection string. It takes the same parameters as the psql utility in the example above (and additionally any relevant additional libpq configuration options) and requires to specify the name of the rds secret,...y format. It is advised to use this provider for secrets that do not include confidential credentials (like the s3 example above). For multi-tenant scenarios it is expected that Postgres Row-Level Security policies can be used to prevent users to see... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/secrets.html
- SQLite Extension 8907
- The SQLite extension allows DuckDB to directly read and write data from a SQLite database file. The data can be queried directly from the underlying SQLite tables. Data can be loaded from SQLite tables into DuckDB tables, or vice versa. Ins
...anslated into DATE . If the declared type contains the string TIME , then it is translated into TIMESTAMP . If none of the above apply, then it is translated into VARCHAR . As DuckDB enforces the corresponding columns to contain only correctly typed v...t load the string “hello” into a column of type BIGINT . As such, an error is thrown when reading from the “numbers” table above: Mismatch Type Error: Invalid type in column "i": column was declared as integer, found "hello" of type "text" instead. Th..._varchar option: SET GLOBAL sqlite_all_varchar = true; When set, this option overrides the type conversion rules described above, and instead always converts the SQLite columns into a VARCHAR column. Note that this setting must be set before sqlite_at... - https://man.mtool.work/duckdb/2.0/core_extensions/sqlite.html
- DBeaver SQL IDE 8907
- DBeaver is a powerful and popular desktop SQL editor and integrated development environment (IDE). It has both an open source and enterprise version. DBeaver is useful for visually inspecting the available tables in DuckDB and for quickly b
...driver from Maven. Once download is complete, click “OK”, then return to the main DBeaver window and continue with step 7 above. Note: If you are in a corporate environment or behind a firewall, before clicking download, click the “Download Configura...firm that org.duckdb.DuckDBDriver is detected, then click “OK”. Return to the main DBeaver window and continue with step 7 above.... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- Legacy Authentication Scheme for S3 API 8672
- 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
...ers, use scoped secrets to use different credentials for different 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, re...s, etc. These are used by including them on the S3 URI as query parameters. All the individual configuration values listed above can be set as query parameters. For instance: SELECT * FROM 's3://bucket/file.parquet?s3_access_key_id=accessKey&s3_secret... - https://man.mtool.work/duckdb/2.0/core_extensions/httpfs/s3api_legacy_authentica...
- Logging 8672
- 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
...rage is shell_log_storage , which prints log messages to the console but does not support querying. Therefore, the example above passes storage = 'memory' . In other clients, the default log storage is memory , so CALL enable_logging(); suffices. See...rt for structured logging Logging-Specific Types To log only messages of a specific type: CALL enable_logging('HTTP'); The above function will automatically set the correct log level and will add the HTTP type to the enabled_log_types settings. This e...ogs function, which automatically joins normalized tables into a single unified result. To illustrate, both configurations above will be queryable using FROM duckdb_logs; and will produce identical results. Buffer Size The log storage in DuckDB implem... - https://man.mtool.work/duckdb/2.0/operations_manual/logging/overview.html
- SQL Introduction 8672
- This page provides an overview of how to perform simple operations in SQL. This tutorial is only intended to give you an introduction and is in no way a complete tutorial on SQL. This tutorial is adapted from the PostgreSQL tutorial . DuckD
...paces, tabs and newlines) can be used freely in SQL commands. That means you can type the command aligned differently than above, or even all on one line. Two dash characters ( -- ) introduce comments. Whatever follows them is ignored up to the end of...ider explicitly listing the columns better style than relying on the order implicitly. Please enter all the commands shown above so you have some data to work with in the following sections. Alternatively, you can use the COPY statement . This is fast...isn't fully specified, and so you might get the San Francisco rows in either order. But you'd always get the results shown above if you do: SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of... - https://man.mtool.work/duckdb/2.0/sql/introduction.html
DuckDB 2.0 Documentation / man.mtool.work