Azure SQL Data Warehouse Reviews & Product Details

Supports native SQL and cloud based no code approach to connect systems, create data warehouse and run analytics and reports Review collected by and hosted on G2.com.

Challenge implementing outside Azure in a multi cloud environment Review collected by and hosted on G2.com.

Operates as a PaaS with data warehouse features Review collected by and hosted on G2.com.

I dislike the cost of the system. Even when not using it they charge you Review collected by and hosted on G2.com.

I love the easy of data transfer between on premise and cloud capabilities. Review collected by and hosted on G2.com.

It can be costly if you don't watch your data processes tightly. Review collected by and hosted on G2.com.

Really it is very decent software for storing and retrieving data . it is very simple and responsive . it is same as sql server. it is robust and integrated software . it is very secure . l like pAAS and data mining. Review collected by and hosted on G2.com.

nothing ! really it is good

sometimes it lags when RAM is less. Review collected by and hosted on G2.com.

I work with implementations where Azure SQL DWH is used and the scalability it provides is best in the market Review collected by and hosted on G2.com.

Pricing . The pricing is high considering the open source competitors, Review collected by and hosted on G2.com.

it 's provide very high storage big data capacity we can store the data in petabytes that makes the most excite for everyone.it has massive parallel processing capability that execute thousands of queries parallely Review collected by and hosted on G2.com.

we can not execute the merge statement for doing SCD2 implementation and higher cost.if we have very less data then it we can not use because of high cost Review collected by and hosted on G2.com.

I like below features of azure sql data warehouse.

1)It support cloud computing. This makes it high availability.

2) It allows to create Virtual machine. It is easy and saves time.

3)Its GUI is simple. It is easy to use. Review collected by and hosted on G2.com.

1) It do not support some features of T-SQL like Error_LIne.

2)It do not provide support for entity framework.

3) The column store tables do not support secondary non-clustered indexes.

4)SQL azure database do not support sql jobs as provided by sql agent . Review collected by and hosted on G2.com.

Flexibility, and scalability also dont have to worry about maintaining it can also do schedule maintenance Review collected by and hosted on G2.com.

Security still seems like not up to the mark also security and role vould be more simlar to setup and it would have been great if i could setup a securoty based on region Review collected by and hosted on G2.com.

I like how all Azure technologies work side-by-side. Having Azure Storage and Azure Functions setup in our cloud enabled us to deliver solutions to our clients faster. With Azure SQL Data Warehouse, data management becomes a walk in a park in our team. It's easy to use. I feel safe when I'm experimenting with it for the first time. Support is awesome. Review collected by and hosted on G2.com.

There is a learning curve to managing data and security. Review collected by and hosted on G2.com.

1. This is very high in performance and lower in cost.

2. Provides secure cloud data warehouse.

3. This processes huge amount of data even parallel processing.

4. Native connectivity with data integration and visualization.

5. This uses intelligent caching to accelerate the data.

6. Significant query performance improvement.

7. Very good for OLAP environment.

8. Provides Platform as a service cloud based solution.

9. Built in automated database backups.

10. Combines relational data with cloud scale capabilities. Review collected by and hosted on G2.com.

Azure data warehouse Supports only 1024 active connections. Review collected by and hosted on G2.com.

Azure SQL has a high-performance, globally available, and lower-cost secure cloud data warehouse. It has independently scale compute and storage. It has Combine with leading data integration and BI solutions. Review collected by and hosted on G2.com.

it can improve the user interface and can adds some more shortcuts. some times its hard to find the right function key. Review collected by and hosted on G2.com.

Azure SQL Data Warehouse has been an amazing tool for our small company. We started collecting data just a few years ago and we were constantly running our of space. We migrated our data to Azure SQL Data warehouse and it had been our best move. We now have unlimited space and access to the data. We now are using the data on a daily basis to help make vital decisions. Review collected by and hosted on G2.com.

The set up process was a long and tedious process that was an exhausting experience. I would never want to leave because I would never want to go through the process again. Review collected by and hosted on G2.com.

SQL Data Warehouse provides a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Review collected by and hosted on G2.com.

The limitation on the number of connections Review collected by and hosted on G2.com.

Azure sql is better performance than on Prem version and this anlystics engine is improved lot..security is very much improved Review collected by and hosted on G2.com.

Their integrations are more with enterprises products and limitations with open source Review collected by and hosted on G2.com.

- Auto querying

- Good UI

- Fast and seamless Review collected by and hosted on G2.com.

- It crashes sometimes

- Can be a lighter version on the system Review collected by and hosted on G2.com.

It has friendly version like SQL server. Review collected by and hosted on G2.com.

The functions are bit complex to understand (at least for me). Review collected by and hosted on G2.com.

integrity, PaaS, Data mining, can use to build a data warehouse from scratch Review collected by and hosted on G2.com.

none, very well covered for data warehouse projects Review collected by and hosted on G2.com.