i try to execute the redshift function "ANALYZE COMPRESSION" to receive the best encoding for columns in a table. I used in an orchestration job the SQL script component to execute this function but i received no result table. I also try to execute this in a transformation job with a sql component, but this end with a syntax error message.
the "Analyze tables" component only update statistical metadata, but not allow to execute the command "ANALYZE COMPRESSION" to receive a result regarding best column encoding for a specific table.
