DataData LoaddbtFivetranGitgithubSnowflakeUncategorized Leveraging Snowflake, dbt, and GitHub for Streamlined Data Operations Given the importance of data nowdays, the ability to efficiently manage and process it can…Gergana Kaymakanovafebrero 23, 2024
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
Data LoaddbtgithubSnowflake Unleashing YouTube Insights: Powering HypeHouse’s Market Analysis In the fast-paced world of public relations, staying ahead of the curve is crucial. For…Sofia Pierinimayo 26, 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
Data LoadFrosty fridaySnowflake S6. What’s under the Snowflake(s)? Let us add something new in What's under the Snowflake(s)? In this post, we focus…Sofia Pierinimayo 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 Calisemayo 17, 2023
DataData LoadDatabasePipesSnowflakeSQL Snowflake Snowpipe In the previous chapters of this series, we have seen how to load through staging…Mario Caliseabril 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 Racioppiabril 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 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