Uncategorized How to write cleaner SQL queries In the world of database management, crafting efficient and readable SQL queries is an essential…DominiqueGennaio 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 KholovGennaio 19, 2024
dbtJinjaSQLUncategorized Macros in dbt Macros in dbt are reusable pieces of code that ensure that the code is ‘DRY’…Luca BalduzziDicembre 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 DraettaNovembre 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 DraettaNovembre 10, 2023
DatabaseSnowdaySnowflake Snowflake Hybrid Tables Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…Luca BalduzziNovembre 10, 2023
DataData LoadData VisualizationSnowflakeSQL Column Level Security Snowflake, as a modern cloud database, has the functionality to mask sensitive data for unauthorized…Mario CaliseMaggio 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 CaliseMaggio 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 HobekMaggio 1, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario CaliseAprile 25, 2023