Open Issues Need Help
View All on GitHubAI Summary: Create a dbt model to deduplicate and standardize customer data, adding an audit column and tests. The model should handle deduplication based on customer ID, keeping the latest record, and standardize email addresses to lowercase and names to proper case. The model should also include tests for `not_null` and `unique` constraints on the `customer_id`.
This is a repository for dbt projects
AI Summary: Create a dbt model to deduplicate and standardize customer data, adding an audit column and tests. The model should handle deduplication based on customer ID, keeping the latest record, and standardize email addresses to lowercase and names to proper case. The model should also include tests for `not_null` and `unique` constraints on the customer ID.
This is a repository for dbt projects