Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
I am doing asset transformation asset Source Target key categoryId sourceDb source parentExternalId parentExternalId updatedDate createdDate externalId externalId isCriticalLine description description tag areaId isActive I don't have all the columns for mapping to target schemaThese are the rest target columns what to do if the mapping column is not there? and where should i add the rest additional columns from source? parentId metadata name dataSetId labels
I have 3 Tablestime series timeseries2asset assetfor asset, i am using this sql query SELECT-- CAST(a.`tag` AS STRING) AS name,-- CAST(a.`description` AS STRING) AS description,-- CAST(a.`sourceDb` AS STRING) AS source,CAST(a.`externalId` AS STRING) AS externalId,-- MAP(-- 'key', CAST(a.`key` AS STRING),-- 'updatedDate', CAST(a.`updatedDate` AS STRING),-- 'createdDate', CAST(a.`createdDate` AS STRING),-- 'isCriticalLine', CAST(a.`isCriticalLine` AS STRING),-- 'areaId', CAST(a.`areaId` AS STRING),-- 'isActive', CAST(a.`isActive` AS STRING)-- ) AS metadata,-- CAST(NULL AS LONG) AS parentId,CAST(a.`parentExternalId` AS STRING) AS parentExternalId-- 7470047 AS dataSetId,-- ARRAY(NULL) AS labelsFROM `CognitePOC`.`assets` afor timeseries i am using this query select cast(`external_id` as STRING) as externalId, cast(`name` as STRING) as name, cast(`is_string` as BOOLEAN) as isString, cast(`unit` as STRING) as unit, cast(`is_step` as BOOLEAN) as isStep, cast(`description` as STRING
What occurs if the data is not appropriately transformed?
while connecting to Powerbi I am getting this error.! access_denied: AADSTS50052: The app is trying to access a service '7ca96- b66-4a2-b4-17a5c3f68ac4'(Cognitedata API: europe-west1-1) that your organization '9c52-3833-46c4-bc-8bc70ee52' lacks a service principal for. Contact your IT Admin to review the configuration of your service subscriptions or consent to the application in order to create the required service principal. Trace ID: f1efa-e663-4167-a1cb-bd8482300 Correlation ID: 7cce22-0f55-420d-801-002d835ed Timestamp: 2024-02-08 09:57:26Z.
How to create IFSDB in events?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
