DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario CaliseAprile 25, 2023
DataSnowflakeSQL Optimizing SQL Queries in Snowflake In this blog, we'll discuss practical tips and tricks to optimize SQL queries in Snowflake…Sebastian WiesnerAprile 20, 2023
SQL Snowflake SQL Injection SQL Injection has the potential to ruin your database. If you have heard of the…Kris WinnubstAprile 17, 2023
SQL Challenge: Integrals in SQL? Last week I brought you a challenge on how to make derivatives in SQL. Evidently,…Eloi SanchezAprile 14, 2023
SQL SQL Case Statements We have already seen how nesting aggregated functions and SQL join types work in the…Dimitris LampriadisAprile 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 RacioppiAprile 7, 2023
SQL Challenge: Derivatives in SQL? Today I bring you a challenge! Just a fun little exercise to train your SQL…Eloi SanchezAprile 7, 2023
SQL Intro to SQL Joins: Understanding Join Types SQL Joins are a fundamental concept in SQL programming, used to combine data from two…Dimitris LampriadisMarzo 23, 2023
DataData GenerationData LoadMock DataSQL Mockaroo: fake realistic data In writing previous blogs, I found myself having to search for old tables in which…Niccolo RacioppiMarzo 23, 2023
Data LoadDatabaseSnowflakeSQL Snowflake File Formats In the previous chapters of this series, we have seen how to load through staging…Mario CaliseMarzo 23, 2023