Need to drop cascade tables before re-creating and writing data

stainlessteelra
stainlessteelra Registered Posts: 17 ✭✭✭✭

I have a few projects that are linked.

Project 1: Creates tables

Project 2: Creates Views and queries results for visualizations

In project 1, i'd like to add something like this to the "Pre-write" statements on the tables:
DROP TABLE IF EXISTS ${schema_name}.${table_name} CASCADE;

Can anyone help with a way to do this? Or the proper variable names (if exists) for the Pre-write field

Comments

Setup Info
    Tags
      Help me…