L1 Mapping

The lighter_robinhood.raw.l1_mapping table contains lighter account-to-wallet address mapping.

Table Columns

Unique key: l1_address, account_id

Column Name	Data Type	Description
`l1_address`	`VARCHAR`	EVM wallet address associated with the account.
`account_id`	`NUMBER(38,0)`	Lighter internal account identifier.
`_created_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was first recorded.
`_updated_at`	`TIMESTAMP_NTZ(9)`	Timestamp when the row was last updated.

SELECT
    account_id,
    l1_address
FROM lighter_robinhood.raw.l1_mapping
LIMIT 100;

⌘I