Hi @Parvesh_Parmar ,I tried activating UPSERT for the dataset. Same error unfortunately. 

Hi, I'm trying to push an UPDATE value to a specific field in my dataset using Data distiller. Something like  update my_datasetset _tenant.customfield.occupation = 'updated_occupation'where id = 'VADER00000000000000000000000000004200';This returns me this: ErrorCode: 42601 queryId: <error_id> Synta...

Hi  I keep getting into this error where I try to access query service and the "Initializing connection..." message in the terminal never disappear and therefore I cannot run queries. I tried clearing the cache, reloading the page multiple times and restarting the browser, but nothing works. This ha...

@brekrut in order to rank something I have to have a field to rank it over. My question is how can I access such value. Either something as Batch_id or CreatedDate that would allow me to distinguish one batch from another. I do not have access to such field at the moment using the query service.Than...

Hi, I'm trying to query a dataset using the query service. I would like to query only the latest batch data received. We are using a fully custom schema (_tenant...). I've tried accessing the system-generated such as createdByBatchID, but it seems that it is not accessible in the dataset.ex.SELECT c...

Hi @abhinavbalooni, After carefully reviewing the issue. We realized that the issue was indeed at the source which was sending NUMBER 0.0 instead INTEGER 0.  The initial confusion was due to the fact that AEP is showing incomeAmount = 0 in the error log (as shown in my previous API response screensh...

Hi @arijitg, I replied in the above comment

Hi @abhinavbalooni ,The field value is 0.  As for the failed payload, it looks like this (+ error message)Our schema is fully custom.Thanks 

Hi, I got the following error with streaming data coming from an HTTP API connector:The message cannot be validated due to the data type error. Expected type: Integer, found: Double. When I looked at the failed batch, I see that the JSON field value associated with the error is 0. How is 0 not an in...

We did not activate the partial ingestion. This would have solve our problem indeed @abhinavbalooni .  I was more curious on ways to interact with failed file. Where are they kept in the system?I can see that they failed, but can we access/retrieve them in any way?  Thanks