Test Drive Scenario

Here is a sample scenario to test out the Wrangler in your environment

1. Log into Microsoft Fabric: Go to app.fabric.microsoft.com

2. Create a Lakehouse for the destination table.

   1. Below is a sample Lakehouse table schema for the scenario. The SQL script is run in a notebook, which will generate your table. Note that there are various methods for creating a schema.

%%sql
CREATE TABLE Sales_Orders_Sample (
 Customer_Name STRING,
 Company STRING,
 Order_Date DATE, 
 Order_No STRING,
 Qty FLOAT,
 Parts_Ordered STRING,
 Price FLOAT,
 Address STRING,
 Description STRING
) USING DELTA;

1. Upload your Source data file(s) to the Lakehouse

   1. Below are two sample files to run through your Wrangler.

17KB

Sample Orders.xlsx

Excel Sample File

58KB

SampleOrder#2.pdf

pdf

PDF Sample File

1. Create an AI Data Wrangler

2. Run Your Wrangler

3. Write the data to your Destination