Azure Synapse Analytics – Your Fast-Read Cloud SQL Data Warehouse
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.
Data integration with ETL/ELT
Quick processing of data of different volumes and of different types.
Flexible querying with SQL of both relational and non-relational data.
Using T-SQL, Python, Scala, Spark SQL or .Net for both serverless and provisioned compute resources.
Automated restore points and backups
Integrations with Apache Spark
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
Massively parallel processing
Coordinated query processing by multiple computer processors.
Reserving resources for specific workloads by creating workload groups.
Speeding up queries by delivering precomputed/cached results.
Clustered columnstore indexes
Security and compliance
Always-on data encryption
Dynamic data masking
Limited access of unauthorized users to sensitive data.
Granular access controls
Column-level security and native row-level security.
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.
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.
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: $122.88/TB/month ($ 0.17/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.12/GB/month.
Threat detection: $0.02/node/month for each protected SQL Database server.