Enable the "Back Fill" option in your dataflow, which will ingest data from the date it was ingested last. Keep in mind that all the missing file should be available in your source SFTP location. hope this will help! 

for better ingestion of data through query service I think you need to have Data distiller SKU purchased.https://experienceleague.adobe.com/docs/experience-platform/query/data-distiller/overview.html?lang=enThanks,HariP

I think you can use ANY keyword in your where clause, SELECT  * from tablename where attribute_name = ANY('{Seth, Mike, Joseph, Joe, John}')this should scan the array objects with the specific values.Thanks,HariP 

below API gives the schema payloadhttps://platform.adobe.io/data/foundation/schemaregistry/rpc/export/:RESOURCE_IDthe resource_id is your schema ID.please refer this linkhttps://experienceleague.adobe.com/docs/experience-platform/xdm/api/export.htmlThanks,HariP 

Please use the following payload format {"header": {"schemaRef": {"id": "https://ns.adobe.com/orgname/schemas/d44a7fe25c90b7f739ae5b1dc4878bdf647687e","contentType": "application/vnd.adobe.xed-full+json;version=1"},"imsOrgId": "1223242424@AdobeOrg","datasetId": "1112319c37dba91c07b08f0d"},"body": {"...

The profile collapse issue happening when more than 150 identities, how to avoid these kind of profile collapse issues, what is the best practices?

Description -Why is this feature important to you - The biggest challenge for the customers who are using Adobe experience platform is to manage the active profiles only in the profile store, to delete the profiles we use profile delete entity API, which is cumbersome process, the below idea will be...

Ingestion wont convert the string automatically, during the ingestion there is option to add calculated field, using the data prep function and then assign the schema field to the calculated fieldsExample:Syntax: date(DATE, FORMAT, DEFAULT_DATE) e.g.date(“2019-10-23 11:24”, “yyyy-MM-dd HH:mm”, now()...

I am trying to create the XDM individual Prospect schema and setting up the primary key, in the list of name spaces dropdown not showing any identity name spaces to select, due to that I am not able to enable the profile for the schema , can anyone please help me to fix this issue?