HTTP API

Ingest with HTTP API

The HTTP API provides a lightweight interface for ingesting data into Altertable.

With the HTTP API, you can:

Upsert CSV, JSON, and Parquet files
Append event-style JSON records

Quick start

You can send individual records, but microbatching several records usually gives you much higher throughput. Append records with cURL or SDKs:

cURL

# echo -n "your_lakehouse_username:your_lakehouse_password" | base64
ALTERTABLE_BASIC_AUTH_TOKEN="your_base64_token"

CATALOG="my_catalog"
SCHEMA="public"
TABLE="my_table"

curl "https://api.altertable.ai/append?catalog=$CATALOG&schema=$SCHEMA&table=$TABLE" \
  -H "Authorization: Basic $ALTERTABLE_BASIC_AUTH_TOKEN" \
  -d '{"name": "Alice", "age": 30, "email": "[email protected]"}'

SDKs

Installation

pip install altertable-lakehouse

Usage

from altertable_lakehouse import Client

client = Client(
    username="your_lakehouse_username",
    password="your_lakehouse_password",
)

# Append rows to a table
client.append(
    catalog="my_catalog",
    schema="public",
    table="users",
    data={"user_id": 1, "plan": "pro"},
)

# Upload a CSV file (append mode)
with open("users.csv", "rb") as file:
    client.upload(
        catalog="my_catalog",
        schema="public",
        table="users",
        format="csv",
        mode="append",
        file=file,
    )

API reference

Use the reference page for endpoint details, payload shapes, and full examples:

The same reference also covers related query, validation, and task endpoints: