Community

Create missing records with Snowflake SQL

Using the GENERATOR and LAST_VALUE functions This question comes up time and time again: How do I create missing records with ...

Generating Sample Data Using the faker Library with Snowpark

Instead of hard-coding the table name in the save_as_table() property, we can provide it as a parameter named FAKE_TABLE_NAME to the ...

SnowPro™ Core Certification Companion

Hey there, fellow data enthusiasts! If you're gearing up to take the SnowPro Core Certification exam, we've got some fantastic news for you. Our ...

Moving On-Prem Data Warehouses to Snowflake: Mastering the Art of Data Migration Phase 

We started our analytical journey more than 15 years ago, providing end-to-end solutions to our clients – from data strategy, business analytics, ...

Hitchhiker’s guide to the Snowflake Data Cloud

There are many compelling reasons why companies around the world are moving to Snowflake, but many are dreading of the big M - Migration. It can ...

Optimize Performance on Snowflake

While Snowflake does all query tuning and optimization behind the scenes without DBA support, there are nevertheless situations, especially when we ...

Migrating Oracle Functions, Procedures and Packages to Snowflake

Oracle to Snowflake Migration Series, part 5 Snowflake supports functions and procedures, but not packages. Many Oracle implementations use ...

Insurance Cloud Migration – The solution to the industry’s challenges

Leverage the power of data and eliminate your challenges Every year the insurance industry continues to expand all over the world. Here are some ...

Convert Oracle code to Snowflake

Oracle to Snowflake Migration Series, part 4 Convert Oracle code to Snowflake: By converting code, we are referring to Oracle PL/SQL procedures, ...