Started on 2020-10-30
Find out the definition of a Redshift Spectrum table (found on StackOverflow):
select distinct
listagg(columnname || ' ' || external_type, ',\n')
within group ( order by columnnum ) over ()
from svv_external_columns
where tablename = 'TABLENAME'
and schemaname = 'SCHEMANAME';