20. Table 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:
2. Table
Definition: A table materialization creates a physical table in the database by executing the query once and saving the result. The table is only updated when dbt is rerun.
Usage: Suitable for large datasets or transformations that are not timesensitive.
Performance: Faster to query because the data is already materialized.
Example:
sql
{{ config(
materialized='table'
) }}