external.farcaster Table: fact_blocks Type: View
What
Represents users that have blocked or been blocked. For more info see Neynar or schemaColumns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCKER_FID | NUMBER | The FID of the user that blocked the other user. |
| BLOCKED_FID | NUMBER | The FID of the user that has been blocked. |
| ID | NUMBER | Generic identifier specific to this DB (a.k.a. surrogate key) |
| CREATED_AT | TIMESTAMP_NTZ | When the row was first created in this DB (not the same as the message timestamp!) |
| DELETED_AT | TIMESTAMP_NTZ | When the cast was considered deleted/revoked/pruned by the hub (e.g. in response to a CastRemove message, etc.) |