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.
Deploying a DWH in a few clicks.
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.
Ensuring high data availability and fault tolerance of the DWH.
Ingesting big data, querying data lake with the supported languages.
Enabling BI and ML to discover powerful insights.
Querying streaming data to conduct real-time analytics.
Querying data in Cosmos DB with Azure Synapse Link to run near real-time analytics over operational data.
Integrating third-party solutions, including Tableau, SAS, Qlik, etc.
Near-infinite scaling of storage and compute resources.
Coordinated query processing by multiple computer processors.
Reserving resources for specific workloads by creating workload groups.
Speeding up queries by delivering precomputed/cached results.
Increasing query performance and improving data compression by up to 10 times.
Security and compliance
Data encrypted in transit and at rest.
Limited access of unauthorized users to sensitive data.
Column-level security and native row-level security.
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.).
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.
- 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.
No data warehouse overprovisioning with the pay-as-you-go pricing model.
- 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.