I was wondering if it is possible to create dynamic sql in transformation. I tried to use loops and define sql variables, however I didn’t have any luck.
I have never worked with Vertica database and seen some place that vertica has no loops, no arrays, no variables just a plain SQL database. I am not sure if that’s true.
Is this a limitation of a some kind?