flow.rewards Table: dim_storefront_items Type: View
What
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 | ITEM_ID column |
| CREATED_AT | TIMESTAMP_NTZ | CREATED_AT column |
| ADDITIONAL_MEDIA | VARIANT | ADDITIONAL_MEDIA column |
| ANIMATION_URL | TEXT | ANIMATION_URL column |
| ARTIST_INFO | VARIANT | ARTIST_INFO column |
| ASSET_NR | TEXT | ASSET_NR column |
| ATTRIBUTES | VARIANT | ATTRIBUTES column |
| AUCTION_ID | TEXT | AUCTION_ID column |
| AUCTION_ITEMS | VARIANT | AUCTION_ITEMS column |
| BURN_TO_REDEEM_DETAILS | VARIANT | BURN_TO_REDEEM_DETAILS column |
| BURN_TO_REDEEM_TYPE | TEXT | BURN_TO_REDEEM_TYPE column |
| BURNED_AT | TIMESTAMP_NTZ | BURNED_AT column |
| CONTRACT_ADDRESS | TEXT | CONTRACT_ADDRESS column |
| CURRENCY_ADDRESS | TEXT | CURRENCY_ADDRESS column |
| CURRENCY_DECIMALS | NUMBER | CURRENCY_DECIMALS column |
| DELETED_AT | TIMESTAMP_NTZ | DELETED_AT column |
| DESCRIPTION | TEXT | DESCRIPTION column |
| DOES_REQUIRE_W9 | BOOLEAN | DOES_REQUIRE_W9 column |
| ENABLE_BURN_TO_REDEEM | BOOLEAN | ENABLE_BURN_TO_REDEEM column |
| IMAGE_URL | TEXT | IMAGE_URL column |
| IS_LISTED | BOOLEAN | IS_LISTED column |
| IS_PHYGITAL_ITEM | BOOLEAN | IS_PHYGITAL_ITEM column |
| IS_PRICE_IN_USD | BOOLEAN | IS_PRICE_IN_USD column |
| IS_REDEEMABLE_SEPARATE_FROM_PURCHASE | BOOLEAN | IS_REDEEMABLE_SEPARATE_FROM_PURCHASE column |
| LISTING_ENDS_AT | TIMESTAMP_NTZ | LISTING_ENDS_AT column |
| LISTING_STARTS_AT | TIMESTAMP_NTZ | LISTING_STARTS_AT column |
| LISTING_TYPE | TEXT | LISTING_TYPE column |
| LOYALTY_CURRENCY | TEXT | LOYALTY_CURRENCY column |
| LOYALTY_CURRENCY_ID | TEXT | LOYALTY_CURRENCY_ID column |
| METADATA_URI | TEXT | METADATA_URI column |
| MINT_STATUS | TEXT | MINT_STATUS column |
| MINTING_CONTRACT | TEXT | MINTING_CONTRACT column |
| MINTING_CONTRACT_ASSET_MINT_STATUS | TEXT | MINTING_CONTRACT_ASSET_MINT_STATUS column |
| MINTING_CONTRACT_ID | TEXT | MINTING_CONTRACT_ID column |
| NAME | TEXT | NAME column |
| NETWORK | TEXT | NETWORK column |
| ORGANIZATION_ID | TEXT | ORGANIZATION_ID column |
| PER_USER_MINT_LIMIT | NUMBER | PER_USER_MINT_LIMIT column |
| PER_USER_MINT_MIN_LIMIT | NUMBER | PER_USER_MINT_MIN_LIMIT column |
| PRE_REVEAL_MEDIA | VARIANT | PRE_REVEAL_MEDIA column |
| PRICE | NUMBER | PRICE column |
| QUANTITY | NUMBER | QUANTITY column |
| QUANTITY_MINTED | NUMBER | QUANTITY_MINTED column |
| REDEEMABLE_UNTIL | TIMESTAMP_NTZ | REDEEMABLE_UNTIL column |
| REVEALED_AT | TIMESTAMP_NTZ | REVEALED_AT column |
| SHIPPING_PRICE | NUMBER | SHIPPING_PRICE column |
| SHIPPING_WITHIN | TEXT | SHIPPING_WITHIN column |
| STATUS_TRACKER | TEXT | STATUS_TRACKER column |
| TOKEN_ID | TEXT | TOKEN_ID column |
| TOKEN_TYPE | TEXT | TOKEN_TYPE column |
| UPDATED_AT | TIMESTAMP_NTZ | UPDATED_AT column |
| WEBSITE_ID | TEXT | WEBSITE_ID column |
| RESPONSE_JSON | VARIANT | RESPONSE_JSON column |
| DIM_STOREFRONT_ITEMS_ID | TEXT | DIM_STOREFRONT_ITEMS_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| REQUEST_TIMESTAMP | TIMESTAMP_LTZ | REQUEST_TIMESTAMP column |