Skip to content
On this page

Data analysis

Analyze with DuckDB

Thanks to DuckDB the data collected by wallowa can be analyzed in several ways including:

Follow the DuckDB guides to learn more.


There is only one table in wallowa so far.


This table stores the raw JSON payloads from the APIs that data is fetched from. Queries can use the DuckDB JSON extension to extract the data of interest from the payloads. See:

CREATE SEQUENCE seq_wallowa_raw_data;
CREATE TABLE IF NOT EXISTS wallowa_raw_data (
    id INTEGER PRIMARY KEY DEFAULT NEXTVAL('seq_wallowa_raw_data'),
    created_at TIMESTAMP DEFAULT now() NOT NULL,
    loaded_at TIMESTAMP,
    "data_source" VARCHAR,
    data_type VARCHAR,
    metadata JSON,
    "data" VARCHAR