Uncategorized How to write cleaner SQL queries In the world of database management, crafting efficient and readable SQL queries is an essential…Dominiqueenero 19, 2024
Uncategorized What makes Snowflake SQL outstanding from other DBMS SQL, or Structured Query Language, is a cornerstone of data management, widely used for interacting…Feruz Kholovenero 19, 2024
dbtJinjaSQLUncategorized Macros in dbt Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’…Luca Balduzzidiciembre 1, 2023
Data LoadJSONSnowflakeSQLUnstructured Data Killing JSON: Using Flatten to Load JSON Data Welcome back to Killing JSON, the series in which I channel my frustration with loading…Edoardo Draettanoviembre 17, 2023
JSONSnowflakeUnstructured Data Killing JSON: The Flatten Function Welcome to Killing JSON, a series in which I channel my frustration with loading data…Edoardo Draettanoviembre 10, 2023
DatabaseSnowdaySnowflake Snowflake Hybrid Tables Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…Luca Balduzzinoviembre 10, 2023
DataData LoadData VisualizationSnowflakeSQL Column Level Security Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized…Mario Calisemayo 22, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake’s INFER SCHEMA In this blog, we are going to discuss how Snowflake allows to easily interpret semi-structured data…Mario Calisemayo 17, 2023
Uncategorized The New Tab Feature on Snowflake The latest Snowflake release enables the use of more than one worksheet in separate tabs.…Can Hobekmayo 1, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario Caliseabril 25, 2023