PostgreSQL: psycopg2.errors.AmbiguousColumn: column reference is ambiguous

Пробую сделать такой запрос для добавления данных в RedShift:

-- Insert records
INSERT INTO target.table (
            collect_project_id,
            project_number,
            project_name,
            connect_project_id,
            project_desc,
            project_type,
            project_status,
            project_path,
            language_code,
            country_code,
            timezone,
            date_created,
            date_updated
            )
(SELECT id, number, name, connect_project_id, description, type, status, path, language, country, timezone, created, modified
FROM source.table
LEFT JOIN target.table
ON source.table.id = target.table.collect_project_id 
WHERE target.table.collect_project_id != source.table.projects.id AND (source.table.created > getdate() - interval '30 minutes' OR source.table.modified > getdate() - interval '30 minutes'));

Получаю ошибку:

psycopg2.errors.AmbiguousColumn: column reference "connect_project_id" is ambiguous