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
+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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.