by Mauricio Rojas, on Sep 29, 2022 2:10:21 PM
Recently I received a request inspired by this StackOverflow question: To convert a date-string that contains the name of the month in a data-field I could use select to_date('01October2022', 'DDMMMMYYYY') …
Read Storyby Mauricio Rojas, on Sep 28, 2022 11:41:16 AM
Data governance is a strategy for handling data within an organization. It is a set of rules, policies, standards, practices, etc. whose main purpose is to ensure data has high …
Read Storyby Mauricio Rojas, on Sep 27, 2022 4:42:12 PM
What is AirFlow? Apache Airflow is an open-source workflow management platform for data engineering pipelines. Airflow is written in Python, and workflows are created via Python scripts. Airflow is designed …
Read Storyby Rodrigo Meléndez, on Sep 13, 2022 3:00:00 AM
Last week, we published a blog post on how to write a Scala UDF for Snowflake. This week? We've taken our talents to Python. We'll take the same function (IS_PALINDROME) …
Read Storyby Andrés Campos, on Sep 8, 2022 3:00:00 AM
Whenever you migrate SQL Server IF statements that are found within scalar functions using BlackDiamond Studio, you will soon find out that they require special handling to make them work …
Read Storyby Luis Alonso Montero, on Sep 6, 2022 9:04:12 AM
Write a Snowflake UDF in Scala with BlackDiamond Studio Snowflake provides a set of built-in functions which can be used to manipulate your data. (In Snowflake's documentation, you can find …
Read Storyby John Browne, on Jul 6, 2022 5:23:37 PM
In the last 12 hours two blasts from the past showed up in my feed. First, this excellent github readme which is a super-simple explainer of what exactly assembly language …
Read Storyby Andrés Campos, on Jun 30, 2022 1:48:40 PM
Code migration always presents unique and interest challenges. As the longtime leaders in migration tooling, we’ve seen a lot of those challenges. When we find one that’s interesting, we like …
Read Storyby Brandon Carver, on Jun 30, 2022 3:00:00 AM
Decisions. Whether it's paper or plastic, coffee or tea, gas or electric... there's always another decision waiting around the corner. And if you landed on this page, your next decision …
Read Storyby Mauricio Rojas, on Jun 6, 2022 1:58:29 PM
Snowpipe is a powerful tool for automating your data loading process. However, it's not always easy to setup all the transformations you may need in the COPY statement. You might …
Read Story
