Skip to main content
The polygon.agents.erc8004_events table contains all decoded ERC-8004 protocol events on Polygon. Each row is a single event — registrations, metadata updates, feedback submissions, revocations, and responses — with event-specific fields in the extra_fields VARIANT column. For full extra_fields reference and example queries, see the crosschain ERC-8004 events docs.

Table Details

PropertyValue
Table Namepolygon.agents.erc8004_events
Table StatusProduction-Ready
Unique Keytransaction_hash, log_index
Clustering Key(s)to_date(block_timestamp), event_name

Table Columns

Column NameData TypeDescription
event_nameVARCHAREvent type: Registered, URIUpdated, MetadataSet, NewFeedback, FeedbackRevoked, ResponseAppended
agent_idVARCHARNumeric agent NFT ID.
chainVARCHARNetwork name.
registry_typeVARCHARRegistry type: identity or reputation.
registry_addressVARCHARRegistry contract address.
registry_nameVARCHARRegistry name: IdentityRegistry or ReputationRegistry.
is_officialBOOLEANWhether the event is from an official ERC-8004 registry.
extra_fieldsVARIANTEvent-specific decoded parameters as JSON.
block_timestampTIMESTAMP_NTZ(9)The timestamp when the event occurred.
transaction_hashVARCHARThe transaction hash containing this event.
transaction_from_addressVARCHARThe address of the transaction signer.
transaction_to_addressVARCHARThe address of the transaction recipient.
block_numberNUMBER(38,0)The block number containing this event.
block_hashVARCHARThe hash of the block containing this event.
log_indexNUMBER(38,0)The position of the event log within the transaction.
unique_idVARCHARUnique identifier for the event.
_created_atTIMESTAMP_NTZ(9)The timestamp when the record was created.
_updated_atTIMESTAMP_NTZ(9)The timestamp when the record was last updated.

Sample Query

SELECT
    DATE_TRUNC('day', block_timestamp)::DATE AS dt,
    event_name,
    COUNT(*) AS events
FROM polygon.agents.erc8004_events
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY ALL
ORDER BY dt, events DESC;