FormulaHub Studio
Build better data automations, faster.
FormulaHub Studio is where you build data automations: pipelines that move and transform data from A to B. Design on a visual canvas, map fields with Formula Map, and run Python where the logic needs it.
Download at formulahub.io/etl. Trial, then a license.
formulahub.io/etl — studio
Canvas
Visual ETL studio
SFTP inbound
SourcePython transform.py
RunnerPostgres facts
Sink- SFTP
- PGP
- CSV
- Map
- Postgres
Formula Map
Source → target
order_id
→fact_order_id
dim_email
amount_cents
→amount_usd
created_at
→event_ts
Python runner
def transform(row): return normalize(row)
What you can build
Data automations from A to B
Every morning, pull an orders CSV from SFTP, decrypt it, clean it, and load it into Postgres. When a spreadsheet lands in email, check it and update Google Sheets. Connect your own systems when you are ready. Sample pipelines use practice data.
Sample pipeline (practice data)
Why Studio
Built for teams that own their data path
Built for data automations
Pipelines that move and clean data from A to B on a schedule or when a file arrives.
Visual and inspectable
Canvas plus Formula Map: every hop is readable, not a black-box job.
Runs on your systems
Install on your machine, network, or cloud account. You keep the credentials and the data path.
Data quality
Validate, cast, and reject bad rows before they poison the destination.
Observability
Runs you can audit: clear steps and logs, not mystery batch scripts.
Warehouse aware
Built with Postgres, Snowflake preview, and Databricks realities in mind. Costs stay on your bill.
AI suggests, you decide
Suggestions are proposals. Proof is in mapped fields, tests, and successful runs.
Python when you need it
Drop into code for the transform that the canvas cannot express cleanly.
Inside Studio
Canvas, Formula Map, and a clear run console
Formula Map is the field-mapping component in Studio. Map source fields to destinations, validate types, and keep every hop inspectable.
Open FormulaHub StudioCanvas
Visual ETL studio
Source → Formula Map → Sink
Postgres orders
Python transform.py
Warehouse facts
Drag nodes on the canvas, map fields once, run Python in the pipeline. Ship the flow.
Formula Map
Source → target fields
Map once. Reuse across runs.
order_id
→fact_order_id
Mappedcustomer_email
→dim_email
Mappedamount_cents
→amount_usd
Castcreated_at
→event_ts
MappedPython runner
transform.py — client VPC
return normalize(row)
Studio
Visual
Canvas + nodes
Mapper
Fields
Source to target
Deploy
Yours
Machine or cloud
Pricing
30-day free trial, then a license
Install FormulaHub Studio on your machine or in your cloud. After the trial, you need a license. Need a pipeline built for you? Start with a free automation brief.