There are quite a few options to get data into EXASOL. The three main ones being, inserting directly via Exaplus, Importing from a text file and Importing from an existing database external to EXASOL.
To start with I’m going to look at how to insert data into EXASOL via EXAplus. If you haven’t already please go back and look at How to Create a table. Assuming you’ve got a table in place, let’s get started.
Syntax 1) INSERT INTO tablename (cols) VALUES (vals);
If you know of any more please let me know and I’ll tag them in. Next up, I’ll be covering inserting data into EXASOL from a text file or CSV.