amazon-redshift-utils
amazon-redshift-utils copied to clipboard
v_generate_tbl_ddl : Invalid operation: value too long for type character varying(798)
I am getting similar error. Error screenshot: https://i.imgur.com/CglvPh1.png
SQL Statement: select ddl from admin.v_generate_tbl_ddl where schemaname = 'schema_name_goes_here';
Hi, thanks for the report. That view is quite a big view, in that it joins together lots of information. This makes it harder to work out what is going on and which section is generating the error. Are you able to run each of the selects individually from the view definition? By this I mean the view is a UNION of lots of queries, if you are able to run each query individually that might help us track down which statement is causing the issue. Thank you