Wallet Balances

New Table

This is a newly added table exposing wallet balance data in the Partner Data Warehouse.

Wallet balance records from the wallet service. Each balance is linked to a wallet via wallet_id. Only balances belonging to wallets within the partner's scope are included. Soft-deleted balance records are excluded.

SQL: wallet_balances

Schema

Column Name	Data Type	Description
Primary ID
id	INTEGER	Primary key, unique identifier for each wallet balance record
Other IDs
wallet_id	INTEGER	Foreign key to the wallet this balance belongs to
Timestamps
created_at	TIMESTAMP_NTZ	Timestamp when the balance record was created
updated_at	TIMESTAMP_NTZ	Timestamp when the balance record was last updated
negative_balance_at	TIMESTAMP_NTZ	Timestamp when the balance went negative, null if balance has never been negative
Attributes
credit	NUMBER	Credit amount on the wallet balance
balance	NUMBER	Current balance amount

Inclusion Criteria

Wallet balances are included if their wallet_id matches a wallet within the partner's scope (via inner join to the partner's wallets table).

Data flow

Upstream tables	Downstream tables
`wallets`	---