Skip to main content
Answer

Asset Transformation

  • January 5, 2023
  • 2 replies
  • 67 views

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

2 replies

Chris Selph
Practitioner
Forum|alt.badge.img
  • Practitioner
  • 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