What Is the Difference Between the account_balance And balance Columns?

Question

What is the difference between the account_balance and balance columns in the CUSTOMER table?

Environment

Connector: Stripe

Answer

The account_balance and balance columns are the same. In 2019. Stripe renamed the account_balance field to balance. See Stripe's API upgrades documentation for more information.

However, some of our dbt transformation models, like the stripe__customer_overview model, reference the account_balance column. To maintain compatibility with these models, we populate the account_balance column in your destination even though it's a duplicate of the balance column.