Import CSV into specified schema #2443

Describe the new feature

Currently the File->Import->Table from CSV file... menu selection allows you to import a CSV file, but it does not allow you to specify the schema of where to import the resulting table, so it imports into the main schema. By contrast creating a new table under the Advanced drop down does allow you to specify the database schema of where the table should be created.

Use cases:

1. Import into temp schema so you can massage the data to load a table in main schema without cluttering your main schema with temporary tables.
2. Import into an attached database's main schema. [don't think you have access to an attached database's temp schema, so your only choice is the main schema]

Additional info

Please answer these questions before submitting your feature request.

Is your feature request related to an issue? Please include the issue number.

No.

1. Searched is:issue is:open schema
2. Searched is:issue is:open csv import

Does this feature exist in another product or project? Please provide a link.

1. MySQL Workbench
   The operation is slightly different than DB4S. In MySQL Workbench you can right click the appropriate schema in the Navigator pane on the schema tab, then select Table Data Import Wizard. By contrast in DB4S there is no schema Navigator pane so Import is placed on the File menu resulting in the need to specify the schema on the Import CSV file dialog, as DB4S does for the Create Table dialog.

   This shows the layout and options available in the navigator pane, schema tab.

   This shows how to load a CSV into a table in a schema.

Do you have a screenshot? Please add screenshots to help explain your idea.

No, but you can look at the Edit table definition dialog in DB4S, under the Advance drop down to see how specifying the schema is already implemented in DB4S.