SQL Intro to SQL Joins: Understanding Join Types SQL Joins are a fundamental concept in SQL programming, used to combine data from two…nimbus-6481b4a401ca0marzo 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
Frosty fridaySnowflakeSQL S3. What’s under the Snowflake(s)? What's under the Snowflake(s)? - Week 23 - Basic Are you curious about SnowSQL? Then,…Sofia Pierinimarzo 23, 2023
Frosty fridaySnowflakeSQL S1. What’s under the Snowflake(s)? S1. What's under the Snowflake(s)? Week 38 - Basic Let's start the first episode of…Sofia Pierinimarzo 22, 2023
DatabasePythonSnowflakeSQL S0. What’s under the Snowflake(s)? Database, table, and virtual warehouse are basic Snowflake objects required for most Snowflake activities. Setting…Sofia Pierinimarzo 21, 2023
Frosty fridayPythonSnowflakeSQL What’s under the Snowflake(s)? Have you ever wondered what is under the snow? What are the snowflakes hiding? Have…Sofia Pierinimarzo 21, 2023
PythonSQL Wildcard searches in SQL and Python Last week I found myself wondering about wildcard searches in SQL and Python. And to…nimbus-6481b4a401ca0marzo 20, 2023
SQL Nesting Aggregated functions This blogpost marks the beginning of a long and very exciting journey in the world…nimbus-6481b4a401ca0marzo 20, 2023
AcademyDatabaseSnowflakeSQL Zero-Copy Cloning: Snowflake’s unique feature When we talk about Business Intelligence we immediately think of the strategies connected to the…Mario Calisemarzo 17, 2023