Hi,
is it possible in Redshift DB to keep or get number of records returned from prev. query? I need to keep logs from script processing. For each query (most of them will be like INSETY INTO table SELECT …. – if table was truncated before – than its easy, but if query was appending table – is it possible to get from some system tables information, how many records have been porcessed in last query executed in the session?
Hi,
is it possible in Redshift DB to keep or get number of records returned from prev. query? I need to keep logs from script processing. For each query (most of them will be like INSETY INTO table SELECT …. – if table was truncated before – than its easy, but if query was appending table – is it possible to get from some system tables information, how many records have been porcessed in last query executed in the session?
Thanks!
Thanks for your query. Yes, it is possible, have a look on this link http://www.sqlhaven.com/amazon-redshift-getting-number-of-records-affected-in-last-query-executed-in-current-session/