Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
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
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"
Best answer by Madina Kholmatova
Hi
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
1 person likes this
+7Hi
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
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.