19. View Materialized | DBT | Tamil
🎬 Welcome to our latest video!
🔗 Stay Connected:
LinkedIn: / nijamudhinsb12219296
Instagram: / nijamudhin_shagul
Email: [email protected]
📌 Don't forget to like, comment, and subscribe for more amazing content!
🌟 Notes:
1. View
Definition: A view is a saved query that is executed every time you query it. The data is not materialized (stored as a physical table), so the query is run dynamically whenever accessed.
Usage: Good for small datasets or when you want to always get the most uptodate data.
Performance: Slower on query execution since the data isn't prematerialized.
Example:
sql
{{ config(
materialized='view'
) }}