Limit the number of rows when previewing a table in DataGrip

When showing a table (double clicking is from the database pane), datagrip starts selecting all records. Fine for a local database, but as we connect it to redshift it starts streaming gigs of data, slowing down the cluser, especially since multiple users use datagrip. It's indicated by the continuous spinning "connecting" icon, and can only be stopped by clicking the red cross manually.

Is there a way to add a limit to the number of rows it fetches?

1 comment
Comment actions Permalink

Hi, Simon! Actually, it doesn't select ALL rows, to check this press View Query button on the result-set.

It takes the number from this setting:

 

2

Please sign in to leave a comment.