DuckDB is a high-performance analytical database system. It is available as a standalone CLI application and has clients for Python, R, Java, Wasm, etc., with deep integrations with packages such as pandas and dplyr.
For more information on using DuckDB, refer to the DuckDB documentation.
This check monitors DuckDB through the Datadog Agent.
DuckDB has two configurable options for concurrency:
- One process can both read and write to the database.
- Multiple processes can read from the database, but no processes can write (access_mode = 'READ_ONLY').
read_only mode to get metrics, with a default frequency of 60 seconds (min_collection_interval).
You can increase this value to reduce concurrency issues.
Follow the instructions below to install and configure this check for an Agent running on a host. For containerized environments, see the Autodiscovery Integration Templates for guidance on applying these instructions.
The DuckDB check is included in the Datadog Agent package. No additional installation is needed on your server.
The duckdb client library is required. To install it, ensure you have a working compiler and run:
sudo -Hu dd-agent /opt/datadog-agent/embedded/bin/pip install duckdb==1.1.1
"C:\Program Files\Datadog\Datadog Agent\embedded3\python.exe" -m pip install duckdb==1.1.1
-
Edit the
duckdb.d/conf.yamlfile, in theconf.d/folder at the root of your Agent's configuration directory to start collecting your duckdb performance data. See the sample duckdb.d/conf.yaml for all available configuration options.
Run the Agent's status subcommand and look for duckdb under the Checks section.
See metadata.csv for a list of metrics provided by this integration.
The DuckDB integration does not include any events.
The DuckDB integration does not include any service checks.
Need help? Contact Datadog support.