topic Re: Possibility of Joining Lookup Data with External CSV in DQL in DQL

Possibility of Joining Lookup Data with External CSV in DQL

Akhil-Jayendran — Tue, 29 Apr 2025 19:34:55 GMT

Hello All,

Is it possible to join data from a lookup and retrieve details from an external CSV file using DQL, or elsewhere within a dashboard?

Regards,

Akhil

Re: Possibility of Joining Lookup Data with External CSV in DQL

dannemca — Tue, 29 Apr 2025 20:39:59 GMT

Hi, sure you can.

It will basically depends on how will you consume this external CSV.

If you cuold simply insert the CSV content into the DQL using the data as source (https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-query-language/commands/data-source-commands#data) you can then use the lookup normally

But if you need to get a new version of the CSV content every new run, you can try use the workflow to retrieve the CSV content, assuming you can get it thru an API (https://docs.dynatrace.com/docs/analyze-explore-automate/workflows/default-workflow-actions#workflows-actions) and create a new entry for this as a new log, using the log ingestion api (https://docs.dynatrace.com/docs/discover-dynatrace/references/dynatrace-api/environment-api/log-monitoring-v2/post-ingest-logs)

Re: Possibility of Joining Lookup Data with External CSV in DQL

Akhil-Jayendran — Wed, 30 Apr 2025 13:21:24 GMT

Hello @dannemca ,

Thanks for your reply,

Using the data as a source in DQL may not be a viable solution, considering the CSV contains 62K+ rows. I also considered ingesting the CSV as logs, but wanted to check if there are any out-of-the-box solutions available in Dynatrace first.

BR,

Akhil

Re: Possibility of Joining Lookup Data with External CSV in DQL

michael_krall — Fri, 02 May 2025 06:54:35 GMT

Hi, so there is no out-of-the-box solution just yet, but we are currently working on providing the possibility to store static lookup data directly in Grail. This will allow you then to upload the CSV as lookup data to Grail and use it directly in your DQL queries.

Re: Possibility of Joining Lookup Data with External CSV in DQL

Akhil-Jayendran — Fri, 02 May 2025 18:19:51 GMT

Hey @michael_krall , That is awesome news! Do we have any ETA or a roadmap document we can look at?

Re: Possibility of Joining Lookup Data with External CSV in DQL

michael_krall — Mon, 05 May 2025 11:11:48 GMT

We are planning to start with a preview of this new feature in early CQ3.

Re: Possibility of Joining Lookup Data with External CSV in DQL

Akhil-Jayendran — Mon, 28 Jul 2025 17:22:09 GMT

Hi @michael_krall ,

Is this feature already available?