On your third note of above reply i.e.
Fetch the record details of the profile.
I am able to fetch the details of single profile using select query but when I try to delete a profile using delete query
It is throwing an error (ErrorCode: 42601 Syntax error encountered. Reason: [Invalid command!])
Can we use queries to fetch segment's all attributes in AEP ?.
and I also find some auto suggested table name in Queries like (segment_ingestion_dataset, segment_export_dataset)
where does it come from as there is no such dataset present with this names.