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)
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 |
Environment Variables¶
Configure connections and credentials via environment:
Troubleshooting¶
Common issues and solutions:
- Installation problems
- Configuration errors
- Runtime failures
- Performance issues