Transform Data Using Transact‐SQL

Encode and Decode Data Machine Learning Microsoft DP-203 Transform Data by Using Scala Transform Data Using Transact‐SQL -3 Minutes

Transform Data Using Azure Synapse Pipelines – Transform, Manage, and Prepare Data-3

One action you may have noticed in Exercise 5.1 is that you used the existing pipeline that you created in Exercise 4.13. That pipeline performed one activity, which was to copy data from the...
Read More
Machine Learning Microsoft DP-203 Transform Data by Using Scala Transform Data Using Transact‐SQL -3 Minutes

Transform Data Using Azure Synapse Pipelines – Transform, Manage, and Prepare Data

It does provide some benefit to understand the structure of the data you must ingest, transform, and progress through the other Big Data pipeline stages. It is helpful to know because as you make...
Read More
Machine Learning Microsoft DP-203 Transform Data by Using Scala Transform Data Using Transact‐SQL -4 Minutes

Transform Data Using Apache Spark—Azure Databricks – Transform, Manage, and Prepare Data

The Azure Databricks workspace should resemble Figure 5.12. FIGURE 5.12 Transforming data using an Apache Spark Azure Databricks workspace The first important point for Exercise 5.4 has to do with the location of the...
Read More
Ingest and Transform Data Microsoft DP-203 Transform Data Using Transact‐SQL -3 Minutes

Transform Data Using Azure Synapse Pipelines – Transform, Manage, and Prepare Data-2

FIGURE 5.3 Azure Synapse Analytics—transformating Brainjammer brain waves FIGURE 5.4 Azure Synapse Analytics—monitoring Brainjammer brain wave transformationsSELECT COUNT(*) AS [COUNT] FROM [brainwaves].[FactREADING]...
Read More
Ingest and Transform Data Machine Learning Microsoft DP-203 Transform Data by Using Scala Transform Data Using Transact‐SQL -5 Minutes

Transform Data Using Azure Data Factory – Transform, Manage, and Prepare Data

Transform Data Using Azure Data FactoryThe capabilities for achieving most activities in Azure Data Factory (ADF) are also available in Azure Synapse Analytics. Unless you have a need or requirement to use ADF, you...
Read More
Ingest and Transform Data Microsoft DP-203 Transform Data by Using Scala Transform Data Using Transact‐SQL -4 Minutes

Transform Data Using Apache Spark—Azure Synapse Analytics – Transform, Manage, and Prepare Data-2

FIGURE 5.10 Transforming data using an Apache Spark Azure Synapse Spark pool That was a long and complicated exercise, so congratulations if you got it all going. Figure 5.11 illustrates how what you just...
Read More