context = {
    'destination_s3_key': 'soundscan_canada_track/data/soundscan_canada_track.txt.gz',
    'chunk_size': 100000,
    'table': 'track',
    'primary_key': 'id',
    'bucket': '{env}-db-data',
    'query': '''
        SELECT
            id,
            t.release_id,
            track_name,
            isrc,
            cd,
            track_id,
            ss_core_genres.genre as 'ss_core_genre_id',
            ss_genres.genre as 'ss_genres'
        FROM track t
        JOIN releases r ON t.release_id = r.release_id
        LEFT OUTER JOIN (
                SELECT
                    sgm.orchard_genre_id,
                    sgm.soundscan_genre_id,
                    sg.genre
                FROM soundscan_genre_mappings sgm
                INNER JOIN soundscan_genres sg
                    on sgm.soundscan_genre_id = sg.id
                WHERE sg.orchard_country_id = 2 AND genre_type = 'isrc' AND is_core = 'Y') ss_core_genres
            ON ss_core_genres.orchard_genre_id = r.genre_id
        LEFT OUTER JOIN (
                SELECT
                    sgm.orchard_genre_id,
                    sgm.soundscan_genre_id,sg.genre
                FROM soundscan_genre_mappings sgm
                INNER JOIN soundscan_genres sg
                    ON sgm.soundscan_genre_id = sg.id
                WHERE sg.orchard_country_id = 2 AND genre_type = 'isrc' and is_core = 'N') ss_genres
            ON ss_genres.orchard_genre_id = r.genre_id
        WHERE t.id BETWEEN {min_id} AND {max_id} '''
}