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...

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, 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...

Hi, I tried ingesting a batch file using an SFTP connector on a FOLDER path. Unfortunately, the folder contained an unrelated file and the ingestion failed. The error says: INGEST-1401-400 The row has corrupted data and cannot be read or parsed. Fix the corrupted data and try again. How can I fix (d...