"""Create the track log."""
CREATE_TRACK_RESPONSE_LOG = """
    CREATE TABLE IF NOT EXISTS
        {snowflake_database}.{snowflake_schema}.ingestion_track_log_{environment}
        (
            id INT AUTOINCREMENT,
            session_id VARCHAR(255),
            request_num INT,
            time_received TIMESTAMP_LTZ,
            orchard_vendor_id INT,
            product_code VARCHAR(255),
            project_code VARCHAR(255),
            track_num INT,
            vol_num INT,
            errors VARCHAR
        );
"""
# flake8: noqa