We just raised a $30M Series A: Read our story

Snowflake Questions

Rob Kellaway
Head of Data Delivery at Hastings Insurance Services Limited
Dec 02 2021
Hi peers, I work at an Insurance company with 5000+ employees and I'm interested in the collective view here.  Does anyone have a view on how Matillion ETL functionality compares to ADF for Snowflake integration, when ADF and Snowflake are hosted on Azure? Note: Azure hosting is important, as… (more)

Hi peers,

I work at an Insurance company with 5000+ employees and I'm interested in the collective view here. 

Does anyone have a view on how Matillion ETL functionality compares to ADF for Snowflake integration, when ADF and Snowflake are hosted on Azure?

Note: Azure hosting is important, as this appears to offer better integration options than when using ADF on AWS (for example).

Thanks for the help!

(less)
NitinKumar
Engineering Manager at Sigmoid
Sep 07 2021

Hello, 

I am using Snowflake for JSON data and we have almost 700 million JSON rows. 

Is it possible to achieve a sub-second performance in Snowflake? I am OK to cluster and flatten the JSON data into structured tables if necessary. 

Thank you.

Netanya Carmi
Content Manager
IT Central Station
Sep 03 2021

And why?

NitinKumarIf you are dealing with semi-structured data like json Snowflake has great… more »
Ariful Mondal
Consulting Practice Partner - Data, Analytics & Artificial Intelligence at Wipro Ltd
Sep 03 2021
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,… (more)

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, maintenance, etc? 

And what would be success criteria? 

(less)
Steve SarsfieldI wrote a white paper on this that you can download here:https://bit.ly/3bRTCqp… more »
MarkSmithWe did a PoC with Snowflake.  scale up and down works as advertised.  Be careful… more »
Jay AllenSnowflake is a columnar stored database. It is not a “data lake.”
Julia Frohwein
Content and Social Media Manager
IT Central Station
Nov 07 2021

If you were talking to someone whose organization is considering Snowflake, what would you say?

How would you rate it and why? Any other tips or advice?

Data SleekSnowflake is probably the best data warehouse solution on the market. AWS is… more »
Jesus CarrollSnowFlake is useful to merge all kinds of data, no bother if you have… more »
SreenivasanRamanujamAdvice 1 : If the organization has more than 60 to 70% of data science or ML use… more »
Julia Frohwein
Content and Social Media Manager
IT Central Station
Nov 07 2021

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
IT Central Station
Nov 07 2021

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
IT Central Station
Nov 07 2021

Hi Everyone,

What do you like most about Snowflake?

Thanks for sharing your thoughts with the community!

SreenivasanRamanujamData sharing is a good feature. It is a majorly used feature. The elastic… more »
NitinKumarMany features: 1) Separate warehouse and the control user gets on it. 2)… more »
Julia Frohwein
Content and Social Media Manager
IT Central Station
Nov 07 2021

Please share with the community what you think needs improvement with Snowflake.

What are its weaknesses? What would you like to see changed in a future version?

Data Warehouse Questions
Evgeny Belenky
IT Central Station
Nov 19 2021

What are the relations between them? What are their use cases?

Richard WinterMany of the comparisons of data lake and data warehouse that you see (such as… more »
Wallace HughI assume the "Data Warehouse" term here is in the traditional/conventional… more »
Djalma Gomes, Pmp, MbaThose are just terms used by marketing. 30 years ago, BI required a… more »
Bruce Tan
Director at SLS Bearings (S) Pte. Ltd.
Aug 05 2021
I am a director at a business enhancement solutions company that provides mechanical systems and distributes high-quality bearings and related products. I am planning for b2b e-commerce. I have operations in Singapore, Malaysia, Indonesia, China, and Mongolia. Each country uses a different ERP… (more)

I am a director at a business enhancement solutions company that provides mechanical systems and distributes high-quality bearings and related products.

I am planning for b2b e-commerce. I have operations in Singapore, Malaysia, Indonesia, China, and Mongolia. Each country uses a different ERP. Singapore HQ uses JDE (one world), that was last implemented 20 years ago.

I intend to consolidate the data to one 'location' for the integration of data into e-commerce or e-marketplace. Is a data warehouse the best way to go? 

Thanks! I appreciate your help. 

(less)
David RossiFor most clients, we suggest a data pipeline that includes an inexpensive… more »
David RossiThe idea of an EDW or enterprise data warehouse is the right path. That said… more »
Richard WinterThe answer is yes.    If this platform is supporting e-commerce, distribution… more »