Import/Export from SQL Databases

What it covers

• Export entire tables or filtered queries to any SQL database
• Importing exported data back into Pixeltable
• Select specific columns for export
• Handle existing tables with replace or append options
• Connect to cloud PostgreSQL services (e.g. TigerData)

What it uses

Install

terminal

$pip install pixeltable snowflake-sqlalchemy

Pixeltable calls

pxt.create_table()insert()add_computed_column()

A look at the code

# Create a table with images
images = pxt.create_table(
    'sql_export_demo/images', {'image': pxt.Image, 'label': pxt.String}
)

# Add computed columns for metadata
images.add_computed_column(width=images.image.width)
images.add_computed_column(height=images.image.height)
images.add_computed_column(mode=images.image.mode)

One cell of the notebook, copied as it is. Open it in Colab for the rest.

• Export data for analytics

  Export Pixeltable tables and queries to CSV, JSON, and Apache Iceberg for spreadsheets, scripts, and the lakehouse.

  Updated Jul 15, 2026Open in Colab

• Sample data for training and testing

  Create training, validation, and test splits with random or stratified sampling.

  Updated Apr 10, 2026Open in Colab

• Import data from CSV files

  Load data from CSV and Excel files into Pixeltable tables for processing and analysis.

  Updated Sep 3, 2026Open in Colab

• Import data from JSON files

  Load structured data from JSON files into Pixeltable tables for processing and analysis.

  Updated Apr 10, 2026Open in Colab