external.blast Table: fact_leaderboard Type: View
What
This table contains daily snapshots of the top 500 leaderboards for Blast Points and Gold.Columns
| Column Name | Data Type | Description |
|---|---|---|
| DATE | DATE | The date of the leaderboard snapshot. |
| LEADERBOARD_TYPE | TEXT | The criterion by which the leaderboard is ranked, either points or gold. |
| RANK | NUMBER | The rank (1-500) associated with the user. |
| NAME | TEXT | The name of the user associated with that rank. |
| POINTS_AMOUNT | NUMBER | The amount of points accrued by the user. |
| GOLD_AMOUNT | FLOAT | The amount of gold accrued by the user. |
| INVITED_BY | TEXT | The user who referred the associated user. |