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

Forum|Forum|3 years ago
February 13, 2023
3 replies
102 views

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

Madina KholmatovaAnswer

Cognite Academy Instructor

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