Send Author Khorshed an email at email@example.com
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 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/
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.