Copilot in Data Factory

There is currently one Copilot experience for Data Factory, which can be found when building a Dataflow Gen2. Just like the data science experience covered earlier in this chapter, the Data Factory Copilot lets you use natural language to describe the data transformations that you would like to apply to a dataset.

First, you will need to go through the get-data experience to acquire data. Optionally, apply any transformations you may know how to use on your own. Next, launch Copilot by creating a new Dataflow Gen2 and clicking the Copilot button on the Home tab of the ribbon. At this point, you will be greeted with a message informing you that Copilot can help you transform data or explain how the data is being transformed.

We can perform transformations such as combining all the address fields, in this case, city, state province, and country into a single column, as shown in Figure 11.27:

Figure 11.27 – Performing data...