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.