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?