Question 1

What is OptimaFlo's Medallion Architecture?

Accepted Answer

OptimaFlo organizes your data in three layers: raw (as-is from the source), cleaned (deduplicated, typed, validated), and business-ready (metrics and reports). Each layer is stored on Apache Iceberg giving you ACID transactions, schema evolution, and time-travel queries out of the box.

Question 2

How does the automatic engine selection work?

Accepted Answer

OptimaFlo picks the right processing engine for each query based on data volume: DuckDB for datasets under 100GB, a cloud warehouse for up to 10TB, and Spark for anything larger. Which engines are available depends on your plan: Starter includes DuckDB, Growth adds Warehouse + Spark, and Scale adds Dedicated Spark for the heaviest workloads.

Question 3

What security features does OptimaFlo provide?

Accepted Answer

OptimaFlo includes role-based access control, workspace-scoped data isolation, append-only audit logging, and BYOC deployment. Your data stays in your own cloud infrastructure. All data is stored in Apache Iceberg with full snapshot history for compliance.

Question 4

How quickly can I get started with OptimaFlo?

Accepted Answer

You can connect your first data source and have a working pipeline in hours, not months. The Concierge AI walks you through setup conversationally from authentication and schema inference to your first pipeline and dashboard. No coding required.

Question 5

What cloud platforms does OptimaFlo support?

Accepted Answer

OptimaFlo currently supports BYOC deployment on Google Cloud Platform, with AWS and Azure support on the roadmap. Your pipelines run on Cloud Composer (Airflow) and data is stored in Apache Iceberg on GCS.

Question 6

How does pipeline monitoring work?

Accepted Answer

OptimaFlo tracks every pipeline execution with status updates, error reporting, and execution history. You can monitor runs from the dashboard and track completions and failures in real time.

Question 7

What data sources can I connect?

Accepted Answer

OptimaFlo supports BigQuery, Google Cloud Storage, REST APIs, and GraphQL today, with PostgreSQL, S3, Snowflake, MySQL, Redshift, and SaaS connectors on the roadmap. Most sources connect with one-click OAuth or a service account key.

Question 8

How does the AI work, and which models are supported?

Accepted Answer

OptimaFlo is BYOLLM, meaning you bring your own API key. Currently supported models include Claude, GPT, and Gemini. The AI powers six specialized agents: Concierge, Data Source AI, SQL Copilot, Pipeline Generator, Dashboard Generator, and Analyst AI.

Question 9

How does data quality scoring work?

Accepted Answer

Tables are scored across five quality dimensions: completeness, accuracy, consistency, freshness, and uniqueness. Quality scoring runs alongside pipeline execution to surface data issues. Schema enforcement blocks unsafe type changes, and self-healing SQL auto-corrects errors at runtime.

Question 10

Can I export data out of OptimaFlo?

Accepted Answer

Yes, OptimaFlo currently supports exporting processed data to BigQuery and Google Cloud Storage, with PostgreSQL, MySQL, Snowflake, and Amazon S3 on the roadmap. Your Gold-layer tables are stored in Apache Iceberg, so any tool that reads Iceberg (Spark, Trino, DuckDB) can query them directly.

Select a preferred cycle	Starter $ 0 0123456789 0 0123456789 0 0123456789 0 0123456789 /billed monthly Start building	Growth $ 0 0123456789 0 0123456789 0 0123456789 0 0123456789 /billed monthly Get started	Scale $ 0 0123456789 0 0123456789 0 0123456789 0 0123456789 0 0123456789 /billed monthly Get started	Enterprise Custom pricing Contact sales
Concurrent Pipelines	10	50	200	Unlimited
Data Sources	5	20	100	Unlimited
Processing Engines	DuckDB up to 100 GB	DuckDB + Warehouse + Spark up to 2 TB	DuckDB + Warehouse + Dedicated Spark up to 10 TB	All engines Unlimited
Pipeline Runs/Month	1,000	5,000	20,000	Unlimited
Concierge AI		50/mo
Analyst AI	50/mo	500/mo
Pipeline AI Builder	5/mo	25/mo
Data Source AI
SQL Copilot	100/mo
Dashboard AI	3/mo	20/mo
AI Instructions	10 saves/mo
Data Quality Scoring
BYOC Deployment
Destination Exports
Scheduled Pipelines
Anomaly Detection
Data Lineage
BI Audit Logging
Support	Email	Priority	Dedicated	24/7

One Platform, One Price

What's Your Data Chaos Costing?

Why pay more?

Need Help?

One Platform
Your Entire Data Stack

Product

Company

Resources

We value your privacy