Possibility of Joining Lookup Data with External CSV in DQL

[Akhil-Jayendran]

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 

[dannemca · Accepted solution]

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...) 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#workflow...) 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-moni...)

[Akhil-Jayendran]

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

[michael_krall]

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. 

[Akhil-Jayendran]

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

[michael_krall]

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