DatabaseSnowdaySnowflake Snowflake Hybrid Tables Hybrid Tables in Snowflake are a new type of table that can support transactional workloads.…Luca Balduzzinovember 10, 2023
DatabaseDatabase Creation Entity Relation Diagram Entity Relation Diagram is part of the data modelling process ant it's the representation of…Luca Balduzziseptember 22, 2023
DatabaseSnowflake Vector Databases from 1000 Meters In the ever-expanding realm of data, a significant portion remains unstructured, posing challenges for traditional…Sebastian Wiesnermei 19, 2023
AcademyDataDatabaseSnowflakeSQLUncategorized Conversion Functions- Part1 Conversion functions allow a data item of one datatype supported by Snowflake to be transformed…Niccolo Racioppimei 18, 2023
DataDatabaseSnowflakeSQLUncategorized INFORMATION SCHEMA The Information Schema is a tool full of potential that allows us to keep track…Niccolo Racioppimei 18, 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 Calisemei 17, 2023
DataDatabase The Hype About GPT as a Helper Tool in Software GPT, or Generative Pre-trained Transformer, is a deep learning model that can generate natural language…Sebastian Wiesnermei 12, 2023
Data LoadDatabase Data Integration Battle: Fivetran vs. Airbyte Data integration platforms like Fivetran and Airbyte are critical for businesses that rely on data…Sebastian Wiesnermei 12, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario Caliseapril 25, 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 Racioppiapril 7, 2023