Invalid operation: cannot drop sortkey column "_airbyte_emitted_at"

[boggdan]

I find a solution for my case.

I check the DDL of the table:

DISTSTYLE AUTO
 DISTKEY (_airbyte_ab_id)
 SORTKEY (
	_airbyte_emitted_at
	)

The destination cannot drop _airbyte_emitted_at because it was sortkey. So I disable de sortkey with:

ALTER TABLE […] ALTER SORTKEY NONE

Docs reference: Amazon Redshift now supports changing table sort keys dynamically