redshift_header_select.sql

select
  column1,
  column2,
  column3,
  column4,
  column5
from (
  select
    '"column1"' column1,
    '"column2"' column2,
    '"column3"' column3,
    '"column4"' column4,
    '"column5"' column5,
    0 as sort_order
  union all
  select
    '"' || coalesce(cast(column1 as text), '') || '"',
    '"' || coalesce(cast(column2 as text), '') || '"',
    '"' || coalesce(cast(column3 as text), '') || '"',
    '"' || coalesce(cast(column4 as text), '') || '"',
    '"' || coalesce(cast(column5 as text), '') || '"',
    1
  from my_table
)
order by sort_order;

redshift_header_unload.sql

unload ('
  select
    column1,
    column2,
    column3,
    column4,
    column5
  from (
    select
      \'"column1"\' column1,
      \'"column2"\' column2,
      \'"column3"\' column3,
      \'"column4"\' column4,
      \'"column5"\' column5,
      0 as sort_order
    union all
    select
      \'"\' || coalesce(cast(column1 as text), \'\') || \'"\',
      \'"\' || coalesce(cast(column2 as text), \'\') || \'"\',
      \'"\' || coalesce(cast(column3 as text), \'\') || \'"\',
      \'"\' || coalesce(cast(column4 as text), \'\') || \'"\',
      \'"\' || coalesce(cast(column5 as text), \'\') || \'"\',
      1
    from my_table
  )
  order by sort_order;
')
TO 's3://object_path_prefix'
credentials 'aws_access_credentials'
gzip delimiter AS ',' escape allowoverwrite manifest parallel off;