by 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
Topics:data modernizationSnowflakesnowscriptsnowpipe

by Pedro Meléndez, on May 25, 2022, 8:35:20 AM

The ability to pivot has been key to moving couches and manipulating dataframes for more than 30 years. But not all pivots and unpivots are created equal. Let's take a …

Read Story
Topics:SnowflakeTeradata

by Mauricio Rojas, on Apr 5, 2022, 6:55:17 AM

This may be a small post, but hopefully, it will save you some time. Recently, I had the problem where I had a procedure in Snowflake that was using the …

Read Story
Topics:Snowflake

by Mauricio Rojas, on Mar 29, 2022, 11:01:54 AM

Snowflake is the Data Cloud, but does that mean that I can also use Snowflake as a Data Lake? Well, yes. Snowflake could be your Data Lake, your Data Warehouse, …

Read Story
Topics:data modernizationSnowflakedata lakenrtnear-real-time

by Brandon Carver, on Mar 17, 2022, 5:33:57 AM

It's Spring (or at least it will be soon), and while nature may take the Winter off from growing its product, GAPVelocity AI did not. As Snowflake continues to grow, …

Read Story
Topics:JavaScriptdata modernizationmigration servicesSnowflakesql conversioncloud-data-warehousedata

by Mauricio Rojas, on Feb 10, 2022, 7:15:20 AM

The Snowflake Data Platform is full of surprises. Since Snowflake got its start, you have had the ability to create stored procedures. However, this capability was limited to using JavaScript …

Read Story
Topics:data modernizationSnowflakesql conversionsnowscript

by Cheyenne Sokkappa, on Dec 7, 2021, 11:31:47 AM

Turns out it might be helpful to some folks to see a list of all the improvements that have been made to the VB6 AI Migrator (previously Visual Basic Upgrade …

Read Story
Topics:VB6 AI Migrator

by Mauricio Rojas, on Nov 4, 2021, 8:17:16 AM

Snowflake is a great and ease to use platform. I am constantly moving workloads from Teradata, SQL Server, and Oracle to this platform. However, I have encountered an interesting situation …

Read Story
Topics:Oracledata modernizationSnowflake

by Olman Quesada, on Oct 15, 2021, 2:30:25 PM

FarPoint Spread ActiveX grid control was a very popular component for VB6 applications. However, because it stores design information in a proprietary format, migrating can be difficult. The VB6 AI …

Read Story
Topics:.NETVB6 AI Migrator

by John Browne, on Sep 1, 2021, 8:17:24 AM

Possibly the single-most wildly anticipated and over-hyped IPO of 2020 was Snowflake (SNOW:NYSE), a hot provider of cloud data warehouse software. (Snowflake, in keeping with all hot young startups, likes …

Read Story
Topics:Snowflakecloud-data-warehouse

Subscribe to GAPVelocity AI Modernization Blog

Free Assessment Tool