Azure Synapse Analytics โ Your Fast-Read Cloud SQL Data Warehouse
Meet Azure Synapse Analytics
Azure Synapse Analytics (formerly Azure SQL Data Warehouse) is a cloud data warehouse by Microsoft, which provides a unified workspace for building end-to-end analytics solutions by bringing together enterprise data warehouse and big data analytics.
According to Gartner and Forrester, this product is among cloud data warehousing leaders due to near-limitless scaling of storage and compute resources, deeply integrated SQL engine, native integrations with Power BI and Azure ML, and advanced security. Newell Brands, Unilever, Deutsche Bank are among companies using Azure Synapse Analytics.
Azure Synapse Analytics Features
General features
Quick deployment
Deploying a DWH in a few clicks.
Data integration with ETL/ELT
Quick processing of data of different volumes and of different types.
SQL-querying
Flexible querying with SQL of both relational and non-relational data.
Multilanguage support
Using T-SQL, Python, Scala, Spark SQL or .NET for both serverless and provisioned compute resources.
Automated restore points and backups
Ensuring high data availability and fault tolerance of the DWH.
Integrations
Integrations with Apache Spark
Ingesting big data, querying data lake with the supported languages.
Integrations with Power BI and Azure Machine Learning
Enabling BI and ML to discover powerful insights.
Integration with Azure Stream Analytics
Querying streaming data to conduct real-time analytics.
Integration with Azure Cosmos DB
Querying data in Cosmos DB with Azure Synapse Link to run near real-time analytics over operational data.
Integrations with third-party services
Integrating third-party solutions, including Tableau, SAS, Qlik, etc.
Performance
Scalability
Near-infinite scaling of storage and compute resources.
Massively parallel processing
Coordinated query processing by multiple computer processors.
Workload isolation
Reserving resources for specific workloads by creating workload groups.
Result-set caching
Speeding up queries by delivering precomputed/cached results.
Clustered columnstore indexes
Increasing query performance and improving data compression by up to 10 times.
Security and compliance
Always-on data encryption
Data encrypted in transit and at rest.
Dynamic data masking
Limited access of unauthorized users to sensitive data.
Granular access controls
Column-level security and native row-level security.
Compliance
Meeting national, regional, and industry-specific compliance requirements (HIPAA, ISO 27001/27002, PCI DSS, SOC 1 Type II, SOC II, SOC III, CJIS, HITRUST, ISMS, Germany C5, etc.).
Pricing
Price optimization
Optimizing Azure Synapse Analytics pricing with the service level choice, separate billing for compute and storage, possibility to reduce costs with DWH pausing.
Flexible pricing options
Choosing between pay-as-you-go and reserved capacity (allows saving up to 65%) pricing options.
|
ScienceSoft provides consultancy, implementation and support for data warehousing solutions based on Azure Synapse Analytics to help companies integrate this cloud data warehouse service into their analytics environment with minimal cost. |
Azure Synapse Analytics Use Cases
Azure Synapse Analytics Benefits
Accelerated analytics and reporting
- Quick DWH deployment.
- No downtimes because of workload variations due to instant scalability and flexibility.
- Reduced manual efforts for collecting, collating and building reports.
- Data analysis democratization.
Infrastructure cost reduction
No data warehouse overprovisioning with the pay-as-you-go pricing model.
Increased IT staff productivity
- Automation of infrastructure provisioning and administrative tasks (DWH setup and optimization, ongoing patching, maintenance activities, etc.).
- Improved DWH security.
Azure Synapse Analytics Pricing
Microsoft Azure data warehouse service charges for storage and compute separately, and its pricing depends on:
- The service level.
- The pricing option โ on-demand or reserved instance pricing.
- Region of where data warehouse units (DWUs) are physically located.
- Additional services (geo-redundant disaster recovery, threat detection, etc.).
Data storage: $23/TB/month ($0.04/TB/hour).
Data storage size includes data in your data warehouse and 7 days of incremental snapshot storage (repository with the files that capture incremental changes from the data stored in the DWH). Storage transactions are not billed.
Compute pricing: Provisioned Resources with Compute Optimized Gen2.
Note: The prices are relevant to the East US 2 data center region and may differ for other data centers.
Geo-redundant disaster recovery: disaster recovery storage billing starts at $0.057/GB/month.
Threat detection: $0.02/node/month for each protected SQL Database server.