🧠 What You’ll Learn
In this module, you'll learn:
-
What Azure Synapse is
-
How to create a Synapse workspace step-by-step
-
How to configure linked services (SQL, Blob, etc.)
-
Key setup tips for new users
💡 What is Azure Synapse Analytics?
Azure Synapse is Microsoft’s unified platform for data integration, warehousing, and big data analytics. It combines SQL-based data warehousing with Apache Spark, Data Lake, and powerful ETL pipelines — all in one place.
🧱 Step-by-Step: Create a Synapse Workspace
🧩 Step 1: Go to Azure Portal
-
Visit: https://portal.azure.com
-
Search for Synapse Analytics in the search bar
-
Click + Create
🧾 Step 2: Fill Workspace Details
-
Resource group: Create or select one
-
Workspace name: Example –
synapse-data-pipeline -
Region: Choose the one nearest to your users
-
Data Lake Storage Gen2: Choose or create a new Storage Account and container (file system)
✅ Pro Tip: Keep naming consistent across services for clarity.
🔐 Step 3: Review Security Settings
-
Set up Managed Identity
-
Optionally configure Networking and Firewall Rules
🚀 Step 4: Click “Review + Create” → Then “Create”
⏱ It will take 1–3 minutes to deploy.
📸 Image Tip: Include a screenshot of the “Create Synapse Workspace” form.
🔗 Connect Linked Services (Data Sources)
Once your workspace is ready:
-
Open Azure Synapse Studio (from portal or workspace link)
-
Go to Manage > Linked Services
-
Click + New and select a source (e.g., Azure SQL, Blob, etc.)
-
Enter credentials or use Managed Identity
-
Test connection → Create
✅ Use linked services to bring in data sources securely.
📸 Image Tip: Linked service creation screen in Synapse Studio
⚙️ Initial Configuration Tips
-
Set up Integration Runtimes for copy/move operations
-
Configure Apache Spark pool if you plan to run big data workloads
-
Turn on Git Integration if using version control (optional but useful)
📌 What’s Next?
In the next module, we’ll build your first data pipeline in Synapse using the GUI.
📍 Next Up: Module 3 — Build Your First Synapse Data Pipeline