I got the following SQL statement:
SELECT DISTINCT branchID, branchName
FROM ds_sucursales
WHERE branchName IS NOT NULL
LIMIT 5
ds_sucursales is a dataset based on a branch type schema. The statement was saved on Query Service UI with the ID 4aaf637a-0712-4342-b549-4e77c0382057.
I want to execute the statement using the Accelerated Queries API endpoint on Postman, so I follow the Accelerated Queries API Endpoint Doc.
I put the request headers. Likewise, I include the Postman generated headers, that include Accept, Accept-Encoding, etc.
![AccelQueries1.png AccelQueries1.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/59073i8262E474FB15F861/image-size/large?v=v2&px=999)
Then, I put the request body:
![edgar_herrera_0-1687035833037.png edgar_herrera_0-1687035833037.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/59074i06A0C8F41F9B251A/image-size/large?v=v2&px=999)
I get ACCELERATED_STORE_DATABASE and ACCELERATED_STORE_SCHEMA using the following SQL statement:
SHOW SCHEMAS
Query response showed two databases and two schemas:
DATABASE | SCHEMA |
qsaccel | profile_agg |
cjm_qsaccel | cjm_reporting_aggs |
I built the dbName using the following pattern:
{SANDBOX_NAME}:{ACCELERATED_STORE_DATABASE}.{ACCELERATED_STORE_SCHEMA}
When I try to send the request, I get the error:
![edgar_herrera_1-1687036139181.png edgar_herrera_1-1687036139181.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/59075i714982B0AA73F502/image-size/large?v=v2&px=999)
I also tried to build the dbName using the another database and schema, but it doesn't work. Likewise, I tried to build the dbName using the following pattern:
{SANDBOX_NAME}:{ACCELERATED_STORE_DATABASE}:{ACCELERATED_STORE_SCHEMA}
I tried this one because request sample uses : instead of . on dbName. But when I send the request I get a 500: Internal Server Error:
![edgar_herrera_2-1687037068428.png edgar_herrera_2-1687037068428.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/59077i32031E4E26CEF521/image-size/large?v=v2&px=999)
What am I doing wrong?
Thanks in advance