Skip to main content

Context ManagementContext Management Administration Guide

Create a Custom Context Table by Importing a CSV File

tile-import-csv.png

The Import CSV option is designed to streamline the process of creating a new custom context table by uploading data in a CSV file. When using this option, available on the Context Library tab, creating a custom table and uploading data are all part of a single procedure.

If you prefer more flexibility when creating a custom context table, or want to upload data manually, use the Add Custom option on the Context Library tab instead.

Note

  • A total of 200 custom context tables can be created.

  • A custom context table can contain up to a maximum of 500,000 records.

Prepare a CSV File

Before you can create a custom table by importing a CSV file, you must first prepare a CSV file that conforms to the following requirements:

  • It must be a maximum file size of 300 MB. If the CSV file is larger than 300 MB, compress it as a ZIP file. A compressed ZIP file must contain only one CSV file.

  • It must include a header row.

    Note

    A header row with column names is mandatory when uploading a CSV file. Failure to include a header row in the CSV file can result in missing or incorrect data in your context table.

  • For attributes that represent a list of values, the values must be provided in one of the following ways in the CSV file:

    array-values-in-csv.png

    Note

    List of attributes that can be included in a custom context table:

    • Direct Reports

    • Email Addresses

    • Group Name

    • Phone Number

Create a Table with a CSV File

To create a new custom context table by importing a CSV file:

  1. Log into the Exabeam Security Operations Platform with your registered credentials.

  2. Find the Security Management tab and click the Context Management tile.

  3. Navigate to the Context Library tab and click Import CSV. The Import CSV dialog box opens.

  4. On the left side of the dialog box, provide the following information:

    • Context Table Name – Enter a name for the new custom context table.

    • Context Table Type – Select the type of context data the new table will contain. Options include Other and User.

    • Automatically create attributes – Select the check box if you want to use the CSV column header names to automatically create custom attributes in the new context table.

  5. Click Select File and select a CSV file to upload. Ensure that the file conforms to the requirements described in Prepare a CSV File.

  6. Click Review Mapping. A table is displayed listing the columns contained in the CSV file.

    import-csv-mapping-arrows.png
  7. In the Target row of the table, click Add Attribute for each CSV column, and do one of the following:

    Note

    If you chose to have custom attributes created automatically from your CSV column headings (in Step 4), and those custom attributes do not duplicate an existing attribute, you can skip this step and continue with Step 8. However, if any of the automatically created attributes is a duplicate of an existing attribute, you will need to select the existing attribute from the list in the Target row of the table.

    • Select one of the available attributes to map it to the CSV column

      Note

      You cannot include the following attributes in a custom context table: Thumbnail Photo, User Account Control.

    • Click Add Custom Attribute, enter a new attribute name, and click the plus icon (icon-add-attribute.png) to add it as an attribute mapped to a CSV column.

  8. In the Primary Key row of the table, click the radio button for one of the attributes to designate it as the key for the context table.

    Note

    You cannot designate one of the list attributes as the key for the context table:

    • Direct Reports

    • Email Addresses

    • Group Name

    • Phone Number

  9. Click Create context table. The CSV data is uploaded to the new context table.

  10. Click View Your Table to open the new context table and view the uploaded data.