Blog

by Marco Carrillo, on Oct 20, 2022 2:35:07 PM

“BlackDiamond Studio (a.k.a. BDS) is the cross-language workbench for any code you have aimed at your Snowflake account.” (Mobilize.Net Corporation [that's us! we said that!], 2022). As indicated in the …

Read Story
Topics:Snowflake

by Jorge Arturo Vasquez Rojas, on Oct 14, 2022 5:35:19 AM

Got BTEQ? And by that I mean, do you have some BTEQ (Basic Teradata Query) scripts that you want to convert easily to Snowflake? Not sure what output language you …

Read Story
Topics:SnowflakeTeradataSnowflake Scriptingbteq

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:SnowflakePythonsnowparkscalajavaSnowpark 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 conversionSQL Servermigration

Subscribe to Mobilize.Net Blog

More...

More...
Free Assessment Tool