set drop_system_columns not working

[Pradeep-Jaiswal]

this from https://experienceleague.adobe.com/en/docs/experience-platform/query/use-cases/data-exploration

it says that set drop_system_columns=false;

would show metadata columns _acp_system_metadata and _ACP_BATCHID

when i run below query, it works fine
select * from datasetName

but when i run this query,
set drop_system_columns=false;
select * from datasetName

it give me following error
Cannot read properties of undefined (reading 'map')

datasetName really dont have any field with dataType map.

[mustufam5967803]

@Pradeep-Jaiswal ,

If you check the logs of Query Services, you will see that this is not an error. The result has been successfully returned to the client.

It is unclear whether this is a limitation of AEP Query Services, but the same results can be fetched using a Python script or DB Visualizer.

The document which you are referring also has screenshots from DB Visualizer.

[Pradeep-Jaiswal]

which API to be used to get the adhock query response using python ?

[Sukrity_Wadhwa]

Hi @mustufam5967803,

Can you please help @Pradeep-Jaiswal further with their follow-up query?

Thanks!

[Pradeep-Jaiswal · Accepted solution]

Finally i found the wok around syntax, as document is slightly misleading

select _acp_system_metadata.*, * from datasetName

give me those hidden column in the output