Heap vs. Snowflake

Scenarios when Heap was well suited: It is when a user claims that he encountered a bug without giving us the details of the error message. Scenarios where it is less appropriate: Its when we try to capture user interaction in our mobile app

Incentivized

I am over our HR data, and we use Workday for our HR management system. I have a script in place that runs reports on Workday and saves the results as CSVs. I can then use stages in Snowflake to insert these CSVs into Snowflake, then I can insert or truncate and replace these staged tables into a final schema. Then once these are in a schema I can reference them and build out my data models. In addition to ingesting CSVs, Snowflake has the ability to write a CSV file to our Amazon S3 bucket. Ingesting these CSVs, transforming the data, then delivering it to a destination would've involved so much more coding than my current process if we were on any other platform.

Incentivized

• Realtime interactions which are captured automatically is a unique feature which no other product offers.
• Low code implementation is a big plus for marketing teams, as there is less dependency on engineering
• Detailed customer behaviours can be studied with captured replay sessions
• Due to all the above points - it helped to improve customer experience

Incentivized

• Snowflake scales appropriately allowing you to manage expense for peak and off peak times for pulling and data retrieval and data centric processing jobs
• Snowflake offers a marketplace solution that allows you to sell and subscribe to different data sources
• Snowflake manages concurrency better in our trials than other premium competitors
• Snowflake has little to no setup and ramp up time
• Snowflake offers online training for various employee types

Incentivized

• I think Heap can improve its onboarding; I would love to see some info that is helpful for someone who isn't in Heap every single day.
• Sharing dashboards can be tricky, it feels like a huge learning curve that I already have forgotten how to do.

Incentivized

• This tool is very much technical and proper knowledge is required, so mostly you have to hire an IT team.
• I wish if various videos could be available for basic quires like its initiation, then I think it would act as a guideline and would help the beginners a lot.

Incentivized

It's a great platform. I'm glad that one of our product managers introduced it because it has allowed us to create all kinds of new functionality. We're not only able to create a better product experience from our communications because of Heap, but we're also able to generate all kinds of helpful analysis.

Incentivized

SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to

Incentivized

On a scale from 1-10, I find Heap to be incredibly user-friendly and easy to use. I enjoyed the training videos available and was quickly able to pick up how to create events and reports to track user interactions on our product. I would recommend Heap for its usability first and foremost.

Incentivized

The interface is similar to other SQL query systems I've used and is fairly easy to use. My only complaint is the syntax issues. Another thing is that the error messages are not always the easiest thing to understand, especially when you incorporate temp tables. Some of that is to be expected with any new database.

Incentivized

I've never run into any issues with Heap's availability, Heap is always there when I need it. I haven't run into any issues like application errors or unplanned outages during my 2+ years of using Heap. Each and every time I log in to Heap I have a completely functional experience

Incentivized

Heap doesn't affect page load times considerably nor has a large impact [on] our overall score, as far as page loading times inside of the tool its pretty reliable to retrieve data as much as "instant" that it can be the delay seems to be on data getting tracked into the servers to be read but it's not significant.

Incentivized

Heap support has allowed us to troubleshoot and test a lot of different items. Their support team is always helpful and friendly, even when we come to them with the most complicated questions. I think this greatly improves the value proposition of the product because their support team is knowledgable and friendly.

Incentivized

We have had terrific experiences with Snowflake support. They have drilled into queries and given us tremendous detail and helpful answers. In one case they even figured out how a particular product was interacting with Snowflake, via its queries, and gave us detail to go back to that product's vendor because the Snowflake support team identified a fault in its operation. We got it solved without lots of back-and-forth or finger-pointing because the Snowflake team gave such detailed information.

Incentivized

The implementation was smooth and easy. The Heap team helped us with implementation and it went great! Within a few weeks, we were fully up and running and utilizing the platform to its full capability. This is an additional thing that has made this platform so great and we couldn't recommend it enough.

Incentivized

Heap offers a ton of functionality on a single platform.It also has an smart data science layer to offers suggestions for next steps in the analysis, allowing us to explore alternative paths we may not think to take. The low-code option for updating data is appealing, and there is a lot of automation with minimal engineering effort.

Incentivized

I have had the experience of using one more database management system at my previous workplace. What Snowflake provides is better user-friendly consoles, suggestions while writing a query, ease of access to connect to various BI platforms to analyze, [and a] more robust system to store a large amount of data. All these functionalities give the better edge to Snowflake.

Incentivized

The most challenging part of using Heap in a growing organization is the naming and structure in which reports and dashboards are organized. I work within the marketing department and our Heap leader internally works within the IT/Product department, which makes it challenging because we often don't speak the same language, so the learning curve has been steep without any specific use-case examples to leverage online.

Incentivized

• It has helped us make decisions on what products to scope for our MVP based on the usage data.
• It's allowed us to measure success with our beta product.
• It's helped us view our conversion rates in an easy and usable manner.

Incentivized

• Positive impact: we use Snowflake to track our subscription and payment charges, which we use for internal and investor reporting
• Positive impact: 3 times faster query speed compared to Treasure Data means that answers to stakeholders can be delivered quicker by analysts
• Positive impact: recommender systems now source their data from Snowflake rather than Spark clusters, improving development speed, and no longer require maintainence of Spark clusters.

Incentivized