Building a First Use Case

To get started with Infoworks, a sample use case is explained here.

The process includes the following steps:

• Onboarding Data - obtaining data from various sources onto Infoworks.

• Preparing Data - preparing and transforming the ingested data.

• Operationalizing Data - organizing and collecting all relative tasks and running them in a single flow.

Prerequisites

• Download the CSV files from here.

• Upload the data to DBFS.

Procedure

Following are the steps to execute this use case:

• Create a source with two CSV files, orders and customers.

• Ingest the tables, orders and customers.

• Create a pipeline to transform the table data.

• Join the orders and customers tables using specific conditions.

• Calculate the aggregate for the sales growth by country and store them in a target.

• Build the pipeline.

• Create a workflow with the ingestion and pipeline build tasks.

• Build the workflow.