Scheduling
Optimus provides an easy way to schedule your SQL transformation through a YAML based configuration.Dependency resolution
Optimus parses your data transformation queries and builds a dependency graphs automaticaly instead of users defining it in DAGs.Dry runs
Before SQL query is scheduled for transformation, during deployment query will be dry-run to make sure it passes basic sanity checks.Powerful templating
Optimus provides query compile time templating with variables, loop, if statements, macros, etc for allowing users to write complex tranformation logic.Cross tenant dependency
Optimus is a multi-tenant service. With more than two tenants registered Optimus can resolve cross tenant dependencies automatically.Hooks
Optimus provides hooks for post tranformation logic to extend the functionality of the transformation. e,g. You can sink BigQuery tables to Kafka.