external.farcaster Table: fact_casts Type: View
What
Represents a cast authored by a user. For more info see Neynar or schemaColumns
| Column Name | Data Type | Description |
|---|---|---|
| TIMESTAMP | TIMESTAMP_NTZ | Message timestamp in UTC. |
| FID | NUMBER | FID of the user that signed the message. |
| HASH | BINARY | Message hash. |
| PARENT_HASH | BINARY | If this cast was a reply, the hash of the parent cast. null otherwise. |
| PARENT_FID | NUMBER | If this cast was a reply, the FID of the author of the parent cast. null otherwise. |
| PARENT_URL | TEXT | If this cast was a reply to a URL (e.g. an NFT, a web URL, etc.), the URL. null otherwise. |
| TEXT | TEXT | The raw text of the cast with mentions removed. |
| EMBEDS | TEXT | Array of URLs or cast IDs that were embedded with this cast. |
| MENTIONS | TEXT | Array of FIDs mentioned in the cast. |
| MENTIONS_POSITIONS | TEXT | UTF8 byte offsets of the mentioned FIDs in the cast. |
| ROOT_PARENT_HASH | BINARY | If this cast was a reply, the hash of the original cast in the reply chain. null otherwise. |
| ROOT_PARENT_URL | TEXT | If this cast was a reply, then the URL that the original cast in the reply chain was replying to. |
| 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!) |
| UPDATED_AT | TIMESTAMP_NTZ | When the row was last updated. |
| DELETED_AT | TIMESTAMP_NTZ | When the cast was considered deleted/revoked/pruned by the hub (e.g. in response to a CastRemove message, etc.) |