Further reading

• Supported classifications: https://docs.microsoft.com/en-us/azure/purview/supported-classifications
• Creating the airport dictionary:

1. Navigate to your Synapse Studio and there, in the Data hub, go to the Linked section where you have access to your data lake.
2. In your data lake, browse to the airdelays.csv file. (Do you have another idea of how to find this using Purview maybe?)
3. Right-click the airdelays.csv file and start a new SQL script using serverless SQL in Synapse.
4. Adjust the second line of the query text as follows:

   SELECT
       distinct ORIGIN
   FROM
       OPENROWSET(
   ...

5. Copy and paste the query text and enter a UNION command between the two.
6. In the second query, replace ORIGIN with DEST. Your query should look like this:

   Figure 14.24 – UNION query to generate the airports dictionary

7. Below the query text, please click on Export results and download the results as a CSV...