external.snapshot Table: ez_snapshot Type: View
What
A convenience view that contains all votes on Snapshot and information about the voting space and proposal.Columns
| Column Name | Data Type | Description |
|---|---|---|
| ID | TEXT | A unique identifier assigned to a vote. |
| PROPOSAL_ID | TEXT | A unique identifier for the proposal being voted on. |
| VOTER | TEXT | The wallet address of the user that voted on a proposal. |
| 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. |
| VOTE_TIMESTAMP | TIMESTAMP_NTZ | The time at which the vote was cast. |
| CHOICES | ARRAY | An array containing the voting options on the proposal. |
| PROPOSAL_AUTHOR | TEXT | The address of the wallet that wrote the proposal. |
| PROPOSAL_TITLE | TEXT | The title or name of the proposal. |
| PROPOSAL_TEXT | TEXT | The body of the proposal. |
| SPACE_ID | TEXT | A way to identify which group, or space, on Snapshot a proposal belongs to. |
| NETWORK | TEXT | The default network or blockchain used for the space. |
| DELAY | NUMBER | The default number of hours of voting delay for the space. The voting delay is the time between proposal submission and the opening of voting. |
| QUORUM | NUMBER | The minimum amount of voting power for a proposal to pass. |
| VOTING_PERIOD | NUMBER | The default time in hours within a space for a proposal to be open for voting. |
| VOTING_TYPE | TEXT | The type of voting system used for this space. If this column is not null, the same voting system will be used for all proposals in this space. |
| PROPOSAL_START_TIME | TIMESTAMP_NTZ | The time at which voting on the proposal begins. |
| PROPOSAL_END_TIME | TIMESTAMP_NTZ | The time at which voting on the proposal ends. |