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`.
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.