Write Results Back - Teradata AI Studio

import ray
import teradatasql

# Sample dataset — any Ray Dataset works (from_items, from_pandas, read_csv, …)
ds = ray.data.from_items([
    {"id": 1, "name": "alice", "score": 10.5},
    {"id": 2, "name": "bob",   "score": 20.25},
    {"id": 3, "name": "carol", "score": 30.125},
])

# One INSERT with '?' placeholders per column, in the dataset's column order.
ds.write_sql(
    'INSERT INTO "demouser"."write_demo" (id, name, score) VALUES (?, ?, ?)',
    connection_factory=teradatasql.factory(
        host="<hostname>",
        user="<db_username>",
        password="<db_password>"
    ),
)