Skip to main content
Answer

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

  • February 13, 2023
  • 2 replies
  • 63 views
A
Active
Forum|alt.badge.img

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

Best answer by Madina Kholmatova

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

    Anita Hæhre

    2 replies

    Madina Kholmatova
    Seasoned Practitioner
    Forum|alt.badge.img+7
    • Madina Kholmatova
    • Cognite Academy Instructor
    • Answer
    • February 13, 2023

    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

    Anita Hæhre
    Sofie Haug
    A
    Active
    Forum|alt.badge.img
    • Anshul Jain
    • Author
    • Active
    • February 13, 2023

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

    Anita Hæhre
    Terms & ConditionsCookie SettingsAccessibility statement