Skip to main content
Solved

Transformation Run Error


Chris Selph
Seasoned
Forum|alt.badge.img

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

 

Best answer by Gaetan Helness

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

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img

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


Chris Selph
Seasoned
Forum|alt.badge.img
  • Author
  • Seasoned
  • 26 replies
  • March 1, 2023

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


Forum|alt.badge.img

Glad to hear. Thanks for the feedback


Reply


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings