Formula In-DB Tool does not allow me to add a new column

[terrychung68]

Can anyone tell me why I don't see the option "Add Column" in the Formula In-DB tool. I am pulling a Redshift table that I do not own, adding a column and then publishing it to a new Redshift table that I own.

[jrlindem · Accepted solution]

For the In-DB tools, it's more or less labeled differently.  The "Expression" is the representation of the logic that you're keying in.  That is the "new field."  But since In-DB is translating everything into SQL commands, they don't call it "Add Column."  In order for that/those new columns to be added to your database, you'll have to have the destination table have those fields built in, first <OR> you have to ensure that you have permission to create tables from your Alteryx Workflow (role) directly.