| POINT_ID | TEXT | Unique identifier for the points transaction (batch_id for legacy, entry_id for snag) |
| SOURCE | TEXT | Data source indicator: ‘legacy’ for Flow Points API or ‘snag’ for Snag Loyalty API |
| CREATED_AT | TIMESTAMP_NTZ | The date of the transfer |
| BATCH_INDEX | NUMBER | Index of the batch (legacy) or transaction entry (snag) |
| TRANSFER_INDEX | NUMBER | Legacy only: Index of the individual transfer within a batch. NULL for snag data. |
| FROM_ADDRESS | TEXT | EVM address of the user involved in the transaction |
| TO_ADDRESS | TEXT | Legacy only: EVM address of the recipient. NULL for snag data. |
| BOXES | NUMBER | Legacy only: Number of boxes transferred. NULL for snag data. |
| KEYS | NUMBER | Legacy only: Number of keys transferred. NULL for snag data. |
| POINTS | NUMBER | Number of points involved in the transaction |
| DIRECTION | TEXT | Snag only: Transaction direction - ‘credit’ for points earned or ‘debit’ for points spent. NULL for legacy data. |
| AMOUNT_START | NUMBER | Snag only: Loyalty account balance before the transaction. NULL for legacy data. |
| AMOUNT_END | NUMBER | Snag only: Loyalty account balance after the transaction. NULL for legacy data. |
| ACCOUNT_ID | TEXT | Snag only: Loyalty account identifier. NULL for legacy data. |
| USER_ID | TEXT | Snag only: User identifier associated with the loyalty account. NULL for legacy data. |
| USER_WALLET_ADDRESS | TEXT | EVM wallet address of the user (maps from from_address for legacy, native field for snag) |
| TRANSACTION_ID | TEXT | Snag only: Parent loyalty transaction identifier. NULL for legacy data. |
| DATA | OBJECT | Snag only: Full raw JSON response from the API. NULL for legacy data. |
| PARTITION_KEY | NUMBER | Snag only: Partition key for efficient querying. NULL for legacy data. |
| INDEX | NUMBER | Snag only: Index of the transaction entry within the partition. NULL for legacy data. |
| _INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Snag only: Timestamp when the record was inserted into the warehouse. NULL for legacy data. |
| FACT_POINTS_TRANSFERS_ID | TEXT | Surrogate primary key for the table |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when the record was first inserted into this table |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | UTC timestamp when this record was last modified |
| _INVOCATION_ID | TEXT | |
