Load from Local File

With TigerGraph Cloud, you can easily load data from local files into your graph databases. Whether you have data in CSV, JSON, or other formats, you can use the intuitive data ingestion process to import your data. Simply upload your files, specify the schema mapping, and let TigerGraph Cloud handle the rest. This allows you to quickly populate your graph databases with the necessary data for analysis.

1) Select Source

Once you’ve selected Local File,
  1. Click on Screenshot 2024 04 17 at 5.52.21 PM to upload your files or directly drag and drop your files in the File Details window.

    Screenshot 2024 04 17 at 5.53.05 PM
  2. Click Next to process the file.

    The current data loading tool only supports CSV files. Other formats will be available in later releases.

2) Configure File

This step lets you configure the source file details.
  1. The data loading tool will automatically detect the .csv separators and line breaks. The parser automatically splits each line into a series of tokens.

    Screenshot 2024 04 17 at 5.53.45 PM

    If the parsing is not correct, click on the Screenshot 2024 04 17 at 5.54.17 PM button to configure a different option for the delimiter, such as eol, or quote and header.

    Screenshot 2024 04 17 at 5.54.50 PM

    The enclosing character is used to mark the boundaries of a token, overriding the delimiter character.

    For example, if your delimiter is a comma, but you have commas in some strings, then you can define single or double quotes as the enclosing character to mark the endpoints of your string tokens.

    It is not necessary for every token to have enclosing characters. The parser uses enclosing characters when it encounters them.

    You can edit the header line of the parsing result to give each column a more intuitive name, since you will be referring to these names when loading data to the graph. The header name is ignored during data loading.

  2. Once you are satisfied with the file settings, click Next to proceed.

3) Configure Map

If you are loading data into a brand new graph, you will be prompted to let our engine generate a schema and mapping for you. Or you can start from scratch. For more details of schema design please refer to Schema Designer.
  1. Select Generate the schema only or Generate the schema and data mapping.

    Screenshot 2024 04 17 at 5.55.35 PM

    TigerGraph Cloud 4.0 is still in beta release and the schema generation feature is still a preview feature. The correctness and efficiency of the resulting graph schema and mapping could vary.

  2. In the Source column, you can choose the specific column from the data source that you want to map with the attribute.

    Screenshot 2024 04 17 at 5.56.15 PM
  3. Use the + button to create a new attribute of the target vertex or edge.

    Screenshot 2024 04 17 at 5.57.07 PM
  4. The Map all to target button aligns existing attribute names with the corresponding data source headers to establish mappings and also introduces new attributes based on unmatched data source headers.

    Screenshot 2024 04 17 at 5.57.52 PM
  5. Click Next to proceed.

4) Confirm

This step will let you confirm the changes made to the schema and the data mapping you created to load the data.
  1. Simply review the Schema to be change and Data to be loaded lists.

    Screenshot 2024 04 17 at 5.58.36 PM

    Please be aware that some schema changes will result in unintentional deletion of the data. Please carefully review the warning message before confirming the loading.

  2. Click on the Confirm button to run the loading jobs and monitor their Status.

    Screenshot 2024 04 17 at 5.59.16 PM

Next Steps

Next, learn how to use the Schema Designer in TigerGraph Cloud 4.0.

Or return to the Overview page for a different topic.