flow.rewards Table: dim_storefront_items Type: View
rewards__dim_storefront_items
Description
A comprehensive dimensional table containing storefront item metadata from the Minting Assets API. This table serves as the foundation for understanding the rewards storefront inventory, including NFTs, physical items, and digital assets available for purchase with reward points. It contains detailed information about item characteristics, pricing, availability, and redemption mechanics. The table supports the rewards ecosystem by providing item metadata for storefront operations and user experience.Key Use Cases
- Storefront Management: Understanding available items, pricing, and inventory levels in the rewards storefront
- Item Discovery: Finding items by category, price range, or availability status
- Redemption Analysis: Tracking item redemption patterns and user preferences
- Inventory Planning: Monitoring item quantities, minting status, and supply management
- User Experience: Providing item details, images, and metadata for storefront displays
- Reward Program Optimization: Analyzing which items drive user engagement and point spending
Important Relationships
- rewards__fact_points_balances: Links to user point balances for purchase eligibility analysis
- rewards__fact_points_transfers: Tracks point spending on storefront purchases
- rewards__fact_transaction_entries: Provides detailed transaction history for item purchases
- nft__dim_moment_metadata: May overlap with NFT items for additional metadata
- core__dim_contract_labels: For contract-based items, provides additional labeling
Commonly-used Fields
- ITEM_ID: Primary identifier for storefront items and purchase tracking
- NAME: Human-readable item name for display and reporting
- PRICE: Item cost in reward points or currency for purchase analysis
- QUANTITY: Available inventory for supply management and availability tracking
- MINT_STATUS: Current minting status for understanding item availability
- IS_LISTED: Flag indicating whether item is currently available for purchase
Columns
| Column Name | Data Type | Description |
|---|---|---|
| ITEM_ID | TEXT | |
| CREATED_AT | TIMESTAMP_NTZ | |
| ADDITIONAL_MEDIA | VARIANT | |
| ANIMATION_URL | TEXT | |
| ARTIST_INFO | VARIANT | |
| ASSET_NR | TEXT | |
| ATTRIBUTES | VARIANT | |
| AUCTION_ID | TEXT | |
| AUCTION_ITEMS | VARIANT | |
| BURN_TO_REDEEM_DETAILS | VARIANT | |
| BURN_TO_REDEEM_TYPE | TEXT | |
| BURNED_AT | TIMESTAMP_NTZ | |
| CONTRACT_ADDRESS | TEXT | |
| CURRENCY_ADDRESS | TEXT | |
| CURRENCY_DECIMALS | NUMBER | |
| DELETED_AT | TIMESTAMP_NTZ | |
| DESCRIPTION | TEXT | |
| DOES_REQUIRE_W9 | BOOLEAN | |
| ENABLE_BURN_TO_REDEEM | BOOLEAN | |
| IMAGE_URL | TEXT | |
| IS_LISTED | BOOLEAN | |
| IS_PHYGITAL_ITEM | BOOLEAN | |
| IS_PRICE_IN_USD | BOOLEAN | |
| IS_REDEEMABLE_SEPARATE_FROM_PURCHASE | BOOLEAN | |
| LISTING_ENDS_AT | TIMESTAMP_NTZ | |
| LISTING_STARTS_AT | TIMESTAMP_NTZ | |
| LISTING_TYPE | TEXT | |
| LOYALTY_CURRENCY | TEXT | |
| LOYALTY_CURRENCY_ID | TEXT | |
| METADATA_URI | TEXT | |
| MINT_STATUS | TEXT | |
| MINTING_CONTRACT | TEXT | |
| MINTING_CONTRACT_ASSET_MINT_STATUS | TEXT | |
| MINTING_CONTRACT_ID | TEXT | |
| NAME | TEXT | |
| NETWORK | TEXT | |
| ORGANIZATION_ID | TEXT | |
| PER_USER_MINT_LIMIT | NUMBER | |
| PER_USER_MINT_MIN_LIMIT | NUMBER | |
| PRE_REVEAL_MEDIA | VARIANT | |
| PRICE | NUMBER | |
| QUANTITY | NUMBER | |
| QUANTITY_MINTED | NUMBER | |
| REDEEMABLE_UNTIL | TIMESTAMP_NTZ | |
| REVEALED_AT | TIMESTAMP_NTZ | |
| SHIPPING_PRICE | NUMBER | |
| SHIPPING_WITHIN | TEXT | |
| STATUS_TRACKER | TEXT | |
| TOKEN_ID | TEXT | |
| TOKEN_TYPE | TEXT | |
| UPDATED_AT | TIMESTAMP_NTZ | |
| WEBSITE_ID | TEXT | |
| RESPONSE_JSON | VARIANT | |
| DIM_STOREFRONT_ITEMS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | |
| REQUEST_TIMESTAMP | TIMESTAMP_LTZ |