Data integrations
Connect your data to OptimaFlo
Every connector infers schema on connect and lands data as open Apache Iceberg tables in your own cloud. Here is how each source works, what it takes to set up, and what is not supported yet.
Every integration
GA4 to BigQuery: send Google Analytics 4 reports to BigQuery
Connect Google Analytics 4 via the Data API and export modeled Gold-layer tables to BigQuery. Service account setup, dimension and metric validation, and paging limits.
Read the guideGCS to BigQuery: land Google Cloud Storage files as Iceberg, export to BigQuery
Connect a GCS bucket, ingest CSV, Parquet, JSON, or Avro files as open Iceberg tables, then export Gold-layer output to BigQuery. Auth options and honest limits.
Read the guideMySQL to BigQuery: sync MySQL and MariaDB data to BigQuery
Connect MySQL or MariaDB as a source and export modeled Gold-layer tables to BigQuery. Setup steps, schema reflection, and what full-refresh sync does not cover.
Read the guidePostgres to BigQuery: how to sync PostgreSQL data to BigQuery
Connect a PostgreSQL database to OptimaFlo and land the data as open Iceberg tables, then export Gold-layer tables to BigQuery. Setup, schema inference, and honest limits.
Read the guidePostgres to Snowflake: sync PostgreSQL data to Snowflake
Connect PostgreSQL as a source and export modeled Gold-layer tables to Snowflake. How the pipeline works, setup time, and what full-refresh sync means for freshness.
Read the guideRedshift to Iceberg: land Amazon Redshift tables as open Iceberg tables
Connect Amazon Redshift with password or IAM auth and ingest tables or queries as open Apache Iceberg tables in your own AWS account. Setup, auth options, and honest limits.
Read the guideREST API to your warehouse: ingest any JSON or CSV endpoint
Connect a REST API with API key, bearer, basic, or OAuth2 auth. Automatic pagination, nested JSON flattening, and SSRF protection, landed as Iceberg and exported to your warehouse.
Read the guideS3 to Iceberg: land Amazon S3 files as Apache Iceberg tables
Connect an S3 bucket and ingest CSV, Parquet, JSON, or Avro files as open Apache Iceberg tables in your own AWS account. Auth options, file selection, and honest limits.
Read the guideFrequently asked questions
More data than people? Put an AI data team on it.
From raw data to live dashboards in one conversation.
Now in early beta. One flat plan, no per-query tax. Runs in your cloud. Your data never leaves.