Upload a file to a table

[fulghum]

A Hosted Dolt customer would like to have the same file upload support in Hosted Dolt as we have on DoltHub.

When clicking the pencil icon to edit a table, DoltHub gives you a choice of running SQL queries, using the spreadsheet editor, or uploading a file (with various upload options). This customer would like the same option available for Hosted Dolt.

[tbantle22]

Just released a V1 of file upload for the workbench. You can access it my clicking on the Add dropdown in the database nav or my clicking on the pencil icon to edit a table. It uses LOAD DATA to do the import so the functionality is a little different from file upload on DoltHub.

Next I'll be adding the spreadsheet editor and support more LOAD DATA options (like ignore and replace)

[tbantle22]

Spreadsheet editor is now available to insert new rows into a table

[tbantle22]

Deployments with Dolt versions 1.3.0 or greater can now choose how to handle duplicate keys for the import (ignore or replace)