Solved

Transformation Run Error


Userlevel 2
Badge

I have a transformation that is to write to a new dataset as seen here:

SELECT
concat('CWS:',loc) as externalId,
IF(parent_loc='' OR parent_loc IS NULL, '', concat('CWS:',parent_loc)) AS parentExternalId,

CAST(lastUpdatedTime AS STRING) AS name,

to_metadata(*) AS metadata,

description AS description,

7089382776719091 AS dataSetId
 
FROM `CWS-Assets-DB`.`CWS-Assets-Tbl`

 

The Preview seems to work fine.

When RUN: I get following error:

Request with id 96f4a082-9dde-9b41-8065-0b3cf0923197 to https://az-eastus-1.cognitedata.com/api/v1/projects/ra-istc-sandbox/assets/byids failed with status 403: Resource not found. This may also be due to insufficient access rights..

The permissions on the dataset for my user group is 

raw:readraw:writeraw:listdatamodels:readdatamodels:writedatamodelinstances:readdatamodelinstances:writedatasets:readdatasets:writedatasets:ownertimeseries:readtimeseries:writefiles:readfiles:writeevents:readevents:writesequences:readsequences:write3d:read3d:create3d:update3d:deletetransformations:readtransformations:writefunctions:readfunctions:writeextractionpipelines:readextractionpipelines:writeextractionruns:readextractionruns:writeextractionconfigs:readextractionconfigs:writeentitymatching:readentitymatching:writeannotations:writeannotations:readannotations:suggestannotations:reviewsessions:listsessions:createprojects:listprojects:readgroups:list

Any ideas are appreciated.

Chris

 

icon

Best answer by Gaetan Helness 1 March 2023, 19:01

View original

3 replies

Userlevel 3

I guess you are trying to create assets.

From the error message, you are missing permissions to read/write assets. 

You would need to add that capability

Userlevel 2
Badge

Perfect! I had my admin Add those permissions to my group and it worked. Thank you for a quick reply!

Userlevel 3

Glad to hear. Thanks for the feedback

Reply