You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In the investigation of refunds data, I discovered that several payments staging tables include cases where a column contains an empty string (""). These columns are very problematic because they are effectively null but they will not be returned by queries on column IS NULL. We have a dbt macro trim_make_empty_string_null designed to convert such cases (and also cases where a string is only whitespace) to nulls. We should apply this macro on all string columns in the Payments data:
In the investigation of refunds data, I discovered that several payments staging tables include cases where a column contains an empty string (""). These columns are very problematic because they are effectively null but they will not be returned by queries on
column IS NULL
. We have a dbt macro trim_make_empty_string_null designed to convert such cases (and also cases where a string is only whitespace) to nulls. We should apply this macro on all string columns in the Payments data:Elavon transactions(now handled in Payments: refactor elavon transactions and add handling for empty strings #2956The text was updated successfully, but these errors were encountered: