Need to drop cascade tables before re-creating and writing data
stainlessteelra
Registered Posts: 17 ✭✭✭✭
in General
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
