"""Release-level summary report for a given ingestion session id."""
RELEASE_LEVEL_SUMMARY_BY_LABEL = """
    COPY INTO '@{source_snowflake_database}.{source_snowflake_schema}.{s3_stage_name}/{file_name}'
    FROM
        (
        SELECT
            id,
            SESSION_ID,
            REQUEST_NUM,
            TIME_RECEIVED,
            ACTION_TYPE,
            ORCHARD_VENDOR_ID,
            RELEASE_ID,
            PRODUCT_CODE,
            project_id,
            project_code
        FROM {log_snowflake_database}.{log_snowflake_schema}.{release_log_table} irl
        WHERE SESSION_ID = '{session_id}'
        AND ORCHARD_VENDOR_ID = {label_id}
        ORDER BY TIME_RECEIVED DESC
    )
    OVERWRITE = TRUE
    HEADER = TRUE
    SINGLE = TRUE
;
"""
# flake8: noqa