SAP HANA Cloud - Eclipse - Adding CSV file into the DB

[former_member602731]

Hi,

I got a connection to the SAP HANA database. I've created a personal DB called simply "database" which I want to fill with two CSV files that I have in my laptop.

How can I do this? Do I need to create the tables with all the columns before and then fill with the data?

One of the problem is that my CSV files are composed by 130 columns and thousands of rows. It is impossible to create all the columns from scratch.

Thanks.

[tom_slee]

There are two import methods. You should be able to do the following:

Right click on the Tables folder and choose Import Data (not Import Catalog Object). It starts a short wizard.

As you work through the wizard, you have the option of creating a new table. See the attached screenshot.