Generate rows with In-Database tools

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!

Workflow

Preparation

In Database

In-Database

Accepted answers

LordNeilLord

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?

All comments

LordNeilLord

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703