table import

The table import command imports a custom table into the server. Custom tables are created using the Table Management feature in Spectrum Enterprise Designer. For more information, see the "Lookup Tables" section of the Data Quality Guide.

Usage

table import CustomTable --u TrueOrFalse
RequiredArgumentDescription
Yes--f CustomTableSpecifies the custom table you want to import. Directory paths you specify here are relative to the location where you are running the Administration Utility.
No--u TrueOrFalseSpecifies whether to overwrite the existing table if a table with the same name is already on the server, where TrueOrFalse is one of the following:
true
If there is a table on the server with the same name as the table you are importing, the table on the server will be overwritten. This is the default setting.
false
If there is a table on the server with the same name as the table you are importing, the table will not be imported.

Example

This example imports the table named MyTable.db which is located in a subfolder named exported in the location where you are running the Administration Utility. Because no --u command is specified, any existing table of the same name on the server will be overwritten.

table import exported\MyTable.db