🎇How to Process a File

How to Process a File with the Osmos AI Data Wrangler

Osmos AI Data Wrangler is run natively inside Microsoft Fabric as a Workload. Once added to the organization and you as a user, the Osmos Workload will become available in your home workspace.

Step 1: Select the Osmos Workload

The Fabric homepage displays a set of experiences you can run. These experiences are also called Workloads. Select the Osmos Workload to begin cleaning and transforming your file.

1. Go to Microsoft Fabric, https://app.fabric.microsoft.com/home

2. Select the Osmos Workload

Note: If the Osmos Workload is not present on your home page, either you have not been given access or the Workload has been enabled for your organization

Step 2: Select Your Workspace

In this step, select the Workspace where the AI Data Wrangler resides.

1. From the sidebar, select Workspace

2. Select the Workspace where your AI Data Wrangler resides

3. Click on the AI Data Wrangler

Step 3: Choose Source File

In the Osmos Wrangler, you will select the file(s), you wish to process.

1. Click on the Choose File icon

1. Choose the Lakehouse that contains the source file and hit Connect. Note, that the Lakehouse selected will turn light gray when selected.

1. Select the file(s) and hit Save. The source file(s) will automatically begin to process.

Step 4: Review the Cleaned Data

Once you select your file(s), they will be listed on the bottom half of the Workload.

Each file will have a status that updates as it moves through the cleaning and transformation.

Statuses include:

• Queued

• Processing

• Ready for Review

• Completed

• Failed

• Rejected

Step 5: Accept Your FIle and Write to the Destination

Review and Approve your file(s) before writing to the Lakehouse.

1. Select Ready for Review

1. To accept and to write to the destination, select Approve.

2. If you want to dispose of the current process, select Reject. The file will not be written to the destination.

   1. It will update to a Failed Status.

   2. Reasons for rejection may vary. For example, the user initially chose the wrong file to process.

3. If you select Retry, it will process the file again.

   1. It will not save the outcome of the previous run(s).

   2. The most common scenario for Retry is to incorporate column descriptor updates.

For more info see the section on Schema Descriptors