Data Load Using External Table

Data Load Using External Table

External Table command can be used either on the Linux host or can be executed remotely through different clients like Squirrel, Aginity work bench etc. The only difference in the command when using remote client will be addition of REMOTESOURCE in Using section.

For loading data from a file name Data.txt which is in D:\ and data is in comma delimited format as below

For creating new table Employee in the Database(Test) below is the query. Here I am using ODBC driver for connecting to netezza engine we can also use JDBC and OleDB as options to connect. Also we should keep in mind that netezza does not support cross database access for DDL and DML, so out database should be selected properly in the Drop box as below.

The below code should be run to create the Employee Table from the file D:\Data.txt

Same data if we need to load through the Linux host then we can connect to the host through putty. Load the file to the host using filezilla in a folder and very if the file exist in the folder.

Now run the below code to load the data.