This article was originally written for SELECT and published here With any data warehousing solution, the ability to be alerted on key events is critical. In order to ensure business users are consuming valid, fresh data, operational guardrails should be in place related to job failures, business rule violations or…

Getting data into your platform is the first task you have to solve, no matter what your target technology is. In this blog post I would like to have a look on data ingestion into Snowflake Data Cloud. What are the necessary steps you always need to do, what are…

Last week of June 2023, there was snowing in Las Vegas. No, don’t worry this is not an intro into the new post-apocalyptic movie where this desert will be turned into the winter land. But there was held the Snowflake Summit — the data event of the year. Snowflake Summit…

In the previous blog post we have covered the basics about semi structured data and what kind of support Snowflake offers. We have also gone through various methods of ingesting semi structured data into Snowflake. Now we have the data in Snowflake, so what’s next? Let’s focus on working with…

Semi structured data has become another pillar of many data related deliveries. It provides more flexibility compared to structured data. Such flexibility is very often needed by many workloads, especially those ones which are built around various APIs, IoT sensors or web apps. JSON has become de facto „standard“ for…

Snowflake platform has been becoming more and more mature in many ways. There have been constantly added new features in different areas and workloads. One can start thinking about using the platform for use cases and tasks which would have been impossible couple years ago. As good example of such…

This article was originally written for SELECT and published here Snowflake Tasks is feature which helps you automate DB related operations and can be used for building complete and automated data pipelines when they are accomplished with another feature called Streams. Tasks can be used to trigger simple SQL command, same…

You might be starting your career as a Data Engineer, Data Scientist or Analyst. You might be already proficient in any traditional relational database and you would like to do a next step into modern, cloud based data platform as Snowflake today is. But you just don’t know how and…

Are you thinking about using Snowflake? Are you already running your first POC and you have worries about costs? Or you still ignore Snowflake because the cost model is „different“ compared to traditional solutions and it might look complicated or unclear? If you find yourself in any of those questions…