optimizing a really long code with a lot of JOINS on Redshift

Asked Nov 14 '19 at 03:38

Active Nov 15 '19 at 06:49

Viewed 40 times

I need help with a really long existing code that runs on Amazon Redshift. It is returning a WLM timeout therefore I need to optimize or improve it somehow so it won't get the WLM anymore.

Here is the code:

https://drive.google.com/file/d/1CsgFNisb77qWc3t5KUVQkVGA4iPtk5ER/view?usp=sharing

Any ideas?

Thank you.

edited Nov 14 '19 at 06:53

asked Nov 14 '19 at 03:38

Stuck At Home Overflow

1

Rather than posting a link, please include the code in the question. – Laurenz Albe Nov 14 '19 at 06:48
I tried that but it won't allow me to. – Stuck At Home Overflow Nov 14 '19 at 10:02
Thanks for the reminder Laurenz. I hope you still can shed some light on my problem. – Stuck At Home Overflow Nov 14 '19 at 10:04

optimizing a really long code with a lot of JOINS on Redshift

0 Answers0