DiamondBurn Portal Burn #2
    Updated 2023-11-07
    -- forked from Burn Portal Burn #1 @ https://flipsidecrypto.xyz/edit/queries/3c582ee1-abe8-46c5-8703-ab1ce390269a

    WITH
    updated_metadata_0 AS (
    SELECT
    nft_id as "ID",
    --moment_stats_full['ID'] AS "unique_id",
    CONCAT(MOMENT_STATS_FULL:metadata:playerFullName::STRING) AS "Player",
    CONCAT(MOMENT_STATS_FULL:metadata:teamName::STRING) 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.core.dim_allday_metadata
    UNION
    SELECT
    nft_id AS "ID",
    CONCAT(
    metadata:playerFirstName::STRING,
    ' ',
    metadata:playerLastName::STRING
    ) AS "Player",
    CONCAT(metadata:teamName::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.core.dim_moment_metadata
    ),
    updated_metadata AS (
    SELECT
    *
    Run a query to Download Data