Import data from a csv file to existing table cartodb

Question

I am trying to add data to an existing CartoDB table from a local csv file. Using Import API creates a new table. How can I specify to add data to existing table instead of new table?

Answer 1

It does not appear that standard tables in CartoDB allow appending rows to existing tables. If you look at the API there is an append parameter but it says that it is "Reserved for future usage.".

However, I did find this thread which indicates that you can import using SQL, provided the schemas match.

Like so:

INSERT INTO mastertable SELECT * FROM anewtable