---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: datadog
excerpt: |
  DuckDB Community Extensions
  Read logs from the Datadog Logs Search API into OTLP-shaped tables

extension:
  name: datadog
  description: Read logs from the Datadog Logs Search API into OTLP-shaped tables
  version: 0.2.0
  language: C++
  build: cmake
  license: MIT
  requires_toolchains: "cmake, openssl"
  maintainers:
    - smithclay

repo:
  github: smithclay/duckdb-datadog
  ref: aaf234fda701d1c4dffb75c3b9aa25a1ce32e9f9

docs:
  hello_world: |
    -- Store your Datadog credentials once (kept out of query text; redacted in duckdb_secrets()).
    CREATE SECRET (
        TYPE datadog,
        API_KEY '<dd-api-key>',
        APP_KEY '<dd-application-key>',
        SITE 'datadoghq.com'          -- optional; e.g. datadoghq.eu, us5.datadoghq.com
    );

    -- Read a window of logs; the extension follows Datadog's cursor pagination for you.
    SELECT time_unix_nano, service_name, severity_text, body
    FROM read_datadog_logs(
        query  => 'service:web-store status:error',
        "from" => 'now-1h',
        "to"   => 'now'
    );
  extended_description: |
    This extension reads logs from the [Datadog Logs Search API v2](https://docs.datadoghq.com/api/latest/logs/)
    directly into DuckDB. Rows conform to the OTLP logs schema (matching
    [duckdb-otlp](https://github.com/smithclay/otlp2records) `read_otlp_logs`), so Datadog logs drop
    straight into an OTLP-shaped lakehouse alongside data from other sources.

    Features:
    - **Credentials via DuckDB secrets** (`CREATE SECRET (TYPE datadog, ...)`), redacted in `duckdb_secrets()`
    - **Cursor pagination** over the whole time window, streaming page-by-page
    - **Automatic retries** for rate limits (HTTP 429, honoring the server-advised reset), HTTP 5xx,
      and transient network errors; retry waits honor query cancellation
    - **Projection pushdown**: only selected columns are decoded, so aggregations skip the per-row
      attribute JSON serialization
    - Datadog custom attributes are exposed as JSON in `log_attributes` for use with DuckDB's JSON functions

    Logs are supported today; traces/spans and metrics are planned. For full documentation, visit the
    [extension repository](https://github.com/smithclay/duckdb-datadog).

extension_star_count: 3
extension_star_count_pretty: 3
extension_download_count: 829
extension_download_count_pretty: 829
image: '/images/community_extensions/social_preview/preview_community_extension_datadog.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Linux ARM64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| macOS AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| macOS ARM64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Windows AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ✅ | ✅ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

|           function_name           | function_type | description | comment | examples |
|-----------------------------------|---------------|-------------|---------|----------|
| datadog_serve                     | scalar        | NULL        | NULL    |          |
| datadog_stop                      | scalar        | NULL        | NULL    |          |
| read_datadog_log_stats            | table         | NULL        | NULL    |          |
| read_datadog_logs                 | table         | NULL        | NULL    |          |
| read_datadog_metrics              | table         | NULL        | NULL    |          |
| read_datadog_service_dependencies | table         | NULL        | NULL    |          |
| read_datadog_traces               | table         | NULL        | NULL    |          |
| send_datadog_logs                 | scalar        | NULL        | NULL    |          |
| write_datadog_traces              | scalar        | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

This extension does not add any settings.