"""Snowflake queries module."""
GET_PARENT_REP_OWNER_MAPPING = """
SELECT rep_owner_parent_cd, rep_owner_parent_nm
FROM SONY_INTERNAL.DEV.REP_OWNER_HIERARCHY
WHERE rep_owner_cd = %(rep_owner_key)s
    AND LENGTH(TRIM(rep_owner_parent_cd)) = 4
    AND LOWER(rep_owner_parent_nm) != 'unknown';
"""

GET_COUNTRY_ID_BY_PARENT_REPERTOIRE_OWNER_NAME = """
SELECT c2.id as id
FROM GRPS_APP_REPORTING_NOCONF.GRPS_DRAS002.TRAS024 company
JOIN GRPS_APP_REPORTING_NOCONF.GRPS_DRAS002.tras017
    ON company.country_key = TRAS017.country_key
    AND company.client_key = TRAS017.client_key
LEFT JOIN ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.country c2
    ON tras017.ISO_3166_A3_COUNTRY_CODE = c2.ISO3166A3
WHERE company.company_name = %(parent_repertoire_owner_name)s
"""