Skip to main content

Introduction

What is Accio

Define relationships, metrics, and expressions consistently with Accio. Experience a unified data view and let us generate on-demand SQL for a composable, reusable approach.

Accio unites your data in one expansive view, putting an end to scattered metrics and inconsistent queries. We enable the definition of relationships and easy computation of metrics. By generating SQL on-demand, we ensure a consistent, composable, and reusable approach, making data analytics smoother and more efficient.

  1. Unified Data: Accio brings together scattered metrics and inconsistent queries into one expansive view, allowing for centralized and unified data analytics. It enables the definition of relationships and easy computation of metrics.
  2. On-Demand SQL Generation: Accio dynamically generates SQL queries on-demand, ensuring a consistent, composable, and reusable approach, making data analytics smoother and more efficient.
    • The Accio SQL syntax closely adheres to the ANSI SQL standard, while currently there are some limitation. Accio only support query statement, and not support transaction. Currently there are some query statement still in progress. e.g. JOIN WITH RECURSIVE
  3. Consistency and Reusability: The SQL queries and data models generated by Accio exhibit consistency and reusability. This means that you can easily use the same models and query logic in different scenarios and queries, improving development efficiency.
  4. Structured Model Definition Language: Accio employs its own model definition language, making the definition of data models and relationship settings clearer and more manageable. This structured definition language facilitates the writing and maintenance of data models.