external.snapshot Table: fact_proposals Type: View
What
A fact view that contains all proposals on Snapshot and related information.Columns
| Column Name | Data Type | Description |
|---|---|---|
| CREATED_AT | TIMESTAMP_NTZ | The time at which the proposal was generated. |
| PROPOSAL_TITLE | TEXT | The title or name of the proposal. |
| PROPOSAL_AUTHOR | TEXT | The address of the wallet that wrote the proposal. |
| PROPOSAL_TEXT | TEXT | The body of the proposal. |
| CHOICES | ARRAY | An array containing the voting options on the proposal. |
| 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. |
| IPFS | TEXT | The corresponding IPFS hash. |
| 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. |
| 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. |
| NETWORK_ID | TEXT | The default network or blockchain unique identifier used for the space. |
| PROPOSAL_ID | TEXT | A unique identifier for the proposal being voted on. |