Use Azure Synapse serverless SQL pools to transform data in a data lake
|
By using a serverless SQL pool in Azure Synapse Analytics, you can use the ubiquitous SQL language to transform data in files in a data lake.
Use a CREATE EXTERNAL TABLE AS SELECT (CETAS) statement to transform data., Encapsulate a CETAS statement in a stored procedure., Include a data transformation stored procedure in a pipeline.
Prerequisites
Consider completing Use Azure Synapse serverless SQL pool to query files in a data lake before starting this module. You will need the following knowledge or experience:
Familiarity with Azure Synapse Analytics.
Experience using Transact-SQL to query and manipulate data.
User Reviews
Be the first to review “Use Azure Synapse serverless SQL pools to transform data in a data lake”
Related Products
Designing Data Systems
Master the principles of designing data systems that handle large-scale data efficiently.
Transform data with Spark in Azure Synapse Analytics
Data engineers commonly need to transform large volumes of data. Apache Spark pools in Azure Synapse Analytics provide a distributed processing platform that they can use to accomplish this goal.
Organizational Privacy Engineering
Explore organizational approaches to designing privacy-aware systems and frameworks for data governance.
Use Spark Notebooks in an Azure Synapse Pipeline
Apache Spark provides data engineers with a scalable, distributed data processing platform, which can be integrated into an Azure Synapse Analytics pipeline.
Data Ingestion with Kafka and Kafka Streaming
Learn how to build real-time data ingestion pipelines using Apache Kafka.
Introduction to data engineering on Azure
Microsoft Azure provides a comprehensive platform for data engineering; but what is data engineering? Complete this module to find out.
There are no reviews yet.