Generating a subquery for an external data system using a configuration file

A computing system of a data intake and query system, the computing system comprising:

• memory;
• and
• one or more processing devices coupled to the memory and configured to:
• receive, at the data intake and query system, a query identifying a set of data to be processed and a manner of processing the set of data, wherein at least a portion of the query is written in a first query language interpretable by the data intake and query system, and wherein a subquery included in the query is written in a second query language interpretable by an external data system;
• convert the subquery from the second query language to the first query language to obtain a translated subquery;
• perform an optimization action on the translated subquery to obtain a processed translated subquery;
• convert the processed translated subquery from the first query language to the second query language to obtain a modified subquery interpretable by the external data system;
• define, by the data intake and query system, a query processing scheme for obtaining and processing the set of data based on the query and the subquery, wherein defining the query processing scheme comprises generating instructions for one or more processors to receive and process results of the modified subquery to obtain processed results and to provide the processed results to the data intake and query system;
• and
• execute the query based on the query processing scheme.

Non-transitory computer readable media comprising computer-executable instructions that, when executed by a computing system of a data intake and query system, cause the computing system to:

• receive, at the data intake and query system, a query identifying a set of data to be processed and a manner of processing the set of data, wherein at least a portion of the query is written in a first query language interpretable by the data intake and query system, and wherein a subquery included in the query is written in a second query language interpretable by an external data system;
• convert the subquery from the second query language to the first query language to obtain a translated subquery;
• perform an optimization action on the translated subquery to obtain a processed translated subquery;
• convert the processed translated subquery from the first query language to the second query language to obtain a modified subquery interpretable by the external data system;
• define, by the data intake and query system, a query processing scheme for obtaining and processing the set of data based on the query and the subquery, wherein defining the query processing scheme comprises generating instructions for one or more processors to receive and process results of the modified subquery to obtain processed results and to provide the processed results to the data intake and query system;
• and
• execute the query based on the query processing scheme.