Creating columns dynamically to retool database - table

Workflows
1

Hello,

I am just wondering if it is possible to create columns dynamically to a Retool DB - table?

In this workflow I get missing (but required) columns for my import on newAttributes - block. Then I will try to loop all the rows of newAttributes - block on a loop and add columns to my table according to data coming from newAttributes - block. However, I get " Error: syntax error at or near "$1" error.

Näyttökuva 2023-8-31 kello 21.34.26
Näyttökuva 2023-8-31 kello 21.34.261372×884 89 KB

2

Hi, welcome to the forum

pretty sure that won't be possible and at any rate could be undesirable - If these attributes are so variable I think you'd be better to create a key value table of attribute metadata instead and not create them as columns