Microsoft Azure Synapse Analytics Questions
Netanya Carmi
Content Manager
PeerSpot (formerly IT Central Station)
Netanya Carmi
Content Manager
PeerSpot (formerly IT Central Station)
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
Hi community,
I am a solution architect for a global tech company with over ten years of experience.
What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
One dedicated layer for staging, one for type 1 persistent tables, and a dedicated schema/layer for... Read More »
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Hi Everyone,
What do you like most about Microsoft Azure SQL Data Warehouse?
Thanks for sharing your thoughts with the community!
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Hi,
We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Please share with the community what you think needs improvement with Microsoft Azure SQL Data Warehouse.
What are its weaknesses? What would you like to see changed in a future version?
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
Thank you!
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
If you were talking to someone whose organization is considering Microsoft Azure SQL Data Warehouse, what would you say?
How would you rate it and why? Any other tips or advice?
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 05 2022
Hi Everyone,
What do you like most about Microsoft Azure Synapse Analytics?
Thanks for sharing your thoughts with the community!
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 05 2022
Hi,
We all know it's really hard to get good pricing and cost information.
Please share what you can so you can help your peers.
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
Jul 05 2022
Please share with the community what you think needs improvement with Microsoft Azure Synapse Analytics.
What are its weaknesses? What would you like to see changed in a future version?
Miriam Tover
Senior Delivery Ops Manager
PeerSpot (formerly IT Central Station)
Jul 13 2022
How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
Thank you!
Julia Frohwein
Content and Social Media Manager
PeerSpot (formerly IT Central Station)
Jul 05 2022
If you were talking to someone whose organization is considering Microsoft Azure Synapse Analytics, what would you say?
How would you rate it and why? Any other tips or advice?
Cloud Data Warehouse Questions
Evgeny Belenky
PeerSpot (formerly IT Central Station)
What are the relations between them? What are their use cases?
Ariful Mondal
Consulting Practice Partner - Data, Analytics & AI at FH
Hi,
It seems that Snowflake is becoming very popular nowadays. I have done some training and live sessions by Snowflake.
I would like to hear your opinion about the main key parameters we should look for when choosing Snowflake over other cloud-based data lakes, such as costs, ease of use, ma... Read More »
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
I have seen bitmap index as the preferred choice in a data warehousing environment. I wanted to know reasons for that. As per my own experience, one reason is bitmap indexes are compressed and hence confined in less index space. When we have large number of FK indexes then this index space matter... Read More »
RajneeshShukla
Solution Architect at a tech vendor with 10,001+ employees
I am a solution architect for a global tech vendor.
I am looking for any general guidelines to allocate tablespace quota to different layers/schemas in the ETL flow of a data warehouse (% of total space in each layer).
I have these 4 layers:
Staging -truncate and load data from source files
... Read More »
User
Which ETL or Data Integration tool goes the best with Amazon Redshift? Ex: Matillion, Informatica Cloud, Alooma, SnapLogic, SSIS
Ariel Lindenfeld
Sr. Director of Community
PeerSpot (formerly IT Central Station)
Let the community know what you think. Share your opinions now!
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Updated: July 2022
Product Categories
Cloud Data WarehousePopular Comparisons
Amazon Redshift
Azure Data Factory
Apache Hadoop
Oracle Autonomous Data Warehouse
AWS Lake Formation
Oracle Exadata
Microsoft Parallel Data Warehouse
Microsoft Analytics Platform System
IBM Netezza Performance Server
Teradata Cloud Data Warehouse
SAP Business Warehouse
Buyer's Guide
Download our free Microsoft Azure Synapse Analytics Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
- Which is better - Azure Synapse Analytics or Snowflake?
- How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
- Which ETL or Data Integration tool goes the best with Amazon Redshift?
- What are the benefits of having separate layers or a dedicated schema for each layer in ETL?
- What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
- What are the main differences between Data Lake and Data Warehouse?
- Are there any general guidelines to allocate table space quota to different layers in ETL?
- bitmap index as preferred choice in data warehousing environment
