Sun.Jan 22, 2023

article thumbnail

Snowflake: Regular View vs Materialized View

Cloudyard

Read Time: 2 Minute, 32 Second During this post we will discuss about the difference between Regular View and Materialized View. We know in Regular view if query is run on the View, the reference is against the underlying base table. The output of the View query does not store on the Disk and every time it refers the original base tables. We can also called these View as Virtual table which is an output of Query statements.

article thumbnail

Safely Test Your Applications And Analytics With Production Quality Data Using Tonic AI

Data Engineering Podcast

Summary The most interesting and challenging bugs always happen in production, but recreating them is a constant challenge due to differences in the data that you are working with. Building your own scripts to replicate data from production is time consuming and error-prone. Tonic is a platform designed to solve the problem of having reliable, production-like data available for developing and testing your software, analytics, and machine learning projects.

article thumbnail

Data Engineering Weekly #115

Data Engineering Weekly

Data Engineering Weekly Is Brought to You by RudderStack RudderStack provides data pipelines that make it easy to collect data from every application, website, and SaaS platform, then activate it in your warehouse and business tools. Sign up free to test out the tool today. Editor’s Note: Update on our blog series One of the promises I made toward the end of 2022 is to publish more of my thoughts and industry observation of data engineering trends.