How to view a Redshift query

SVL_STATEMENTTEXT is the right place to get full query text. As you rightly noticed, when a single statement contains more than 200 characters, additional rows are created for that statement and a sequence number is assigned for each part. Sequence 0 is the first row, 1 is the second, and so on.

To get full query text from SVL_STATEMENTTEXT, you can use the below sample query

select LISTAGG(CASE WHEN LEN(RTRIM(text)) = 0 THEN text ELSE RTRIM(text) END, '') within group (order by sequence) AS query_statement 
from SVL_STATEMENTTEXT where xid=<<your transaction's xid>>