Azure Synapse Analytics is a cloud-based data warehousing and analytics service developed by Microsoft. It allows users to analyze large amounts of data using both on-demand and provisioned resources. This makes it an ideal tool for organizations that need to handle large amounts of data and gain insights from it in real-time.
One of the key features of Azure Synapse Analytics is its ability to create data pipelines. Data pipelines allow users to extract, transform, and load data from various sources into a data warehouse for analysis. This can be done using a variety of tools, including Azure Data Factory, which is a cloud-based data integration service. This feature enables organizations to easily move data from various sources into Azure Synapse Analytics for analysis.
Azure Synapse Analytics also includes a variety of analytics tools, such as Spark and Azure Machine Learning. These tools can be used to gain insights from the data, such as identifying patterns or trends. Additionally, it also includes SQL on-demand, which allows users to quickly and easily analyze data using standard SQL queries.
Another powerful feature of Azure Synapse Analytics is its ability to create data lakes. Data lakes are a type of data repository that allows organizations to store large amounts of data in its native format. This makes it easy to analyze data using a variety of tools and allows organizations to easily store and access their data. This feature also allows organizations to store data at a lower cost, since data lakes are typically less expensive than traditional data warehouses.
Azure Synapse Analytics also includes a variety of security and compliance features, such as Azure Active Directory integration and data encryption. This makes it an ideal tool for organizations that need to meet strict security and compliance requirements.
Overview
Quick Start
- Overview: What is Azure Synapse Analytics?
- Quickstarts: Creating a Synapse workspace (Azure Portal)
- Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
- Quickstarts: Analyze data with serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Quickstart: Use serverless SQL pool
Serverless SQL Pools
Architecture & Development Practices
- Workspace: Azure Synapse Analytics shared database
- Synapse SQL: Serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Azure Synapse SQL architecture
- Synapse SQL: Transact-SQL features supported in Azure Synapse SQL
- Synapse SQL: Design decisions and coding techniques for Synapse SQL features in Azure Synapse Analytics
- Synapse SQL: Use T-SQL loops with Synapse SQL in Azure Synapse Analytics
- Synapse SQL: Stored procedures using Synapse SQL in Azure Synapse Analytics
- Synapse SQL: User-defined schemas within Synapse SQL
Tutorials
- Synapse SQL: Tutorial: Explore and Analyze data lakes with serverless SQL pool
- Synapse SQL: Tutorial: Use serverless SQL pool with Power BI Desktop & create a report
Reading Data From Storage
- Synapse SQL: Query storage files with serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query CSV files
- Synapse SQL: Query Parquet files using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query JSON files using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query nested types in Parquet and JSON files by using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Query folders and multiple files
- Synapse SQL: Use file metadata in serverless SQL pool queries
- Synapse SQL: Create and use views using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Create and use external tables using serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: How to use OPENROWSET using serverless SQL pool in Azure Synapse Analytics
Writing Data To Storage
Connectivity
- Synapse SQL: Connect to Synapse SQL
- Synapse SQL: Connect to Synapse SQL with Azure Data Studio
- Synapse SQL: Connect to Synapse SQL with SQL Server Management Studio (SSMS)
- Synapse SQL: Connect to serverless SQL pool with Power BI Professional
- Synapse SQL: Quickstart: Use Python to query a database
Best Practices
Administration
- Workspace: Quickstart: Create an Azure Synapse workspace with the Azure Portal
- Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
- Synapse SQL: Cost management for serverless SQL pool in Azure Synapse Analytics
- Synapse SQL: Use Synapse Studio to monitor your SQL requests
- Synapse SQL: Statistics in serverless SQL pool
- Tech Community: Always use UTF-8 collations to read UTF-8 text in serverless SQL pool
- Reference: System views supported in Synapse SQL
- Workspace: Synapse Studio SQL scripts in Azure Synapse Analytics
- Workspace: Use Azure Monitor with your Azure Synapse Analytics workspace
- Workspace: How to set up access control for your Synapse workspace
- Workspace: Troubleshoot reading UTF-8 text from CSV or Parquet files using serverless SQL pool in Azure Synapse Analytics
Troubleshooting
- Workspace: Troubleshoot connectivity between Azure Synapse Analytics Synapse Studio and storage
- Resources: Self-help for Serverless SQL pool
- Overview: Microsoft Q&A Question Page
- Overview: Stack Overflow