# Show Running Queries on Redshift via Native Interface

**URL:** <https://community.cdata.com/t/show-running-queries-on-redshift-via-native-interface/851>\
**Category:** CData Virtuality \[Archived\]\
**Tags:** article, cdata-virtuality\
**Created:** [July 12, 2024, 5:12pm UTC](https://community.cdata.com/t/show-running-queries-on-redshift-via-native-interface/851 "2024-07-12T17:12:31Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![anonymous](https://avatars.discourse-cdn.com/v4/letter/a/8491ac/32.png) [@anonymous](https://community.cdata.com/u/anonymous)\
**Post date:** [July 12, 2024, 5:12pm UTC](https://community.cdata.com/t/show-running-queries-on-redshift-via-native-interface/851/1 "2024-07-12T17:12:31Z")

</div>

When native queries are enabled in your Amazon Redshift data warehouse (this can be done by adding&nbsp;supportsNativeQueries=true&nbsp;as a translator property to the data source configuration), you can easily view the 200 most recent&nbsp;queries sent to your data warehouse:

> ```auto
> SELECT x.* FROM table( call "dwh.native"("request" => 'select query, pid, elapsed, substring from svl_qlog ORDER BY starttime DESClimit 200') ) w,ARRAYTABLE( w.tuple COLUMNS query string, pid integer , elapsed string, "substring" string ) x;
> 
> ```

For more detail, you can see Redshift documentation:&nbsp;[View Recent Queries](https://docs.aws.amazon.com/redshift/latest/dg/t_querying_redshift_system_tables.html#t_querying_redshift_system_tables-view-recent-queries)&nbsp;and&nbsp;[SVL\_QLOG](https://docs.aws.amazon.com/redshift/latest/dg/r_SVL_QLOG.html).