Importing Data into the Local Schema

Note: Please precede the names of your files on the local schema with your netid.

(DRAFT)

Create CSV

Connect to LDP

Right click on local schema

Choose Import data

Set up field mapping for source and destination fields

import data

next

choose . csv file

Do Commit after row insert to make sure all records show.

Key column: When you import a local table to Dbeaver, consider adding a key column to make it easier for DBeaver to pick a key.  When you first have need to edit the table, if there isn’t a clear key column, you can choose the unique column following DBeaver’s instructions [will try to flesh this out when next come across].

Updating tables: To update a local table (first open the table in the data view):

• To add a row, right click in a cell of the row you want to add the row after, click on “Edit,” and then click on “Add row,” enter data as needed, and then click on save.
• To remove a row, right click in a cell of the row you want to delete, click on “Edit,” and then click on “Delete current row,” then click on save.
• To correct a value within a cell, click on the cell, edit as needed, and then click on save; you can also open a editing window by right clicking and clicking on “Edit.”