external-models/models/farcaster/gold/farcaster__dim_fids.yml
2024-07-24 11:01:11 -06:00

18 lines
854 B
YAML

version: 2
models:
- name: farcaster__dim_fids
description: Stores all registered FIDs on the Farcaster network. For more info see [Neynar](https://docs.neynar.com/docs/how-to-query-neynar-sql-playground-for-farcaster-data) or [schema](https://github.com/farcasterxyz/hub-monorepo/tree/51c57245df8ec1c68d616dd3ab8ae5b80edf68fd/apps/replicator)
columns:
- name: FID
description: FID of the user (primary key)
- name: CREATED_AT
description: When the row was first created in this DB (not the same as registration date!)
- name: REGISTERED_AT
description: Timestamp of the block in which the user was registered.
- name: UPDATED_AT
description: When the row was last updated.
tests:
- not_null
- name: CUSTODY_ADDRESS
description: Address that owns the FID.