external.snapshot Table: fact_votes Type: View
What
A fact view that contains all votes on Snapshot and related information.Columns
| Column Name | Data Type | Description |
|---|---|---|
| VOTE_TIMESTAMP | TIMESTAMP_NTZ | The time at which the vote was cast. |
| VOTER | TEXT | The wallet address of the user that voted on a proposal. |
| PROPOSAL_ID | TEXT | A unique identifier for the proposal being voted on. |
| VOTE_OPTION | ARRAY | How the user voted on the proposal. Corresponds to the choices array. |
| VOTING_POWER | NUMBER | The amount of voting power one holds is proportional to the amount of the token they hold. |
| IPFS | TEXT | The corresponding IPFS hash. |
| VOTE_ID | TEXT | A unique identifier assigned to a vote. |