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
MariaDB to BigQuery: sync MariaDB data to BigQuery
Connect MariaDB as a source through the same MySQL-protocol connector, and export modeled Gold-layer tables to BigQuery. What is genuinely different about MariaDB, and what full-refresh sync leaves out.
Read the guideGA4 to Iceberg: land Google Analytics 4 reports in your own AWS account
Connect Google Analytics 4 via the Data API and land report data as open Apache Iceberg tables in your own AWS account, no BigQuery project required. Service account setup and honest limits.
Read the guideMySQL to Iceberg: land MySQL data in Apache Iceberg
Connect MySQL and land the data as open Apache Iceberg tables in your own AWS account. No BigQuery project or Snowflake account required. Setup, schema reflection, and honest limits.
Read the guidePostgres to Iceberg: land PostgreSQL data as open Iceberg tables in your own AWS account
Connect a PostgreSQL database and land the data as open Apache Iceberg tables in your own AWS account, no BigQuery project required. Setup, schema inference, and honest limits.
Read the guideGA4 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 data to BigQuery
Connect MySQL 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 tables as open Iceberg tables
Redshift to Iceberg: connect with password or IAM auth and land tables or queries as open Apache Iceberg tables in your own AWS account.
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 guide