Import a lookup dataset - Administrator Guide - Cortex XSIAM - Cortex - Security Operations

Cortex XSIAM Administrator Guide

Product
Cortex XSIAM
Creation date
2024-07-16
Last date published
2024-12-12
Category
Administrator Guide
Abstract

Learn more about importing data from an external file to create or update a lookup dataset in Cortex XSIAM.

You can import data from CSV, TSV, or JSON files into Cortex XSIAM to create or update lookup datasets.

Danger

When uploading a CSV, TSV, or JSON file, ensure that the file meets the following requirements:

  • The maximum size for the total data to be imported into a lookup dataset is 30 MB.

  • Field names can contain characters from different languages, special characters, numbers (0-9), and underscores (_).

  • Field names can't exceed 128 characters.

  • Field names can't contain duplicate names, white spaces, or carriage returns.

  • The file doesn't contain a byte array (binary data) as it can't be uploaded.

  1. Select SettingsConfigurationsData ManagementDataset Management+ Lookup.

  2. Browse to your CSV, TSV, or JSON file. You can only upload a TSV file if it contains a .tsv file extension.

  3. (Optional) Under Name, type a new name for the target dataset.

    By default, Cortex XSIAM uses the name of the original file as the dataset name. You can change this name to something that will be more meaningful for your users when they query the dataset. For example, if the original file name is mrkdptusrsnov23.json, you can save the dataset as marketing_dept_users_Nov_2023.

    Dataset names can contain special characters from different languages, numbers (0-9) and underscores (_). You can create dataset names using uppercase characters, but in queries, dataset names are always treated as if they are lowercase.

    Important

    The name of a dataset created from a TSV file must always include the extension. For example, if the original file name is mrkdptusrsnov23.tsv, you can save the dataset with the name marketing_dept_users_Nov_2023.tsv.

  4. Replace the existing data in the dataset overwrites the data in an existing lookup dataset with the contents of the new file.

  5. Click Add to add the file as a lookup.

  6. After receiving a notification reporting that the upload succeeded, Refresh refresh.png to view it in your list of datasets.