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