DataPython What are Moving Averages? If you have been in the data environment for some time you will have probably…nimbus-6481b4a401ca0abril 21, 2023
DataSnowflakeSQL Optimizing SQL Queries in Snowflake In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…nimbus-6481b4a401ca0abril 20, 2023
SQL Snowflake SQL Injection SQL Injection has the potential to ruin your database. If you have heard of the…Aleksandra Molendaabril 17, 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-6481b4a401ca0abril 14, 2023
SQL Challenge: Integrals in SQL? Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…nimbus-6481b4a401ca0abril 14, 2023
SQL SQL Case Statements We have already seen how nesting aggregated functions and SQL join types work in the…nimbus-6481b4a401ca0abril 8, 2023
Snowflake Automate external stage loading This week I set-up automate external stage loading. I did this for our first mock…nimbus-6481b4a401ca0abril 7, 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 Racioppiabril 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-6481b4a401ca0abril 7, 2023
AcademyDataDatabaseSnowflake How to become a SnowPro I took the SnowPro Core Certification exam. SnowPro Core certification badge I will make some…Niccolo Racioppiabril 7, 2023