Category: snowflake
Insert a dataframe into Snowflake using Python – Source code included
In this article we will see how to insert a DataFrame into Snowflake using Python. You can use the pandas…
String Manipulation Techniques in Snowflake : REGEXP, CONTAINS, REPLACE, Splitting and Concatenating
String manipulation is fundamental when dealing with textual data in any database system. Snowflake offers an array of string functions…
Exploring the VARIANT data type in Snowflake
Snowflake, a leading cloud data platform, has a unique feature that distinguishes it from traditional relational databases. It offers a…
Arrays in Snowflake: Storage, Queries, and the FLATTEN Function
In Snowflake, an array is a one-dimensional, zero-based collection of elements that can be of any data type, including other…
Navigating NULLs in Snowflake: Array handling techniques – Identify NULL values – Replace or manage NULL in Snowflake
Null values in databases represent missing or unknown data. Proper handling of these null values ensures data integrity, hygiene, and…
Comparing two tables in Snowflake – An easy to implement document
When working with Snowflake, there might be scenarios where you need to compare two tables to determine differences. These differences…
Snowflake : Returning the identifier of the current transaction for a session in Snowflake
What is CURRENT_TRANSACTION in Snowflake? CURRENT_TRANSACTION is a function in Snowflake that returns the identifier of the current transaction for…
Translating timezone handling from Redshift to Snowflake
When migrating or synchronizing data workflows between different cloud data platforms, subtle differences in SQL function implementations can become a…
Step-by-step guide on executing PySpark code from Snowflake Snowpark to read a DataFrame:
Here are the steps on how to execute PySpark code from Snowflake Snowpark to read a DataFrame: 1. Open Snowsight…
Snowflake : Identifying Non-Matching Timestamps and Customer IDs between Two Tables in Snowflake: An SQL Approach
If you want to find the records where both the ts (timestamp) and customerid columns in tableA match those in…
