I’m trying to run the asset transformation. however, after creating the query I have this error.
An error occurred when running this query
"Verify that the 'Patricio1974.assets' relation exists | code: 400 | X-Request-ID: fe28e7d2-397d-9e68-bea4-a1c0979a4b4f"
Find below the query:
SELECT
concat('Patricio1974:', loc) as externalId,
IF(
parent_loc = ''
OR parent_loc IS NULL, '', concat('Patricio1974:', parent_loc)) AS parentExternalId,
CAST(lastUpdatedTime AS STRING) AS name,
to_metadata(*) AS metadata,
description AS description,
4577431473554653 AS dataSetId
FROM
`Patricio1974`.assets