0

I am running an SQL script called by workbench/J in CLI to execute about 15 grant statements. This takes well over 30 minutes. The data has not changed, and all other types of statements run at their regular speed. Workbench Build 119

elcunyado
  • 351
  • 1
  • 2
  • 11
  • please can you explain what / how you are running exactly? i dont understand what you mean by "SQL script called by workbench/J in CLI" – Jon Scott Dec 13 '18 at 17:02
  • It is just a .sql file that has lines such as: – elcunyado Dec 18 '18 at 14:41
  • such as what?.... – Jon Scott Dec 18 '18 at 14:53
  • `grant select on table markets to user corporate' etc. I then use a batch file to call the workbench.exe The main thing is, I'm just executing grant statements with workbench/J and its taking forever – elcunyado Dec 18 '18 at 15:10
  • can you try using psql? same? – Jon Scott Dec 18 '18 at 15:26
  • sorry psql? is that this? https://www.postgresql.org/ – elcunyado Dec 18 '18 at 15:38
  • psql is the best way to run redshift in batch - not through workbench.exe! - see https://docs.aws.amazon.com/redshift/latest/mgmt/connecting-from-psql.html – Jon Scott Dec 18 '18 at 15:39
  • gotcha, thank you. Actually this issue has stopped. It plagued our processes for weeks and I guess it just stopped. I cannot identify any specific action that did so. Unsure how to close out this question with that conclusion though – elcunyado Dec 18 '18 at 16:57

0 Answers0