How to Process a File

How to Process a File with the Osmos AI Data Wrangler

Osmos AI Data Wrangler runs natively within Microsoft Fabric as a Workload. Once added to your organization and user account, the Osmos Workload will be available in your home workspace.

Step 1: Add the Osmos Workload

Click here for Quick access to the Osmos Workload.

Here are steps to add and/or access the Osmos Workload.

1. Once you are logged into Fabric, select Workloads from the side bar.

2. Select the Osmos Workload to begin cleaning and transforming your file.

   1. Get started by clicking on various available instructions and guides.

   2. To see the workspaces you have access to, click on the link below Workspaces can use

   

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 Workload menu or from the Workload sidebar, select your desired Workspace.

2. From within an existing Workspace, you will see various items such as a Lakehouse, Notebook(s), and one or more AI Data Wranglers.

3. Click on the AI Data Wrangler you wish to run.

Step 3: Choose Source File

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

Your data must exist in a lakehouse before it is available to ingest into AI Data Wrangler.

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 through the cleaning and transformation.

Statuses include:

• Queued

• AI 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 Column Descriptors.