Results of 1 - 10 of about 47 for Configure (0.001 sec.)
- AWS Extension 11932
- The aws extension adds functionality, e.g., authentication, on top of the httpfs extension's S3 capabilities , using the AWS SDK. Installing and Loading The aws extension will be transparently autoloaded on first use from the official exten
...ew of the available methods and guidance on which one to use, see the S3 and AWS Authentication page. The preferred way to configure and authenticate to AWS S3 endpoints is to use secrets . There are two S3 secret providers: The config provider, where you...elf: it reads the short-lived token that the AWS CLI caches after you sign in. The setup therefore has three steps. First, configure an SSO-enabled profile in ~/.aws/config , either by running aws configure sso or by adding an sso_session and sso_account_...( TYPE s3, PROVIDER credential_chain, CHAIN 'sso', PROFILE '⟨my-sso-profile⟩' ); The token expires after the SSO session's configured lifetime. When it does, run aws sso login again. You do not need to recreate the secret. HTTP Proxy When credentials must... - https://man.mtool.work/duckdb/2.0/core_extensions/aws.html
- PostgreSQL Extension Connection Pool 11689
- PostgreSQL server spawns a backend process for every incoming client connection. This model leads to the two following points with the postgres extension that can cause performance problems: opening a new connection is relatively expensive
...maximum number of allowed connection in the connection pool (no more than 32 by default). Even when the connection pool is configured to allow opening additional connections when all connection slots are taken ( force acquire mode), the addtional parallel...proceeds with the worker threads that were able to acquire a connection from the pool. See the description of the postgres_configure_pool function for details. Connection Proxies Connection pool can be the most effective when DuckDB connects directly to a...may be better to set the idle timeout to a lower value (using pg_pool_idle_timeout_millis configuration option or postgres_configure_pool function) or to disable the pooling completely (by setting pg_pool_max_connections = 0 ). Reaper Thread The postgres... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/connection_pool.html
- PostgreSQL Extension Functions 11689
- postgres_clear_cache postgres_configure_pool postgres_execute postgres_hstore_get postgres_hstore_to_json postgres_query read_postgres_binary postgres_clear_cache postgres_clear_cache() -> TABLE Clears cached schema entries (like table name
...result is always returned with zero rows, so the flag value is not available. Example CALL postgres_clear_cache() postgres_configure_pool FROM postgres_configure_pool([⟨optional named parameters⟩]) -> TABLE When a PostgreSQL database is attached, a connec...guration options and the collected runtime statistics of all connections pools (for all attached databases): FROM postgres_configure_pool() Change one or more configuration option for the connection pool of the specified attached database: FROM postgres_c... - https://man.mtool.work/duckdb/2.0/core_extensions/postgres/functions.html
- ODBC API on Linux 9774
- Driver Manager A driver manager is required to manage communication between applications and the ODBC driver. We tested and support unixODBC that is a complete ODBC driver manager for Linux. Users can install it from the command line: On De
...mands to handle the ODBC setup and test like odbcinst and isql . Run the following commands with either option -u or -s to configure DuckDB ODBC. The -u option based on the user home directory to setup the ODBC init files. batch ./unixodbc_setup.sh -u The...le: ./unixodbc_setup.sh -u -db ~/database_path -D ~/driver_path/libduckdb_odbc.so Level: -s: System-level, using 'sudo' to configure DuckDB ODBC at the system-level, changing the files: /etc/odbc[inst].ini -u: User-level, configuring the DuckDB ODBC at th... - https://man.mtool.work/duckdb/2.0/clients/odbc/linux.html
- DBeaver SQL IDE 9530
- 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
...are in a corporate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. You should now see a database connection to your DuckDB database in the left hand “Database Navigator...are in a corporate environment or behind a firewall, before clicking download, click the “Download Configuration” link to configure your proxy settings. Manual Driver Installation If DBeaver cannot download the driver itself, for example when it runs wit... - https://man.mtool.work/duckdb/2.0/guides/sql_editors/dbeaver.html
- ODBC API on Windows 9287
- Setup Using the DuckDB ODBC API on Windows requires the following steps: Microsoft Windows requires an ODBC Driver Manager to manage communication between applications and the ODBC drivers. The Driver Manager on Windows is provided in a DLL
...performs the configuration of the DuckDB ODBC Driver on Windows. It depends on the Odbccp32.dll that provides functions to configure the ODBC registry entries. Inside the permanent directory (e.g., duckdb_odbc ), double-click on the odbc_install.exe . Win...you to set the DSN and the database file path associated with that DSN. More Detailed Windows Setup There are two ways to configure the ODBC driver, either by altering the registry keys as detailed below, or by connecting with SQLDriverConnect . A combin... - https://man.mtool.work/duckdb/2.0/clients/odbc/windows.html
- UI Extension 9287
- The ui extension adds a user interface for your local DuckDB instance. Usage To start the UI from the command line: duckdb -ui To start the UI from SQL: CALL start_ui(); Running either of these will open the UI in your default browser. The
...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_url can also be...used. This setting is available mainly for testing purposes. Be sure you trust any URL you configure, as the application can access the data you load into DuckDB. Because of this risk, the setting is only respected if allow... - https://man.mtool.work/duckdb/2.0/core_extensions/ui.html
- Overview 9287
- We designed DuckDB to be easy to deploy and operate. We believe that most users do not need to consult the pages of the operations manual. However, there are certain setups – e.g., when DuckDB is running in mission-critical infrastructure –
...where we would like to offer advice on how to configure DuckDB. The operations manual contains advice for these cases and also offers convenient configuration snippets such as Gi... - https://man.mtool.work/duckdb/2.0/operations_manual/overview.html
- Troubleshoot 9059
- 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
...ith 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: [ { "AllowedHeaders": ["*"], "AllowedMethods": ["GET", "HEAD"], "...single-threaded mvp or eh bundle. See Cross-Origin Isolation for the required headers, and Threading for how to select and configure the coi bundle. Further Reading DuckDB Wasm Client — installation, basic usage, and the limitations behind several issues... - https://man.mtool.work/duckdb/2.0/clients/wasm/troubleshoot.html
- Lance Extension 8816
- The lance extension adds support for reading and writing Lance tables. Lance is a modern lakehouse format optimized for ML/AI workloads, with native cloud storage support. Installing and Loading You can install the lance extension from Duck
...e⟩' LIMIT 10; S3: SELECT * FROM 's3://⟨bucket/path/to/out.lance⟩' LIMIT 10; To access object store URIs (e.g., s3://... ), configure a TYPE lance secret using the Secrets Manager : CREATE SECRET ( TYPE lance, PROVIDER credential_chain, SCOPE 's3://bucket/...NO DATA ) TO 'path/to/empty.lance' ( FORMAT lance, MODE 'overwrite', WRITE_EMPTY_FILE true ); To write to s3://... paths, configure a TYPE lance secret for that scope using the Secrets Manager : CREATE SECRET ( TYPE lance, PROVIDER credential_chain, SCOP... - https://man.mtool.work/duckdb/2.0/core_extensions/lance.html
DuckDB 2.0 Documentation / man.mtool.work