Snowflake REGEX in Snowflake It is possible to match strings with regular expression (also called REGEX) in Snowflake. I…nimbus-6481b4a401ca0april 28, 2023
SnowflakeUncategorized How to connect VS Code to Snowflake During the last years, I have been using Visual Studio Code for everything. Therefore, now…nimbus-6481b4a401ca0april 26, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario Caliseapril 25, 2023
DataSnowflakeSQL Optimizing SQL Queries in Snowflake In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…nimbus-6481b4a401ca0april 20, 2023
Data LoadSnowflake From JSON to XML: A Deep Dive into Snowflakes File Types Snowflake is a cloud-based data warehousing solution that has become increasingly popular in recent years…nimbus-6481b4a401ca0april 14, 2023
SQL Challenge: Integrals in SQL? Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…nimbus-6481b4a401ca0april 14, 2023
SQL SQL Case Statements We have already seen how nesting aggregated functions and SQL join types work in the…nimbus-6481b4a401ca0april 8, 2023
DataData LoadDatabaseSnowflakeSQLUncategorized Two ways to populate a table with stage data MATCH_BY_COLUMN_NAME vs Variant data type I found myself having to insert files from my device…Niccolo Racioppiapril 7, 2023
AcademySnowflake Snowflake SnowPro: How to probably Ace it As an Analytics Engineer trainee, I recently took the Snowflake Snowpro Core Certification exam. Before…nimbus-6481b4a401ca0april 7, 2023
AcademyDataDatabaseSnowflake How to become a SnowPro I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…Niccolo Racioppiapril 7, 2023