17. Things You Should Know About dbt Models | 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:
Things You Should Know About dbt Models
1. Model File Location:
Models are SQL files located in the models/ directory of your dbt project. You can organize them into subfolders like models/staging/ or models/marts/.
2. Model Naming Conventions:
Use clear and descriptive names for your models.
Common practice: prefix your staging models with stg_ to indicate that they are part of the staging layer (e.g., stg_hosts.sql, stg_listings.sql).
3. Semicolon(;):
Always avoid ending SQL statements in dbt models with a semicolon. This ensures dbt can compile and execute your models correctly.
4. SQL & Snowflake:
dbt models are entirely based on SQL. I have the complete SQL course video. If you're interested in learning SQL, please reach me at this email ID: [email protected].