"""Select all rows in the bulk upload views by orchard label id."""
SELECT_BULK_UPLOAD_TABLE_BY_ORCHLABELID = """
    SELECT * FROM {snowflake_database}.{snowflake_schema}.{table_name}
    WHERE ORCHLABELID = {label_id}
    ORDER BY
        {ingestion_key_field},
        PRODUCT_CODE,
        ORCHARD_ARTIST,
        RELEASE_ARTISTS_PRIMARY_ARTIST,
        VOLUME,
        TRACK_NO
;
"""