Administrator Load

Preparation
Register Source Tables
Stage a Registered Table
Load a Table

Preparation

Register Source Tables

In the administrator, only registered tables can be interactively loaded or staged. For alternative methods for making data available, see Autoload and Self-Service Import.
  1. In the administrator’s Folders pane, right-click on a library, and select Register and Update Tables.
    Tip
    To display the Folders pane, select Viewthen selectFolders from the main menu.
  2. In the Select Tables window, select the tables that you want to register. Click OK.
  3. In the Register Tables window, make any necessary adjustments. Click OK.
    Note: If you register a table that already exists in the specified metadata folder, that table’s metadata is updated.
    Note: To add a library or learn about alternate methods for registering tables, see the SAS Intelligence Platform: Data Administration Guide.

Stage a Registered Table

Note: This task is applicable only if you load data from co-located or NFS-mounted storage to a distributed SAS LASR Analytic Server. See Distributed Server: Parallel Load.
  1. In the Folders pane, right-click on a table, and select Add to HDFS (to stage to co-located HDFS) or Add to Data Server (to stage to NFS-mounted MapR or a legacy co-located provider).
    Tip
    To display the Folders pane, select Viewthen selectFolders from the main menu.
  2. In the Add Table window, make any necessary adjustments.
    Note: Specify a table name that will also be appropriate as the LASR table name. (When you later load the staged table, the LASR table name will be the same as the name of the staged table.)
  3. Click OK.

Load a Table

  1. From the main menu in the administrator, select LASRthen selectManage Tables.
  2. In the tab toolbar, click the Load a Table icon.
  3. In the Load a Table window:
    1. Click Browse, and select a source table. For example, to load a sample table, navigate to /Shared Data/SASHELP, and select the CARS table.
    2. In the LASR Table section, make any necessary adjustments.
      Note: The location that you select affects access to the loaded table. Each table inherits permissions from its parent folder.
    3. Click OK.
Tip
You can also load a new table from the Folders pane (right-click on a table) or from the LASR Servers tab (right-click on a server).
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: December 18, 2018