
SnapLogic
Effective data integration tool
Snaplogic’s Versatile Snap Packs and Helpful SnapGPT
The new UI/UX has improved performance.
Also, Snaplogic support, on the rare occasions it is required, is quick and easy.
Amazing UI and Great Interactivity for Efficient ETL
Reliable Platform for Fast Multi-Source Data Ingestion
Fast, Scalable Integrations with SnapLogic’s Intuitive Drag-and-Drop Designer
Super fast integrations—saves tons of coding headache!
Fast and Flexible Integrations Powered by Pre-Built Snaps, Visual Workflows, and Great Support
Intuitive Design with Some Stability Challenges
SnapLogic Snaps Make No-Code Data Integration Simple and Powerful
Each child pipeline run truncates the Snowflake table before loading its file meaning only the last file's data survives, and all previously loaded files get wiped out!
Add a "Truncate Once" option in the Snowflake Bulk Load Snap that truncates only on the first execution and appends on subsequent runs within the same pipeline session.
Allow the Parent Pipeline to handle the truncation step before triggering child pipelines, so children only append data.
Add a Pipeline-level Truncate Lock that prevents multiple child pipelines from truncating the same table simultaneously
Visual pipelines have streamlined complex data transformations and simplified vendor file delivery
What is our primary use case?
My main use case for SnapLogic is that we primarily use it for data transformation, ETL pipelines, file generation, and sending extract files to our external vendors.
I can give you a specific example of how we use SnapLogic for one of those tasks. Every day we receive claim files from our primary vendor and we load those using SnapLogic and transform the data accordingly to match our database schema. After the files have been loaded, we send out many different extracts to different vendors depending on their needs, and all those extracts go through SnapLogic.
I have more to add about my main use case and how SnapLogic fits into my workflow. We also use SnapLogic scheduled tasks for many of our processes. Some of those are daily and some of those are monthly, but we enjoy using SnapLogic to schedule those tasks out accordingly. It has helped significantly with organizing those different scheduled tasks and keeping us on track with different deliverables for several vendors that we have.
How has it helped my organization?
Almost all of our data transformation process and file extract process goes through SnapLogic. We have a ton of our infrastructure set up in there and I would say it is extremely important for our processes. It would be very difficult to switch away from it because of how we have set up everything with their scheduled tasks and how we are all used to their infrastructure and their UI. We all really enjoy it. It is very simple to set up tasks for reading, transforming, and extracting data, formatting files, and sending things to Amazon S3 or other delivery locations. It has simplified things greatly, especially having the visual UI to see how the data is flowing through the pipeline. This makes things a lot easier compared to setting that up in code alone. My whole team and I really enjoy that visual aspect of the data transformation process.
SnapLogic has specifically helped my team save time and resources. As I mentioned, we have a lot of our infrastructure set up in there. I would say we probably have 150 pipelines. Setting all of those processes up in code alone would be quite an undertaking and I believe there would be significantly more infrastructure and maintenance set up around those pipelines if we were to do it in code alone. Having everything stored in SnapLogic and having the visual aspect of it really helps us keep things in a central location. We can all see how the data is flowing much more easily and it is really easy to make edits and drag and drop things. Out of those 150 to 200 processes, having all those in SnapLogic makes it a lot more organized and a lot easier for new people on the team to drop in and get the hang of things quickly.
What is most valuable?
One of my favorite features SnapLogic offers is how many pre-configured Snap Packs and Snaps are available for lots of third-party integrations. For example, we use a lot of AWS services and we have a lot of different database connections and APIs that we call. We use their wide selection of pre-configured Snaps to help us build out those much faster. That makes things a lot easier. Another one of my favorite features of SnapLogic is how easy it is to monitor pipeline executions. Their Monitor app is very useful to see things that are running, things that have failed in the past, and upcoming tasks. I use their monitor app quite a bit for pipeline debugging.
Out of the features I mentioned, I rely on their Snap Pack and their pre-configured Snaps a little more often day-to-day than the Monitor because we do not always have pipelines failing, but I am always working on building new pipelines or editing old ones with their Snap Packs. I know that they have many Snap Packs that we have not had a chance to use yet. For example, their up-and-coming AI ones. We have been chatting with their team about it, but we have not integrated them into our workflows very much yet. In addition, their Patterns feature is also important to me. We typically copy and paste old pipelines more often than using their pre-built patterns and I would appreciate spending more time looking at those to see how they could help us speed up our pipeline development.
I am impressed with how they are pushing forward with AI integration in their pipelines, particularly with their Snap GPT, which has become increasingly useful to us. Aside from that, their team regularly works with my team on calls to walk us through their new AI tools and see how we use them and how they can improve. I am very excited about many of their new AI features, and I am impressed with how they are being very communicative and pushing that forward with our help.
What needs improvement?
There are a few ways SnapLogic can be improved, as there are some UI quirks that I have personally noticed. For example, we use a lot of SQL queries in our Snaps. Sometimes they are very long and complex, and it is a little difficult to work with the SQL text files in those Snaps because they do not have a lot of text editing capabilities. They do not allow you to add new lines or line breaks of any kind, so often I end up using another text editor and pasting long text snippets of SQL queries into the Snap. That is a little frustrating. In addition, I would say they are going through, or they might be at the end of, a pretty significant UI overhaul of their designer app, and there are still some issues occasionally or buggy behavior when you are dragging segments of pipelines around. Sometimes they collide or they think they are colliding when they do not appear to be visually. Other than that, every once in a while I have issues with their JavaScript expression library and what is allowed to be used there and how it evaluates or shows me previews of the results. There are occasional bugs there. Overall though, I have been impressed at how responsive their team is to our issues and they are really willing to hear our feedback and look for ways to improve.
For how long have I used the solution?
I have been using SnapLogic for my entire time at my current company, so a little over one year.
What do I think about the stability of the solution?
SnapLogic is stable overall, as I know that they went through several back-end revamps a couple months ago. Probably in April, they were having some significant latency and downtime issues over the course of a few weeks. That is the only time that I have seen issues with stability on their side.
What do I think about the scalability of the solution?
We have seen Snaplogic's platform handle significant load spikes without issue, however every once in a while we have a high enough load to take down our Cloudplex. When that happens it is usually able to spin up a new instance automatically very soon after and we don't see much of a drop in service.
How are customer service and support?
The customer support from SnapLogic is definitely very impressive. I believe that we may be one of their bigger customers or one that they work with the most personally. We talk to their team quite often. They have been very responsive to feedback. They seek out our experiences with their new features and they walk us through their up-and-coming products, which is very rewarding. So far I have been very impressed with how responsive they are and how well they take feedback and they value my team's experience. I would rate the customer support from SnapLogic on a scale of 1 to 10 as nine out of 10.
Which solution did I use previously and why did I switch?
Not applicable, my company chose Snaplogic before I was hired here.
How was the initial setup?
Not applicable, my company chose Snaplogic before I was hired here.
What about the implementation team?
Not applicable, my company chose Snaplogic before I was hired here.
What was our ROI?
I don't have access to much of the financial side of my company's decision on Snaplogic, but I know that we have occasionally looked at switching to another service but decided to stick with Snaplogic due to how useful it is for its value.
What's my experience with pricing, setup cost, and licensing?
Not applicable, my company chose Snaplogic before I was hired here.
Which other solutions did I evaluate?
As far as I know, we have always been on SnapLogic since my company was founded. However, I know that my team also evaluated options in Azure and AWS. For example, AWS Glue was something that we looked at, and I believe they chose SnapLogic due to the extensiveness of features, the good support structure from their team, and pricing considerations were involved there too.
What other advice do I have?
I would advise others looking into using SnapLogic that if you are looking for something that gives you a visual aspect at the cost of some more options, or more manual options that you could probably tweak if you were to use code instead of a visual solution, SnapLogic is very good at simplifying things and making it very visually clear what is happening with the data. There is a bit of a cost when it comes to debugging because you have to go through their validation flow and it can be a little slower than it might be on the code side to validate and test things. Obviously, they have a UI that abstracts away a lot of the details that you might have if you were to do it purely in code. However, that does make things simpler and faster in my opinion to build. It is really easy to repeat patterns and share things that work across different pipelines that you may have. It has definitely helped my team move faster in making a lot of our data transformation and extract processes simpler, faster, and easy to replicate and repeat across working cases. SnapLogic has been great for us. If that is an issue that your team is seeing, then SnapLogic would be a great solution for you to help you simplify things and make things faster.
I do not have any additional thoughts about SnapLogic before we wrap up, except that it looks as though a response about the business relationship with a vendor may have been skipped. As far as I know, we are only a customer of SnapLogic. I do not know of any partnership other than that. I am happy to be using SnapLogic and I look forward to their upcoming features and I look forward to working with them more in the future. I give SnapLogic an overall rating of 8 out of 10.