Population User Deposits
This table records deposit activity for users over time, including user details and transaction information.
Business Rules
- The table is incrementally updated using an insert-overwrite strategy.
- It tracks deposits between their creation date and expiration date.
- User age is calculated dynamically based on the transaction date.
Table description
| name | data_type | description |
|---|---|---|
| deposit_active_date | DATE | Active date of a deposit. |
| user_id | STRING | Unique identifier for a user. |
| user_department_code | STRING | Department code associated with the user's registered address. |
| user_region_name | STRING | Region name of the user's registered address. |
| user_birth_date | DATE | Birth date of the user. |
| deposit_id | STRING | Unique identifier for the deposit. |
| deposit_amount | FLOAT | The total amount of the deposit. |
| deposit_creation_date | DATE | The date when the deposit was created. |
| deposit_type | STRING | Type of the deposit, can be GRANT_18, GRANT_15_17, GRANT_17_18. |
| user_age | INTEGER | Current age of the user. |