Skip to content

Reference

Technical reference documentation for QuickETL.

Reference Guides

Guide Description
Expressions SQL expression syntax
Data Types Type system and mapping
Environment Variables Configuration variables
Troubleshooting Common issues and solutions

Expression Language

QuickETL uses SQL-compatible expressions for filters, derived columns, and checks:

transforms:
  - op: filter
    predicate: amount > 100 AND status = 'active'

  - op: derive_column
    name: total
    expr: quantity * price * (1 - discount)

Expression Reference →

Data Types

Standard types that map across all backends:

Type Description
string Text data
int Integer numbers
float Floating-point
bool Boolean
date Calendar date
timestamp Date and time
decimal Precise decimal

Data Types Reference →

Environment Variables

Configure connections and credentials via environment:

export POSTGRES_HOST=localhost
export POSTGRES_USER=quicketl
export AWS_REGION=us-east-1

Environment Variables →

Troubleshooting

Common issues and solutions:

  • Installation problems
  • Configuration errors
  • Runtime failures
  • Performance issues

Troubleshooting Guide →