Code Generator

-- Generated by BlueCloud ConsultantOS
-- Model: stg_customers
-- Source: raw.customers

{{ config(
    materialized='view',
    tags=['staging', 'daily']
) }}

WITH source AS (
    SELECT * FROM {{ source('raw', 'customers') }}
),

renamed AS (
    SELECT
        -- Primary Key
        customer_id::VARCHAR(64) AS customer_id,
        
        -- Attributes
        TRIM(first_name)::VARCHAR(100) AS first_name,
        TRIM(last_name)::VARCHAR(100) AS last_name,
        LOWER(TRIM(email))::VARCHAR(255) AS email,
        
        -- Timestamps
        created_at::TIMESTAMP_NTZ AS created_at,
        updated_at::TIMESTAMP_NTZ AS updated_at,
        
        -- Metadata
        _loaded_at::TIMESTAMP_NTZ AS _loaded_at
    FROM source
)

SELECT * FROM renamed