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

What

Stores all registered FIDs on the Farcaster network. For more info see Neynar or schema

Columns

Column NameData TypeDescription
CUSTODY_ADDRESSBINARYAddress that owns the FID.
FIDNUMBERFID of the user (primary key)
CREATED_ATTIMESTAMP_NTZWhen the row was first created in this DB (not the same as registration date!)
UPDATED_ATTIMESTAMP_NTZWhen the row was last updated.
REGISTERED_ATTIMESTAMP_NTZTimestamp of the block in which the user was registered.