How it Works

Hotdata provides workspace-scoped execution with explicit lifecycle and isolation.

                    ╔═ hotdata ═══════════════════════════════╗
╔══════════╗        ║                                         ║░
║          ║░  API  ║  ┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓    ║░
║  client  ║░──────▶║  ┃   workspaces                    ┃    ║░
║          ║░       ║  ┃  ┏━━━━━━━━━━━━━━━━━━━━━━━━┓     ┃    ║░
╚══════════╝░       ║  ┃  ┃ cached:                ┃     ┃    ║░
 ░░░░░░░░░░░░       ║  ┃  ┃    - tables            ┃     ┃    ║░
                    ║  ┃  ┃    - schema            ┃     ┃    ║░
                    ║  ┃  ┃    - datasets          ┃     ┃    ║░
                    ║  ┃  ┃    - queries           ┃     ┃    ║░
                    ║  ┃  ┗━━━━━━━━━━━━━━━━━━━━━━━━┛     ┃    ║░
                    ║  ┗━━━━━━━┳━━━━━━━━━━━━━━━━━━━━━━━━━┛    ║░
                    ║          │                              ║░
                    ╚══════════╂══════════════════════════════╝░
                     ░░░░░░░░░░│░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░░
                               │
               ╔═══════════════╩═══════════════╗
               ║░                              ║░
        ╔══warehouses═══╗                    ╔═══databases══╗
        ║               ║░                   ║              ║░
        ║ - snowflake   ║░                   ║ - postgres   ║░
        ║ - bigquery    ║░                   ║ - mysql      ║░
        ║ - etc         ║░                   ║ - etc        ║░
        ║               ║░                   ║              ║░
        ╚═══════════════╝░                   ╚══════════════╝░
         ░░░░░░░░░░░░░░░░░                    ░░░░░░░░░░░░░░░░

The request flow

App

The app is where you manage:

organizations and membership
workspaces and workspace lifecycle
connections and secrets

API

The API serves /v1/* endpoints for:

workspaces (/v1/workspaces)
queries (/v1/query)
results (/v1/results)
connections (/v1/connections)
tables (/v1/information_schema)
file uploads (/v1/files)
datasets (/v1/datasets)
secrets (/v1/secrets)