• EnglishEspañol日本語한국어Português
  • Log inStart now

Upload CSV-format lookup tables

Our lookups feature lets you enrich your log data, and other New Relic-stored data, with data about your business that you define in a CSV file.

Why use lookups?

When you upload a lookup table, you can then use that data to enrich your queries of New Relic data. For example, you might upload a table that maps host IDs to human-readable host names, and then use that to create a chart that displays the human-readable host names.

Lookup tables help you:

  • Query data that isn't present in your New Relic account
  • Make your telemetry data easier to understand
  • Group data in custom ways

For examples of queries using lookups, see How to query lookup table data.

Add and manage tables

You can add and manage lookup tables through the UI or the NRQL Lookups API.

Some tips when adding a table:

  • The table name is what you'll use to reference that table when you write a NRQL query.
  • Table data isn't obfuscated, so avoid uploading sensitive information.
  • It can take several minutes for an added or updated table to be available in a NRQL query.

When you delete a table, that data is no longer available in NRQL queries, so you should try to make sure a deleted table's data isn't being used in important dashboards.

Learn more table format requirements and other details.

Using the lookup tables UI

The UI for uploading lookup tables is located in the logs UI, but you can use your lookup table data when querying any data type, not just logs.

To find the lookup table UI: From one.newrelic.com, click Logs, and then click Lookup tables. From there, you can upload, download, update, and delete tables.

Using the NRQL Lookups API

Alternatively, you can add and manage tables using the NRQL Lookups API. The NRQL Lookups API supports uploading lookup tables as a CSV file and a JSON object.

CSV value parsing

When a value is read from a CSV file, the system will attempt to parse the value to a boolean, number, or string value.

Query your data

If you're ready to use your table in a query, see How to query lookup table data.

Requirements and technical details

Some more details about lookup tables:

  • To add or edit tables, users need to be core or full platform users.
  • Tables can only be queried from the account in which the table was uploaded.
  • Each account has a limit of 20 lookup tables.
  • Lookup table data can't be used in NRQL alert conditions.
  • Lookup tables have indefinite data retention by default.

In addition to the general requirements for a CSV file, here are our requirements for uploading lookup table files:

  • Each row must have the same number of columns as the header and there must be at least two columns.
  • Table names must conform to the rules for event names
  • Do not use reserved words for table names or column header values.
  • Max file size: 4 MB
  • Max of 20,000 rows
Copyright © 2024 New Relic Inc.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.