Inserting to existing tables
You Inserting into an existing table has the same first few steps as ingesting into a new table,
Where it differs is shown on the below screenshot, where you should click "Import into existing table". Find the existing (file ingest) table you would like to import into, and click Proceed.
You should again receive a success message like below:
If you receive a failure message, it’s almost always because your upload file has a different number of columns to the destination table. Ensure that there are no values in any additional columns (you may want to delete everything in all columns to the right of your dataset in your upload file).
Running the same query as before, you can see that another equivalent row has been inserted into the existing table, with the differentiator being the import_date.
Updated 9 months ago