The Visual Query Editor

Now that we’ve written a query using traditional SQL, let’s examine the Visual Query editor. This Fabric tool allows analysts to construct SQL queries through a visual interface, enabling data analysis for users without deep SQL knowledge.

In this exercise, we’ll recreate the query from the previous exercise in the visual query. We’ll find the campaigns with the most impressions. Let’s get started!

Note: This exercise assumes you have loaded a table named marketing in your lakehouse. If you lost your progress and don't have access to your lakehouse, you can find marketing.csv in Desktop/Datasets and upload it to a new lakehouse.