2回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
no, you cannot create a user table based on svv_redshift_columns due to infamous "Specified types or functions (one per INFO message) not supported on Redshift tables" error. However, it works for svv_columns view. I am not sure what is the difference between these views except column names.
回答済み 1年前
0
If this is a one-time thing then you can create a user table with the data. Once you have such table you should be able to execute the listagg
function.
回答済み 2年前