Skip to main content

Data Insert

The Data Insert  is a tool to help you take a local data file and upload the data to your platform.

🔎 NOTE: Aginity currently supports Data Insert to DB2, Hive, Netezza, Postgres, and Amazon Redshift. Aginity will be adding support for other database platforms in future releases.

 

To start the data importer go to the [Data Upload] menu as shown below.  Note that Data Insert now supports an unlimited number of rows.

mceclip0.png

How to choose a file?

When you start the import you will be presented with a five-step process in which to identify a file to upload, describe the behavior you want and then perform the load process. In the first screen the following activities are performed.

  1. Pick a database connection where you will upload data to.
  2. Add a local file, either CSV or Excel, using the [Add File] button. 
  3. Confirm the file type
  4. For CSV files, choose a delimiter used to separate fields in the file.
    For Excel files, choose the sheet with data to be uploaded.
  5. Select the Date and Time Formats (optional)
  6. If you click the [With header] check box the parser will assume the first row in the file is a header if not - it will treat the first row as a data row.
  7. You can click Update preview to show the first few rows in the file

🔎 NOTE: Also you can use the Data Upload Template by clicking on the drop-down [Upload Template]. See Data Upload Template documentation.

mceclip2.png

When complete choose Next. 

How to choose columns and rows? 

In step 2, you can choose a numeric limiter for both the number of columns you want to parse and then the number of rows to load. This step is valuable if you have very wide and/or very deep files and you want to work with less columns or less rows.


🔎 NOTE:  It is helpful with very large files to load the first 100 rows to ensure everything works well versus letting it run for an hour only to find out it didn’t work.

mceclip3.png

How to choose columns to include?

This step may seem redundant to the prior step for columns but it allows you to better see more about the columns. Let’s say you have 200 columns and you know you only want the first 10 in Step 2 you can choose columns 1 to 10 and in Step 3 you can better preview and determine the order of the columns you want to load.

mceclip4.png 

How to configure output columns? 

The next step lets you control the column data type and nullability.

Aginity uses the first 1000 rows to best guess Data Type and Precision, but we recommend that you ensure our estimates are correct and change them if necessary.

Additionally all, columns are nullable by default

mceclip6.png

 

How to set output details and loading? 

In step 5 you will supply the database you’ll load to, schema, table name, and other behaviors that will be followed during a load execution.

mceclip7.png
 
When addicting data is finished, need to click Start Upload for inserting data to the table.
mceclip1.png
In the left corner we can see status about success or failure for the star of insert the process; and in sometime you will see second message about success or failure for result of the data insert.
 
mceclip0.png
 
Also you can go to Job Monitor and see more details about Data Insert status. Select the specific task you are interested in and click on 'Job Details' to see detailed error messages and statistics.
 
mceclip1.png
 
mceclip0.png
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.