Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
I run this query per the instructions and I get the following preview errorSELECTconcat('Cory1965:',loc) as externalId,IF(parent_loc='' OR parent_loc IS NULL, '', concat('Cory1965:',parent_loc)) AS parentExternalId,CAST(lastUpdatedTime AS STRING) AS name,to_metadata(*) AS metadata,description AS description,Cory1965-AvevaNet AS dataSetId FROM `Cory1965`.assets Error An error occurred when running this query"Cannot resolve 'Cory1965' given input columns: [zcb2dd7b7c3704ca2a0d8659e146db2f9.WMT_SYSTEM_ID, zcb2dd7b7c3704ca2a0d8659e146db2f9.WMT_TAG_ID, zcb2dd7b7c3704ca2a0d8659e146db2f9.description, zcb2dd7b7c3704ca2a0d8659e146db2f9.key, zcb2dd7b7c3704ca2a0d8659e146db2f9.lastUpdatedTime, zcb2dd7b7c3704ca2a0d8659e146db2f9.loc, zcb2dd7b7c3704ca2a0d8659e146db2f9.name, zcb2dd7b7c3704ca2a0d8659e146db2f9.parent_loc]; line 11 pos 0;\n'Project [concat(Cory1965:, loc#23978949) AS externalId#23978912, if (((parent_loc#23978951 = ) OR isnull(parent_loc#23978951))) else concat(Cory1965:, parent_loc#2397
In grafana, we want to display total of all timeseries data-points for all assets connected to particular asset for which we are passing query like this:ts{assetSubtreeIds=[{id=$Org4}], name='oil-production-rate'}where value of $Org1 is coming from dashboard variable.and since cognite grafana plugin does not handle cursor api responses and synthetic timeseries api have some limitation in returning 10k records only in a request, to reduce number of data-points, we are trying to use aggregation: ‘sum’ and granularity: ‘30d’ since there could be more than 10k data-points. But its is throwing error saying “sum” is not valid aggregation type of synthetic timeseries. Any reason why “sum” aggregation is not supported for synthetic timeseries.(screenshot attached)
Unable to deploy cognite function. “Upload” button function is not getting enabled.This was working till last week.
Hi, what is required as access rights to be able to uplad a function ?
Already have an account? Login
Enter your username or 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.