Data Connector (FIDO)
Data Source Specifics
Below is a table explaining some specifics around how FIDO interacts with each data source it connects to.
| Data Source Type | Persistent Connections Supported? | Other Notes |
|---|---|---|
| Athena | N/A - Athena has no persistent connection support. | All features supported |
| BigQuery | N/A - BigQuery has no persistent connection support. | All features supported |
| Clickhouse | Yes | All features supported |
| Databricks | N/A - Pooled connections maintained but no keepalives used. Warehouse is allowed to sleep when no Explo activity occurs. | All features supported |
| Motherduck | Yes | All features supported |
| MySQL | Yes | Only 5.7+ supported; percentile calculations only fully supported in 8.0+ |
| Postgres | Yes | All features supported (recommend Postgres 12+) |
| Redshift | Yes - but possible to disable keepalives for serverless warehouse. Contact support if interested. | All features supported |
| Snowflake | N/A - Pooled connections maintained but no keepalives used. Warehouse is allowed to sleep when no Explo activity occurs. | All features supported |
| SQL Server | Yes | All features supported |
| Supabase | Yes | All features supported; note must use IPv4 to connect or Supavisor Session Mode |