Generate rows with In-Database tools

[EzequielO]

Hello,

I'm working on a project where we need to generate rows (dates) using the in-db tools.

This was done in the past without the in-db tools and we used "Generate Rows" as we needed an initialization expression, a condition and a loop.

Is there a way to replicate "Generate rows" with any in-db tool?

Thanks!

[LordNeilLord · Accepted solution]

Hey @EzequielO

There is no Generate Rows in-Db but you could generate the rows then use the datastream-in tool to bring these values back into your In-DB workflow?

[EzequielO]

Hey LordNeilLord, yes I will be using that solution untill we think of something else. Thanks!

[Amadeu_gustavo]

I'm working in a redshift db of a supplier with 13 mio rows and I need to generate more rows.

Working indb will save me a ton of time, is there any possibility to generate rows in db so I can use the processing power from Redshift before I download the data?