API to query "select * from datasetName" or any other complex query to get the SQL response in the result ?

[Pradeep-Jaiswal]

is there an API to query "select * from datasetName" or any other complex query to get the response of SQL result ?

[Devyendar]

Yes @Pradeep-Jaiswal, Adobe Experience Platform provides an API for executing SQL queries (including SELECT * FROM datasetName or more complex joins, filters, and aggregations) through the Query Service API.

Here is a detailed document on Query Service API: https://experienceleague.adobe.com/en/docs/experience-platform/query/api/queries

[Pradeep-Jaiswal]

No, this API doesnt return the result of SQL query

[Pradeep-Jaiswal · Accepted solution]

Further investigation shows that this API is only to submit the query and view the status of query, but doesnt return the actual result. To grt the actual results, we need to use external databse connection such as postgress.