Using the readFile() Function

The readFile() function reads a file that has previously been loaded into LogScale using Uploading Files or an automated method. The function could also read tables defined with the defineTable() function.

When used, the readFile() function can operate as dataset to help seed or join with other data in the form of a primary query as part of a right join, using the defined file, or table, as the input source for the data set.

Image showing the intersection of two datasets, using the readfile() function as the primary query

readFile() is used with the join() function to match information. For example, the following query uses a lookup file as the basis of the query to select a base set of hostnames to use when querying access data:

logscale
readFile("host_names.csv")
| !join(query={groupBy(host_name)}, field=host_name, key=host_name, include=[host_name, id])