Database Command (create table) in module

I have a module that executes a CreateTable command to PostgreSQL.

The issue I have that if the pipeline before this command (the transform before) has no columns then the CreateTable does not work. It says the columns don’t exist.

Now I can temporarily create a sandbox that has the required columns, that sandbox disappears when I close the project. - so the module is not reusable to help in recreating the table whenever I invoke it.

Is there something like Sandboxes that can be persistent?

Check out the conditional workflows in our tutorial: