DiamondJalen Hurts Crafting Challange (Debut Burns)
    Updated 2023-12-04
    WITH
    updated_metadata_0 AS (
    SELECT
    nft_id as "ID",
    --moment_stats_full['ID'] AS "unique_id",
    CASE
    WHEN player = 'N/A' THEN team
    ELSE player
    END AS "Player",
    team as "Team",
    series as "Series",
    set_name AS "Set Name",
    moment_stats_full['flowID'] AS "marketplace_id",
    moment_tier AS "Tier",
    SERIAL_NUMBER AS "Serial #"
    FROM
    flow.nft.dim_allday_metadata
    UNION
    SELECT
    nft_id AS "ID",
    CONCAT(
    metadata:playerFirstName::STRING,
    ' ',
    metadata:playerLastName::STRING
    ) AS "Player",
    CONCAT(
    metadata:team::STRING
    ) AS "Team",
    series_name as "Series",
    set_name AS "Set Name",
    NULL AS "marketplace_id",
    tier AS "Tier",
    SERIAL_NUMBER AS "Serial #"
    from
    flow.nft.dim_moment_metadata
    ),
    Run a query to Download Data