"""Action-level summary of a given ingestion operation."""
INGESTION_ACTION_BREAKDOWN_BY_LABEL = """
COPY INTO '@{source_snowflake_database}.{source_snowflake_schema}.{s3_stage_name}/{file_name}'
    FROM (
        SELECT
            session_id,
            ACTION_TYPE,
            COUNT(*) AS release_count
        FROM {log_snowflake_database}.{log_snowflake_schema}.{release_log_table} irl
        WHERE SESSION_ID = '{session_id}'
        AND ORCHARD_VENDOR_ID = {label_id}
        GROUP BY 1, 2
        ORDER BY MIN(TIME_RECEIVED) DESC, 1 DESC ,2 DESC
    )
    OVERWRITE = TRUE
    HEADER = TRUE
    SINGLE = TRUE
;
"""
# flake8: noqa