nethermindnarutPractice 4 - Cosmos dim_tokens vs dim_labels
    Updated 2023-04-28
    WITH dimtokens AS
    (
    SELECT *
    FROM cosmos.core.dim_tokens
    ),
    dimlabels AS
    (
    SELECT *
    FROM cosmos.core.dim_labels
    WHERE label_type = 'token'
    )
    SELECT *
    FROM dimtokens dt
    FULL OUTER JOIN dimlabels dl
    ON dt.address = dl.address
    WHERE dt.address IS NULL OR dl.address IS NULL;
    Run a query to Download Data