Results of 1 - 10 of about 16 for configured (0.003 sec.)
- Syntax Highlighting – DuckDB 13065
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...g syntax highlighting. There are several components of a query that are highlighted in different colors. The colors can be configured using dot commands . Syntax highlighting can also be disabled entirely using the .highlight off command. Below is a list o...f components that can be configured. Type Command Default color Keywords .keyword green Constants ad literals .constant yellow Comments .comment brightblack E...rrors .error red Continuation .cont brightblack Continuation (Selected) .cont_sel green The components can be configured using either a supported color name (e.g., .keyword red ), or by directly providing a terminal code to use for rendering (... - https://man.mtool.work/duckdb/1.3/clients/cli/syntax_highlighting.html
- Timestamp Types – DuckDB 13065
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ne aware and WITH TIME ZONE is that timestamp arithmetic, binning , and string formatting for this type are performed in a configured time zone , which defaults to the system time zone and is just UTC+00:00 in the examples above. The corresponding TIMESTAM...en strings without UTC offsets or time zone names are converted to a WITH TIME ZONE type, the string is interpreted in the configured time zone. Conversely, when strings with UTC offsets are passed to a WITHOUT TIME ZONE type, the local time in the configu...TIME ZONE and WITHOUT TIME ZONE types are converted to each other via explicit or implicit casts, the translation uses the configured time zone. To use an alternative time zone, the timezone function provided by the ICU extension may be used: SELECT timezo... - https://man.mtool.work/duckdb/1.3/sql/data_types/timestamp.html
- UI Extension – DuckDB 9270
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...you have to opt-in explicitly and sign into MotherDuck. Configuration Local Port The local port of the HTTP server can be configured with a SQL command like: SET ui_local_port = 4213 ; The environment variable ui_local_port can also be used. The default p...ey can be kept up-to-date. The default URL for the remote server is https://ui.duckdb.org . An alternate remote URL can be configured with a SQL command like: SET ui_remote_url = 'https://ui.duckdb.org' ; The environment variable ui_remote_port can also be... - https://man.mtool.work/duckdb/1.3/core_extensions/ui.html
- S3 API Support – DuckDB 8785
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...profile. See the “Loading a Secret Based on a Profile” section . config Provider The default provider, config (i.e., user-configured), allows access to the S3 bucket by manually providing a key. For example: CREATE OR REPLACE SECRET secret ( TYPE s3 , PRO...tion for managing HMAC keys . Note that the above secret will automatically have the correct Google Cloud Storage endpoint configured. Also note that GCS Secrets can also use both the CONFIG and credential_chain providers. However, since DuckDB uses an AWS... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api.html
- Pragmas – DuckDB 8317
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...queries: PRAGMA disable_progress_bar ; Or: PRAGMA disable_print_progress_bar ; EXPLAIN Output The output of EXPLAIN can be configured to show only the physical plan. The default configuration of EXPLAIN : SET explain_output = 'physical_only' ; To only show...ofiling can be specified as query_tree , json , query_tree_optimizer , or no_output . Each format prints its output to the configured output, except no_output . The default format is query_tree . It prints the physical query plan and the metrics of each op... - https://man.mtool.work/duckdb/1.3/configuration/pragmas.html
- jemalloc Extension – DuckDB 8317
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...s On Windows, this extension is not available. Configuration Environment Variables The jemalloc allocator in DuckDB can be configured via the MALLOC_CONF environment variable . Background Threads By default, jemalloc's background threads are disabled. To e... - https://man.mtool.work/duckdb/1.3/core_extensions/jemalloc.html
- S3 Iceberg Import – DuckDB 8317
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ER credential_chain ); Loading Iceberg Tables from S3 After the extensions are set up and the S3 credentials are correctly configured, Iceberg table can be read from S3 using the following command: SELECT * FROM iceberg_scan ( 's3:// bucket / iceberg_table... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_iceberg_import...
- Legacy Authentication Scheme for S3 API – DuckDB 8075
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...to read or write from S3, the correct region should be set: SET s3_region = 'us-east-1' ; Optionally, the endpoint can be configured in case a non-AWS object storage server is used: SET s3_endpoint = ' domain . tld : port ' ; If the endpoint is not SSL-en... - https://man.mtool.work/duckdb/1.3/core_extensions/httpfs/s3api_legacy_authentica...
- S3 Parquet Export – DuckDB 8075
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...SECRET ( TYPE s3 , PROVIDER credential_chain ); After the httpfs extension is set up and the S3 credentials are correctly configured, Parquet files can be written to S3 using the following command: COPY table_name TO 's3:// s3-bucket / filename .parquet'... - https://man.mtool.work/duckdb/1.3/guides/network_cloud_storage/s3_export.html
- AWS Extension – DuckDB 7832
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...onfigure and authenticate to AWS S3 endpoints is to use secrets . config Provider The default provider, config (i.e., user-configured), allows access to the S3 bucket by manually providing a key. For example: CREATE OR REPLACE SECRET secret ( TYPE s3 , PRO... - https://man.mtool.work/duckdb/1.3/core_extensions/aws.html
DuckDB 1.3 Documentation / man.mtool.work