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
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
DataData GenerationData LoadMock DataSQL Mockaroo: fake realistic data In writing previous blogs, I found myself having to search for old tables in which…Niccolo RacioppiMarch 23, 2023
Data LoadDatabaseSnowflakeSQL Snowflake File Formats In the previous chapters of this series, we have seen how to load through staging…Mario CaliseMarch 23, 2023
Uncategorized Stored Procedures Stored Procedures allow us to write functions inside our SQL code. In Snowflake you can…Can HobekMarch 22, 2023
DataData GenerationDatabaseSnowflake Unload data from your Snowflake account We have previously seen how to load data from foreign sources to your Snowflake account…Mario CaliseMarch 22, 2023
Uncategorized User-Defined Functions User-Defined Functions allow us to write functions inside our SQL code. In Snowflake you can…Can HobekMarch 21, 2023
Data LoadDatabaseSnowflake Snowflake Stages: a brief explanation Data storage is a critical component of any database system. When dealing with large amounts…Mario CaliseMarch 21, 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 CaliseMarch 17, 2023
Snowflake Grant privileges in Snowflake Why can't we grant privileges to a Snowflake object AND its children? In the first…Can HobekMarch 17, 2023