/* You will need to swap in your table names, region name, tenant name, bucket name, and file names */

BEGIN
 dbms_cloud.copy_data(
    table_name =>'CHANNELS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/chan_v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'COUNTRIES',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/coun_v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'CUSTOMERS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/cust1v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD-HH24-MI-SS')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'SUPPLEMENTARY_DEMOGRAPHICS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dem1v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'SALES',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/dmsal_v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'PRODUCTS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prod1v3.dat',
    format => json_object('delimiter' VALUE '|', 'quote' VALUE '^', 'ignoremissingcolumns' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'PROMOTIONS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/prom1v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'SALES',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/sale1v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD', 'blankasnull' VALUE 'true')
 );
END;
/

BEGIN
 dbms_cloud.copy_data(
    table_name =>'TIMES',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/time_v3.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'removequotes' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD-HH24-MI-SS', 'blankasnull' VALUE 'true')
 );
END;
/


BEGIN
 dbms_cloud.copy_data(
    table_name =>'COSTS',
    credential_name =>'OBJ_STORE_CRED',
    file_uri_list =>'https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/danielernesto/tutorial_3/costs.dat',
    format => json_object('ignoremissingcolumns' VALUE 'true', 'dateformat' VALUE 'YYYY-MM-DD', 'blankasnull' VALUE 'true')
 );
END;
/