Arrow Flight SQL

Arrow Flight SQL provides the highest-performance interface for streaming large analytical datasets between Altertable and your tools. Built on Apache Arrow's columnar format, it's ideal for:

• Analytics tools like dbt, Airbyte, and custom data pipelines
• Large result sets that benefit from efficient columnar data transfer
• High-throughput workloads requiring minimal serialization overhead

Authentication

Use your Altertable credentials with any Arrow Flight SQL client:

• Username: Your Altertable username
• Password: Your Altertable password

Python Client

Altertable provides an official Python client library (altertable-flightsql) that makes it easy to connect to Altertable via Arrow Flight SQL. The library handles authentication, connection management, and provides a clean interface for queries, transactions, and metadata operations.

Installation

pip install altertable-flightsql

Quick Start

from altertable_flightsql import Client

# Connect to Altertable
with Client(username="your_username", password="your_password") as client:
    # Execute a query
    reader = client.query("SELECT * FROM users WHERE age > 18")

    # Process results
    for batch in reader:
        df = batch.data.to_pandas()
        print(df)

For more details, examples, and advanced usage, see the GitHub repository.

Other Clients

Python ADBC

import adbc_driver_flightsql.dbapi as flight_sql

conn = flight_sql.connect(
    uri="grpc+tls://flight.altertable.ai:443",
    db_kwargs={
        "username": "your_username",
        "password": "your_password"
    }
)

cursor = conn.cursor()
cursor.execute("SELECT * FROM your_database.your_schema.your_table LIMIT 10")
results = cursor.fetchall()