{% macro project_setup() %}
{% set sql %}
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."POSITION_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."PERSON_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."PRODUCT_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."S_PROD_INT_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."S_ORG_EXT_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."EMPLOYEE_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."ORGANIZATION_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."POSITION_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."OPPORTUNITY_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."CAMPAIGN_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_TRANSIENT"."ASSET_AUX" as (
select
NULL as ROW_ID,
NULL as LAST_UPD);
CREATE TABLE IF NOT EXISTS {{ target.database }}."EDW_CONFIG"."SHERLOK_BROKERS" (
BROKER_ID VARCHAR2(15),
START_DT DATE,
END_DT DATE);
{% endset %}
{% do run_query(sql) %}
{% endmacro %}