CREATE TABLE geography_dim (
    "REGION_ID"             VARCHAR2(120),
    "REGION_NAME"           VARCHAR2(100),
    "COUNTRY_ID"            VARCHAR2(2),
    "COUNTRY_NAME"          VARCHAR2(120),
    "STATE_PROVINCE_ID"     VARCHAR2(120),
    "STATE_PROVINCE_NAME"   VARCHAR2(400)
);

BEGIN
  DBMS_CLOUD.COPY_DATA (
  table_name => 'GEOGRAPHY_DIM',
    file_uri_list => 'https://objectstorage.uk-london-1.oraclecloud.com/p/h6-DSva6YkgRzbKrhCWQpp3Zvn9EBorIqjliHdDwQgAzxX3atWDeClDGi_WxwWby/n/adwc4pm/b/data_library/o/d1945/table=GEOGRAPHY_DIM/partition=all_rows/*.csv',
  format => '{"delimiter":",","recorddelimiter":"newline","skipheaders":"1","quote":"\\\"","rejectlimit":"1000","trimspaces":"rtrim","ignoreblanklines":"false","ignoremissingcolumns":"true","dateformat":"DD-MON-YYYY HH24:MI:SS"}'
  );
END;
/

CREATE TABLE product_dim (
    "CATEGORY_ID"       INTEGER,
    "CATEGORY_NAME"     VARCHAR2(100),
    "DEPARTMENT_ID"     INTEGER,
    "DEPARTMENT_NAME"   VARCHAR2(100)
);

BEGIN
  DBMS_CLOUD.COPY_DATA (
  table_name => 'PRODUCT_DIM',
    file_uri_list => 'https://objectstorage.uk-london-1.oraclecloud.com/p/h6-DSva6YkgRzbKrhCWQpp3Zvn9EBorIqjliHdDwQgAzxX3atWDeClDGi_WxwWby/n/adwc4pm/b/data_library/o/d1945/table=PRODUCT_DIM/partition=all_rows/*.csv',
  format => '{"delimiter":",","recorddelimiter":"newline","skipheaders":"1","quote":"\\\"","rejectlimit":"1000","trimspaces":"rtrim","ignoreblanklines":"false","ignoremissingcolumns":"true","dateformat":"DD-MON-YYYY HH24:MI:SS"}'
  );
END;
/

CREATE TABLE sales_fact (
    "MONTH_ID"            VARCHAR2(10),
    "CATEGORY_ID"         NUMBER,
    "STATE_PROVINCE_ID"   VARCHAR2(120),
    "UNITS"               NUMBER,
    "SALES"               NUMBER
);

BEGIN
  DBMS_CLOUD.COPY_DATA (
  table_name => 'SALES_FACT',
    file_uri_list => 'https://objectstorage.uk-london-1.oraclecloud.com/p/h6-DSva6YkgRzbKrhCWQpp3Zvn9EBorIqjliHdDwQgAzxX3atWDeClDGi_WxwWby/n/adwc4pm/b/data_library/o/d1945/table=SALES_FACT/partition=all_rows/*.csv',
  format => '{"delimiter":",","recorddelimiter":"newline","skipheaders":"1","quote":"\\\"","rejectlimit":"1000","trimspaces":"rtrim","ignoreblanklines":"false","ignoremissingcolumns":"true","dateformat":"DD-MON-YYYY HH24:MI:SS"}'
  );
END;
/

CREATE TABLE time_dim (
    "MONTH_ID"           VARCHAR2(30),
    "MONTH_NAME"         VARCHAR2(40),
    "MONTH_LONG_NAME"    VARCHAR2(30),
    "MONTH_END_DATE"     DATE,
    "MONTH_OF_QUARTER"   NUMBER,
    "MONTH_OF_YEAR"      INTEGER,
    "QUARTER_ID"         VARCHAR2(30),
    "QUARTER_NAME"       VARCHAR2(40),
    "QUARTER_END_DATE"   DATE,
    "QUARTER_OF_YEAR"    NUMBER,
    "SEASON"             VARCHAR2(10),
    "SEASON_ORDER"       NUMBER,
    "YEAR_ID"            VARCHAR2(30),
    "YEAR_NAME"          VARCHAR2(40),
    "YEAR_END_DATE"      DATE
);
/

BEGIN
  DBMS_CLOUD.COPY_DATA (
  table_name => 'TIME_DIM',
    file_uri_list => 'https://objectstorage.uk-london-1.oraclecloud.com/p/h6-DSva6YkgRzbKrhCWQpp3Zvn9EBorIqjliHdDwQgAzxX3atWDeClDGi_WxwWby/n/adwc4pm/b/data_library/o/d1945/table=TIME_DIM/partition=all_rows/*.csv',
  format => '{"delimiter":",","recorddelimiter":"newline","skipheaders":"1","quote":"\\\"","rejectlimit":"1000","trimspaces":"rtrim","ignoreblanklines":"false","ignoremissingcolumns":"true","dateformat":"DD-MON-YYYY HH24:MI:SS"}'
  );
END;