Administer LASR Tables

Unload, Reload, or Delete a Table

  1. From the main menu in the administrator, select LASRthen selectManage Tables.
  2. On the LASR Tables tab, right-click on a table, and select an action.
    • If most actions are disabled, select Get Status, and then right-click on the table again.
    • To delete or reload a table that is loaded, begin by unloading the table.

Replace a Source Table

To replace a source table, right-click on a LASR table, and select Change Source. You might use the change source action if an original source table is missing, or if you want to add or remove compression for a table.
Note: Not all tables support the change source action.
Note: If the replacement table differs from the original table in a way that affects a permission condition, data access problems can occur. To provide access, remove the permission condition from the LASR table. See Set a Row-Level Permission Condition.

Results

To view a log for the most recent interactive action for a table, open the LASR Tables tab, right-click on the table, and select Last Action Log.
Tip
Not all actions generate a last action log. To determine which action generated a log, examine the log’s task summary and timestamp.
For troubleshooting, see Load, Reload, and Import Issues.

Additional Considerations

  • Not all tables can be interactively reloaded. See Reload Methods.
    Note: When you use the Load a Table action, a job object (named source-table - Load Job date-and-time) is created to support reloading of the table.
    • The maximum length for a job name is 60 characters.
    • If you edit a job, SAS Visual Analytics might not be able to use the job to perform an interactive reload. In this circumstance, a new job is created the next time you perform a new load of the table.
    • To deploy a job for scheduling, see Scheduling in SAS.
  • The Unload action removes a table from memory, but it does not delete the corresponding metadata object. The Delete action deletes the metadata object that represents an in-memory table.
  • Most of the tab toolbar buttons affect only tables that have a selected (checked) check box.
  • Clicking on the cell that is next to a check box toggles the state of that check box. Before you use a tab toolbar button, make sure only the appropriate check boxes are selected. To clear all check boxes, click the Clear All check boxes icon in the tab toolbar.
  • To perform an action on multiple tables, select check boxes, and then click an icon in the tab toolbar. To cancel all remaining actions in a multi-table operation, click Cancel in the tab toolbar.
Last updated: December 18, 2018