SUPPORTED DATABASES
FULL ADAPTER SUPPORT (PUSHDOWN + EXTRACTION)
| DATABASE | TYPE | PUSHDOWN | EXTRACTION | TARGET |
|---|---|---|---|---|
| PostgreSQL | postgres | ✓ | ✓ | ✓ |
| Snowflake | snowflake | ✓ | ✓ | ✓ |
| BigQuery | bigquery | ✓ | ✓ | ✓ |
| Redshift | redshift | ✓ | ✓ | ✓ |
| Databricks | databricks | ✓ | ✓ | ✓ |
| DuckDB | duckdb | ✓ | ✓ | ✓ |
| MySQL | mysql | ✓ | ✓ | ✓ |
| MariaDB | mariadb | ✓ | ✓ | ✓ |
| SQL Server | sqlserver | ✓ | ✓ | ✓ |
| Oracle | oracle | ✓ | ✓ | ✓ |
| Spark | spark | ✓ | ✓ | ✓ |
| Fabric | fabric | ✓ | ✓ | ✓ |
| MySQL 5.x | mysql5 | ✓ | ✓ | ✓ |
| ClickHouse | clickhouse | ✓ | ✓ | ✓ |
| Trino | trino | ✓ | ✓ | ✓ |
| SQLite | sqlite | ✓ | ✓ | ✓ |
| SingleStore | singlestore | ✓ | ✓ | ✓ |
| Amazon Athena | athena | ✓ | ✓ | ✓ |
| Vertica | vertica | ✓ | ✓ | ✓ |
SLING-ONLY CONNECTORS (EXTRACTION SOURCE)
SFTP/FTP
BUCKET STORAGES (SOURCE + TARGET)
Use cloud buckets or local filesystem as extraction sources or materialization targets. Data moves via Sling, compute runs in DuckDB.
| STORAGE | TYPE | KEY FIELDS |
|---|---|---|
| Amazon S3 | s3 | bucket, region, access_key_id, secret_access_key |
| Google Cloud Storage | gcs | bucket, project |
| Azure Blob Storage | azure | account, container, access_key |
| Local Filesystem | file | path |
Full bucket storages guide — profiles.yml setup, source/target examples, incremental extraction, supported formats.
FILE FORMATS
| FORMAT | READ | WRITE |
|---|---|---|
| CSV | ✓ | ✓ |
| Parquet | ✓ | ✓ |
| JSON / JSONL | ✓ | ✓ |
| Delta Lake | ✓ | ✓ |
| Avro | ✓ | ✓ |
| Excel (XLSX) | ✓ | — |
| IPC/Arrow | ✓ | ✓ |