Register Referrer - Allium Documentation Hub

The hyperliquid.raw.register_referrer table records when users register a new referral code on Hyperliquid. It contains the referral code registered (e.g. PURS) and the address of the registering user.

Table Details

Property	Value
Table Name	`hyperliquid.raw.register_referrer`
Table Status	Production-Ready
Unique Key	`block_timestamp`, `hash`
Search Optimization	`user`, `referral_code`

Table Columns

Column Name	Data Type	Description
referral_code	VARCHAR(134217728)	The referral code registered (e.g. PURS).
user	VARCHAR(134217728)	The address of the user registering the code.
error	VARCHAR(134217728)	Error message if the registration failed.
block_timestamp	TIMESTAMP_NTZ(9)	The timestamp of the block.
block_height	NUMBER(38,0)	The height of the block.
hash	VARCHAR(134217728)	Transaction hash.
_ingested_at	TIMESTAMP_NTZ(9)	Timestamp when the record was ingested.
_created_at	TIMESTAMP_NTZ(9)	Row creation timestamp.
_updated_at	TIMESTAMP_NTZ(9)	Row last update timestamp.