Working with Tables in the LASR Tables Tab

Load a New Table

When you load a new table from the Load a Table window, SAS Visual Analytics Administrator creates an output table in the SAS metadata, and a new job is created in the same folder where the output table is placed. If an output table name is specified as OrionRetailCustomers, the default name for the job in the metadata is: OrionRetailCustomers-Load Job.
To load a new table:
  1. Select LASR Tables tab from the toolbar, click, and expand the tree view for Server.
  2. Select a library, and click Load a Table.
    Tip
    The Load a Table icon is enabled if the server connection is running, and the library is selected.
  3. In the Load a Table window, click Browse for the Source Table: Name field.
  4. In the Select window, navigate through SAS Folders, select the table, and click OK.
    The Name and Library fields below Source Table are filled.
  5. In the Name field for LASR Table, enter a name for the output table. The description is optional.
    Note that this description is displayed next to this LASR table when users select a data source in the Open Data Source window within SAS Visual Analytics applications. When you add a description, it provides additional information to the users about this data source.
  6. Click Browse for the Location field.
  7. In the Choose a Location window, navigate to the folder where you want the target or output table to be created, and click OK.
    Tip
    You must have ReadMetadata, WriteMetadata, and WriteMemberMetadata permissions assigned to the folder where you want to load the table.
  8. Click Submit.
    A new LASR table is registered in the SAS metadata, a job is created in the same folder within the metadata, and the table is loaded to the SAS LASR Analytic Server.
  9. Click Refresh. Then, click and expand the tree view for Server. The loaded table is displayed with the status Status.
Here are some additional facts about loading a table:
  • For deployments that use a co-located data provider, the SAS LASR Analytic Server performs a comparison of IP address to determine whether a parallel read is possible. The IP address that is in the SERVER= option of the generated LIBNAME statement must match the IP address of the SAS LASR Analytic Server root node.
  • When the data is loaded from a data source that is not a co-located data provider, it is transferred to the root node of the server, distributed evenly among the machines in the cluster, and then loaded into memory.

Reload an Unloaded Table

If a table in unloaded, it continues to be displayed on the LASR Tables tab with Unloaded Table in the Status column.
To reload an unloaded table:
  1. On the LASR Tables tab, click and expand the tree view forServer.
  2. Select the table with the status Unloaded Table, and click Reload a Table.
    A progress indicator runs while the table is being loaded.
  3. Click Refresh to refresh. To view the changed status of the table, click and expand the tree view for Server.

Unload a Table

To unload a table:
  1. On the LASR Tables tab, click and expand the tree view forServer.
  2. Select a table that is displayed with the status Unloaded Table.
  3. Click Delete a Table.
    A progress indicator is displayed when the table is being unloaded.
  4. To view the changed status of the table, click Refresh. Click and expand the tree view for Server.
    The table is displayed in the Status column in an unloaded state Unloaded Table.
Copyright © SAS Institute Inc. All rights reserved.