If you encounter a database connection error, please go to AWS console and make sure you added your client PC's IP address to your Security Group (Inbound) associated with the Redshift cluster.
7. Number of rows
From performance point of view, we no longer show actual number of rows which can be only fetched by executing whole query again.
If you still want to show the actual number of query for your query, you can do so by setting System Configuration.
Then set "Yes" For "Show Actual Number of Rows on SQL Data Import Dialog"
This will show you Actual Number of Rows like below.
8. Exploratory Data Analysis for Amazon Redshift with R & dplyr