Workflows

Connecting the Dots in Daana

Workflows in Daana are like setting up an assembly line for your data. You connect different pieces—your source data, model, and target environment—to automate how data flows through the system. It’s all about turning raw data into something useful, without needing to manage every step manually. Here’s how it works:

1. Source

This is where your data starts. Think of the source as the raw material coming into your factory. It could be a database like BigQuery, Snowflake, or MSSQL. In Daana, you connect to this source, ensuring Daana knows where to pull the data from. Once connected, you can move on to the magic part—mapping.

• Configure Mapping: This is where you define how the raw data from your source connects to your business model. Essentially, you tell Daana how the data should be transformed, setting up the rules for what needs to happen before it’s useful for your business.

2. Model

This is the blueprint for your data, the information model we discussed earlier. It’s where Daana starts making sense of your raw data, organizing it into structured entities like customers, transactions, or products. Once your model is configured, Daana automatically aligns the data to this model, making sure everything fits into the right place.

3. Target

Your target is where the processed data ends up. Once Daana finishes transforming your data based on your model, it needs somewhere to send it—and this is your target. By default, Daana will create a schema / dataset called DAANA_DW where you'll find both the integrated DWH layer and the access/consumption tables.

4. Deployment

Once everything is mapped and configured, you need to deploy the workflow. Configure Deployment is where you set up how often and when this data pipeline runs. Whether it’s scheduled or triggered manually, Daana handles the hard work of moving data from source to target.

---

In short, workflows in Daana let you automate the process of transforming and moving data through a series of well-defined steps. You’re not just pushing data around—you’re organizing it to be useful, clear, and aligned with how your business thinks.