Skip to content

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.

Tables

There is only one table in wallowa so far.

wallowa_raw_data

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:

sql
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
)