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;