Solved

An error occurred when running this query "Verify that the 'Anshul1994.assets' relation exists | code: 400 | X-Request-ID: 9082eaf1-b777-95d5-a79d-abb12774649c"

  • 13 February 2023
  • 2 replies
  • 46 views
A
Rank
Badge

I am having the same issue while running the query

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

CAST(lastUpdatedTime AS STRING) AS name,

to_metadata(*) AS metadata,

description AS description,

7836510854795177 AS dataSetId

FROM `Anshul1994`.assets

icon

Best answer by Madina Kholmatova 13 February 2023, 19:45

View original

2 replies

Madina Kholmatova
Rank
Userlevel 4
Badge +5

Hi @Anshul Jain, 

Have you created your database and table according to this lesson? https://learn.cognite.com/path/cognite-data-fusion-fundamentals/working-with-cdf-integrate/865133

Please make sure you have a database named Anshul1994 and table named assets, and then please rerun the query. 

Let me know if you have any other issues! 

Best regards, 
Madina

A
Rank
Badge

Thank you Madina , It resoved , I was giving the wrong DB name 

Reply


Terms & ConditionsCookie Settings