2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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.
répondu il y a un an
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.
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a un mois