Blog

by Pedro Meléndez, on Oct 6, 2022 3:30:00 AM

Since the dawn of exception handling, developers have been raising and catching exceptions in their code. These exceptions can serve a variety of purposes (such as registering why an execution …

Read Story
Topics:Snowflake

by Mauricio Rojas, on Oct 5, 2022 9:17:00 AM

I was looking at a project Mobilize.Net is moving from Spark to Snowpark, and this question popped up: Is there a way to use my .egg files in Snowpark? Technically, …

Read Story
Topics:Pythonsnowparkdeploymentegg

by Mauricio Rojas, on Oct 4, 2022 7:28:00 AM

Have you heard the news? There is a great new platform for Data Science and it is called Snowpark. But like many others, you might feel a little lost about …

Read Story
Topics:JavaScriptSnowflakePythonsnowparkscalaSnowpark Accelerated

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 Story
Topics:SnowflakeSQLinternationaldatefunction

by 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 Story
Topics:Snowflakesnowparkdata-governance

by 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 Story
Topics:SnowflakesnowparkSparkSnowpark AcceleratedApache SparkpysparkAirflow

by 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 Story
Topics:SnowflakePythonblackdiamond studio

by 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 Story
Topics:Snowflakesql conversioncode migration

by 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 Story
Topics:Snowflakescalaudf

by 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 Story
Topics:Assembly languageCOBOL

Subscribe to GAP Migrations Blog

More...
Free Assessment Tool