14. Creating Stage 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:
------------------
2. Write SQL Logic:
Write the SQL transformation query that you want to run in this model. This query can reference other models, apply transformations, or create aggregations.
sql
STG_HOSTS:
SELECT
ID
, UPPER(NAME)AS NAME
, CASE
WHEN IS_SUPERHOST = 'f' THEN 'FALSE'
ELSE 'TRUE'
END AS IS_SUPERHOST
, CREATED_AT
, UPDATED_AT
FROM AIRBNB.RAW.RAW_HOSTS
STG_LISTINGS:
SELECT
ID AS LISTING_ID
, LISTING_URL
, INITCAP(NAME) AS NAME
, UPPER(ROOM_TYPE)
, MINIMUM_NIGHTS
, HOST_ID
, REPLACE(PRICE,'$')::INT AS PRICE
, CREATED_AT
, UPDATED_AT
FROM AIRBNB.RAW.RAW_LISTINGS
STG_REVIEWS:
SELECT
LISTING_ID
, DATE::DATE AS DATE
, UPPER(REVIEWER_NAME) AS REVIEWER_NAME
, INITCAP(COMMENTS) AS COMMENTS
, UPPER(SENTIMENT) AS SENTIMENT
FROM AIRBNB.RAW.RAW_REVIEWS