"""Query to create a list of assets to ingest."""
CREATE_COVER_ASSET_INGESTION_TABLE = """
CREATE OR REPLACE TABLE {source_snowflake_database}.{source_snowflake_schema}.{target_table_name} as
SELECT
    distinct {foreign_key_field} AS FOREIGN_REL_ID,
    DIGITAL_UPC AS ORCH_UPC,
    CONCAT({foreign_key_field}, '.jpg') as FILE_NAME,
    NULL AS UPLOAD_DATE,
    0 AS FILE_SIZE,
    ORCHLABELID AS VENDOR_ID,
    '{session_id}' as SESSION_ID
FROM {source_snowflake_database}.{source_snowflake_schema}.{source_table_name};
"""
# flake8: noqa