Skip to main content
Solved

Asset Transformation


Forum|alt.badge.img

I’m trying to run the asset transformation. however, after creating the query I have this error.

An error occurred when running this query

"Verify that the 'Patricio1974.assets' relation exists | code: 400 | X-Request-ID: fe28e7d2-397d-9e68-bea4-a1c0979a4b4f"

Find below the query:

SELECT
  concat('Patricio1974:', loc) as externalId,
  IF(
    parent_loc = ''
    OR parent_loc IS NULL, '', concat('Patricio1974:', parent_loc)) AS parentExternalId,
  CAST(lastUpdatedTime AS STRING) AS name,
  to_metadata(*) AS metadata,
  description AS description,
  4577431473554653 AS dataSetId
FROM
  `Patricio1974`.assets

 

Best answer by Chris Selph

Not an expert but this post may be related.

Cognite Hub

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

2 replies

Chris Selph
Seasoned
Forum|alt.badge.img
  • Seasoned
  • 27 replies
  • Answer
  • January 5, 2023

Not an expert but this post may be related.

Cognite Hub


Forum|alt.badge.img

Thanks, Chris, I found the issue of having the asset named differently. I changed that and it worked.

Rgds

 


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