Replies posted by Salma Ghafoor

2 Replies

E
Seasoned Practitioner
Eniko FarkasCognite Academy Instructor
posted in Academy Discussions

CDF Fundamentals Discussion

Thanks Sofie! That did the trick

115
Brad Downen
13 days ago
E
Seasoned Practitioner
Eniko FarkasCognite Academy Instructor
posted in Academy Discussions

CDF Fundamentals Discussion

I’ve uploaded assets.csv into a dataset and trying to run the SQL script to create the assets but am getting the error Request with id 87b97f14-7c9b-94b9-9e1f-129e2ed18250 to https://api.cognitedata.com/api/v1/projects/cdf-fundamentals/assets failed with status 400: Reference to unknown parent with externalId Salma:23-PT-92535.The query runs fine in Preview mode but fails to run. Funny thing is it processes a different amount of rows each time it runs.Here’s the query I’m using:SELECT  concat('Salma:',loc) as externalId,  IF(parent_loc='' OR parent_loc IS NULL, '', concat('Salma:',parent_loc)) AS parentExternalId,  CAST(lastUpdatedTime AS STRING) AS name,  to_metadata(*) AS metadata,  description AS description,  6295592107437051 AS dataSetIdFROM `Salma`.assetsAny ideas what’s going wrong?

115
Brad Downen
13 days ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings