Skip to main content
Schema: external.farcaster Table: fact_storage Type: View

What

Stores how many units of storage each FID has purchased, and when it expires. For more info see Neynar or schema

Columns

Column NameData TypeDescription
IDNUMBERGeneric identifier specific to this DB (a.k.a. surrogate key)
FIDNUMBERFID that owns the storage.
UNITSNUMBERNumber of storage units allocated.
EXPIRYTIMESTAMP_NTZWhen this storage allocation will expire.
TIMESTAMPTIMESTAMP_NTZMessage timestamp in UTC.
CREATED_ATTIMESTAMP_NTZWhen the row was first created in this DB
UPDATED_ATTIMESTAMP_NTZWhen the row was last updated.
DELETED_ATTIMESTAMP_NTZDELETED_AT column