Below is a table explaining some specifics around how FIDO interacts with each data source it connects to.
Data Source TypePersistent Connections Supported?Other Notes
AthenaN/A - Athena has no persistent connection support.All features supported
BigQueryN/A - BigQuery has no persistent connection support.All features supported
ClickhouseYesAll features supported
DatabricksN/A - Pooled connections maintained but no keepalives used. Warehouse is allowed to sleep when no Explo activity occurs.All features supported
MotherduckYesAll features supported
MySQLYesOnly 5.7+ supported; percentile calculations only fully supported in 8.0+
PostgresYesAll features supported (recommend Postgres 12+)
RedshiftYes - but possible to disable keepalives for serverless warehouse. Contact support if interested.All features supported
SnowflakeN/A - Pooled connections maintained but no keepalives used. Warehouse is allowed to sleep when no Explo activity occurs.All features supported
SQL ServerYesAll features supported
SupabaseYesAll features supported; note must use IPv4 to connect or Supavisor Session Mode

​
Connection Keep Alive Queries

For data source types that support persistent connections, we periodically validate that each connection is still valid. After one minute since the last successful query on that connection, we will run SELECT 1 as result as validation. If this query fails, we will replace that specific connection. Keeping these connections alive and valid helps decrease query latency, providing a better end-user experience.

​
Disabling Keep Alive Queries

For data source types that offer a serverless variety (such as Redshift Serverless), keep alive queries can cost you money because they keep the database awake. We offer the ability to disable keepalives for cases like that. Please reach out to support if you’d like to disable keep alive queries.