stlrda/REDB-Workflows

prcl.mdb from S3 -> Staging 1

Closed this issue · 0 comments

DAG Files and scripts that accomplishes the following:

  1. Create staging_1 schema if it does not exist.
  2. For each table in prcl.mdb, create or truncate prcl_tablename_staging_1 in staging_1 schema, and populate it with the appropriate table from prcl.mdb All datatypes should be set to strings.

PostgresDB connection info will be Airflow Connection