Results of 1 - 10 of about 53 for Provide (0.001 sec.)
- CSV Import Tips 14660
- Below is a collection of tips to help when attempting to import complex CSV files. In the examples, we use the flights.csv file. Override the Header Flag if the Header Is Not Correctly Detected If a file contains only string columns the hea
...der auto-detection might fail. Provide the header option to override this behavior. SELECT * FROM read_csv('flights.csv', header = true); Provide Names if the Fi...le Does Not Contain a Header If the file does not contain a header, names will be auto-generated by default. You can provide your own names with the names option. SELECT * FROM read_csv('flights.csv', names = ['DateOfFlight', 'CarrierName']); Over... - https://man.mtool.work/duckdb/2.0/data/csv/tips.html
- Securing DuckDB 11371
- DuckDB is a powerful analytical database engine. It can read and write files, access the network, load extensions, and use system resources. Like any powerful tool, these capabilities require appropriate configuration when working with sens
...to prevent data exfiltration Implement strict query timeouts at the application level The settings described on this page provide defense-in-depth and can limit certain capabilities, but they are not a substitute for proper sandboxing. Also keep in min...ueries containing arbitrary SQL. Treat these with the same caution as SQL. Recommendations: Validate and sanitize all user-provided inputs before passing them to DuckDB APIs. Apply the same sandboxing principles as for untrusted SQL when accepting input...ease report it confidentially via GitHub . Settings to Limit DuckDB's Capabilities The settings documented in this section provide additional hardening for DuckDB deployments. However, they should not be relied upon as comprehensive security mechanisms... - https://man.mtool.work/duckdb/2.0/operations_manual/securing_duckdb/overview.htm...
- Building DuckDB from Source 9883
- When Should You Build DuckDB? DuckDB binaries are available for stable and preview builds on the installation page . In most cases, it's recommended to use these binaries. When you are running on an experimental platform (e.g., Raspberry Pi
...usl libc , e.g., Alpine Linux linux_arm64_android Android AArch64 (ARM64) wasm_eh WebAssembly Exception Handling Below, we provide detailed build instructions for some platforms: Android Raspberry Pi Platforms with Best Effort Support Platform name Desc...MD64) for RTools DuckDB can also be built for end-of-life platforms such as macOS 11 and CentOS 7/8 using the instructions provided for macOS and Linux. Troubleshooting Guides We provide troubleshooting guides for building DuckDB: Generic issues Python... - https://man.mtool.work/duckdb/2.0/dev/building/overview.html
- HAVING Clause 9585
- The HAVING clause can be used after the GROUP BY clause to provide filter criteria after the grouping has been completed. In terms of syntax the HAVING clause is identical to the WHERE clause, but while the WHERE clause occurs before the gr
... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/having.html
- Result Verification 9287
- The standard way of verifying results of queries is using the query statement, followed by the letter I times the number of columns that are expected in the result. After the query, four dashes ( ---- ) are expected followed by the result v
...he test passes if the error message contains the text under statement error – the entire error message does not need to be provided. It is recommended that you only use a subset of the error message, so that the test does not break unnecessarily if the...rom files using the <FILE> command. The expected result is read from the given file. As convention the file path should be provided as relative to the root of the GitHub repository. query I PRAGMA tpch(1) ---- <FILE>:extension/tpch/dbgen/answers/sf1/q01...her feature that can be used for result verification are query labels . These can be used to verify that different queries provide the same result. This is useful for comparing queries that are logically equivalent, but formulated differently. Query lab... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/result_verification.html
- S3 Parquet Export 8677
- To write a Parquet file to S3, the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL command: LOAD htt
...to use a named profile, SSO, or an assumed role — see the aws extension . The default looks like: CREATE SECRET ( TYPE s3, PROVIDER credential_chain ); After the httpfs extension is set up and the S3 credentials are correctly configured, Parquet files c...et'; Similarly, Google Cloud Storage (GCS) is supported through the Interoperability API. You need to create HMAC keys and provide the credentials as follows: CREATE SECRET ( TYPE gcs, KEY_ID '⟨AKIAIOSFODNN7EXAMPLE⟩', SECRET '⟨wJalrXUtnFEMI/K7MDENG/bPxR... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/s3_export.html
- Blob Type 8677
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...as parsed as the VARCHAR string 'xCAFE' . Blobs are typically used to store non-textual objects that the database does not provide explicit support for, such as images. While blobs can hold objects up to 4 GB in size, typically it is not recommended to... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Friendly CLI 8379
- Along with our Friendly SQL , we provide friendly CLI features. Dark/Light Mode The CLI automatically detects whether the terminal is using a dark or light background and adjusts syntax highlighting colors accordingly. The mode can also be
... - https://man.mtool.work/duckdb/2.0/clients/cli/friendly_cli.html
- Transaction Management 8379
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...es it made so far. Statements DuckDB provides the following statements for transaction management. Starting a Transaction To start a transaction, run: BEGIN TRANSACTIO... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- GDAL Integration 8082
- The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the documentation for the st_read table function for how to make use of this in practice. In o
...ts own copy of the GDAL library. This also means that spatial's version of GDAL may not be the latest version available or provide support for all of the file formats that a system-wide GDAL installation otherwise would. Refer to the section on the st_d... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
DuckDB 2.0 Documentation / man.mtool.work