Solved

Asset Transformation

  • 5 January 2023
  • 2 replies
  • 49 views

Badge

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

 

icon

Best answer by Chris Selph 5 January 2023, 23:04

View original

2 replies

Userlevel 2
Badge

Not an expert but this post may be related.

Cognite Hub

Badge

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

Rgds

 

Reply