node_count_checks = {
    'MUSIC_GRAPH_ONLY': """WITH mg AS (
    SELECT ID
    FROM FACTS.{schema}.{mg_table}
    WHERE NOT IS_DELETED
),
ng AS (
    SELECT ID
    FROM FACTS.{schema}.{ng_table}
    WHERE NOT IS_DELETED
), 
diff AS (
    SELECT ID
    FROM mg
    MINUS
    SELECT ID
    FROM ng
)
SELECT COUNT(*) AS C
FROM diff
;""",
    'NR_GRAPH_ONLY': """WITH mg AS (
    SELECT ID
    FROM FACTS.{schema}.{mg_table}
    WHERE NOT IS_DELETED
),
ng AS (
    SELECT ID
    FROM FACTS.{schema}.{ng_table}
    WHERE NOT IS_DELETED
), 
diff AS (
    SELECT ID
    FROM ng
    MINUS
    SELECT ID
    FROM mg
)
SELECT COUNT(*) AS C
FROM diff
;""",
}

node_metadata_checks = {
    'DIFFERENT_METADATA': """SELECT COUNT(*) AS C
FROM FACTS.{schema}.{mg_table} mg
JOIN FACTS.{schema}.{ng_table} ng ON mg.ID = ng.ID
WHERE
    {where}
;"""
}

relation_count_checks = {
    'MUSIC_GRAPH_ONLY': """WITH mg AS (
    SELECT {start_column}, {end_column}
    FROM FACTS.{schema}.{mg_table}
),
ng AS (
    SELECT {start_column}, {end_column}
    FROM FACTS.{schema}.{ng_table}
), 
diff AS (
    SELECT {start_column}, {end_column}
    FROM mg
    MINUS
    SELECT {start_column}, {end_column}
    FROM ng
)
SELECT COUNT(*) AS C
FROM diff
;""",
    'NR_GRAPH_ONLY': """WITH mg AS (
    SELECT {start_column}, {end_column}
    FROM FACTS.{schema}.{mg_table}
),
ng AS (
    SELECT {start_column}, {end_column}
    FROM FACTS.{schema}.{ng_table}
), 
diff AS (
    SELECT {start_column}, {end_column}
    FROM ng
    MINUS
    SELECT {start_column}, {end_column}
    FROM mg
)
SELECT COUNT(*) AS C
FROM diff
;""",
}

relation_metadata_checks = {
    'DIFFERENT_METADATA': """SELECT COUNT(*) AS C
FROM FACTS.{schema}.{mg_table} mg
JOIN FACTS.{schema}.{ng_table} ng ON {join}
WHERE
    {where}
;"""
}