Verifying aggregated data in the gold layer

Assuming the previous invocation of electroniz_batch_aggregation_pipeline was successful, you should see the following external tables and views in the silver container of the Azure Data Lake Storage account:

1. Using the Azure portal, navigate to Home > All Resources > trainingsynapse100.

   Now, click on Open in the Open Synapse Studio section:

   Figure 8.31 – The Open Synapse Studio section

2. Using the menu on the left, click on Data. Now, keep clicking on the arrow beside Database, then gold (SQL) and External Tables.

   You should now see the following pane:

   

   Figure 8.32 – Silver layer external tables in the Synapse serverless SQL pool

3. Similarly, the following external tables and views represent the aggregated data in the gold layer:

   Figure 8.33 – Gold layer external tables and views in the Synapse serverless SQL pool

4. Let's go even further and fetch data from a view. To query the view, click on the three...