Skip to content
Get startedRequest a demo

Databases, lakes, and warehouses

Where structured data lives.

All systems below are queryable via Flume’s Lakehouse (Trino + Iceberg). Systems marked in the Trino column have a native Trino connector, meaning they support both direct metadata introspection via their native protocol and federated analytical queries via Trino. This dual-path access enables cross-system joins, unified profiling, and data validation without moving data.

RDBMS

ConnectorDeployment modelsTrino
SQL ServerOn-prem, Azure SQL, AWS RDSTrino
PostgreSQLOn-prem, RDS/Aurora, Cloud SQL, Azure, Supabase, NeonTrino
MySQL / MariaDBOn-prem, RDS/Aurora, Cloud SQL, Azure, PlanetScaleTrino
OracleOn-prem, OCI Autonomous, RDSTrino
CockroachDBCloud, self-hostedNo Trino

Cloud warehouses

ConnectorDeployment modelsTrino
SnowflakeAWS, Azure, GCPTrino
BigQueryGCP nativeTrino
RedshiftProvisioned, ServerlessTrino
DatabricksUnity Catalog or Hive, on AWS, Azure, GCPTrinoVia Delta, Hive, Iceberg

Legacy and enterprise warehouses

ConnectorDeployment modelsTrino
TeradataOn-prem, Vantage CloudNo Trino
VerticaOn-prem, cloudTrino
ExasolSaaS, self-managedTrino
SAP HANAOn-prem, HANA CloudNo Trino

OLAP and real-time analytics

ConnectorDeployment modelsTrino
ClickHouseCloud, Altinity, on-premTrino
Apache DruidSelf-managed, Imply CloudTrino
Apache PinotSelf-managed, StarTree CloudTrino
SingleStore (MemSQL)Cloud (Helios), self-managedTrino

NoSQL, document, and wide-column

ConnectorDeployment modelsTrino
MongoDBAtlas, on-prem, DocumentDBTrino
Cassandra / ScyllaDBOn-prem, Astra, ScyllaDB CloudTrino
DynamoDBAWS nativeNo Trino
Elasticsearch / OpenSearchSelf-managed, Elastic Cloud, Amazon OpenSearchTrino

Streaming and event stores

ConnectorDeployment modelsTrino
Apache KafkaSelf-managed, Confluent Cloud, MSK, Azure Event HubsTrino

In-memory and cache

ConnectorDeployment modelsTrino
RedisOSS, Cloud, ElastiCache, Azure CacheTrino
Apache IgniteSelf-managedTrino

Embedded and edge analytics

ConnectorDeployment modelsTrino
DuckDBLocal files, MotherDuck (cloud)Trino

Operational and observability data

ConnectorDeployment modelsTrino
PrometheusSelf-managed, Grafana Cloud, Amazon Managed PrometheusTrino
Grafana LokiSelf-managed, Grafana CloudTrino

Open table formats on object storage

ConnectorDeployment modelsTrino
Delta Lake / Iceberg / HudiS3, GCS, ADLS, via Spark, Trino, Athena, DatabricksTrino

Lightweight and uncommon

ConnectorDeployment modelsTrino
Google SheetsGoogle WorkspaceTrino

Every connection starts from the pre-engagement checklist and goes through the universal validation protocol before production sign-off.

Other systems

Flume builds custom connectors for systems not listed in this guide.