Snowflake Nuggets

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

  https://interworks.com/blog/chastie/2019/12/12/zero-to-snowflake-importing-data-without-code-via-the-user-interface/

https://docs.snowflake.com/en/user-guide/queries-hierarchical.html