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

What

This table contains farcaster users profile data and their connected addresses. For more info see Neynar or schema

Columns

Column NameData TypeDescription
FIDNUMBERFID the username belongs to.
FNAMETEXTUsername, e.g. dwr if an fname, or dwr.eth if an ENS name.
DISPLAY_NAMETEXTDisplay name for user.
AVATAR_URLTEXTLink to profile picture.
BIOTEXTProfile bio.
VERIFIED_ADDRESSESTEXTEVM wallet addresses associated with profile.
UPDATED_ATTIMESTAMP_NTZWhen the row was last updated.