How to Stop SQL Execution in RStudio

I'm using some of RStudio's new features to edit and run SQL scripts, then bring the data into R. Previously I used Aginity Workbench to run Netezza SQL. Workbench has a handy stop-sign icon that can be selected to stop a running query. How can I similarly stop an active query in RStudio? The usual ctrl + C doesn't seem stop the execution of SQL code...

1 Like

Has anybody tried this?

In general, I find it hard to stop a SQL query (either MySQL or PostgreSQL) from within the R console, and I'm assuming that RStudio is using the console as well.

What I do as a workaround is run pg_admin or MySQL workbench so I can kill the query from there when I've messed up.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.