Table Operations

CREATE OR REPLACE TABLE 

EDW_BIDEV_CKE_DB.FACT.FORECAST_PLAN_LEDGER 

CLONE 

EDW_DEV_CKE_DB.FACT.FORECAST_PLAN_LEDGER;

CREATE TABLE 

EDW_BIDEV_CKE_DB.ADHOC.RAW_FOR_PLAN_LEDGER

LIKE 

EDW_DEV_CKE_DB.FINANCE.RAW_FOR_PLAN_LEDGER

CREATE OR REPLACE TRANSIENT TABLE

 EDW_BIDEV_CKE_DB.ADHOC.RAW_PS_GL_ACCOUNT_TBL

CLONE 

EDW_PROD_CKE_DB.FINANCE.RAW_PS_GL_ACCOUNT_TBL