I got following use case that I am not sure if that’s something I can do with Looker
When user click on cell in table that contains aggregated data (requirement is : now he want’s to see some raw data that were used during building this aggregation - full raw data are stored in separate datasource)
Aggregated column displayed to user :
Aggregated Column - contains what user wants to drill down to see raw data:
Assume that for calculation of this “Aggregated Column” row 1
we have following ids : 5,6,7 - you can see 3 because aggregation was simple count
Now ids : 5,6,7 - user want to see more information that are stored in separate source only available by some rest api and is not possible to place them in any datasource available for Looker
I can see here
but it only support drill down fields to construct SQL .
Is this something I can try with :https://docs.looker.com/data-modeling/extension-framework/extension-framework-intro ?
Not sure if possible please advice