Invoke Bulk Load from Object Storage Page
Specify the details for performing a bulk data import operation.
Element | Description |
---|---|
Select Bucket |
Select the object storage bucket in which to place or delete the file. The object storage buckets available for selection are located in the compartment that you specified on the Connections page when creating the connection. Note: If you don't have the privilege to access the
buckets, a |
Delete file from object storage after operation completion | Select to delete the file from the object storage bucket. Otherwise, the file remains in the bucket. |
Review and specify the copy_data format options | Click Edit to
optionally specify the file format options. If not
specified here or sent in the mapper, all default options are used.
The following options are displayed by default.
|
Select Schema | Select the database table schema. |
Select Table | Select the database table in which to write the file data. Based on your selection, all the fields in that table are displayed for selection. |
Table Columns | Displays the columns (fields) in the table.
Note: When selecting the fields in the
table, select all the fields in the order of the incoming data.
If none of the fields are selected, a default value is
considered that takes into account that the data fields are in
the same order as the table fields. Table column names with
special characters such as spaces or a
As an example, you may select to move the following
table columns to the Re-order columns as per input
data list to match the order of the CSV file:
|