Topics started by Viswanadha Sai Akhil Pujyam

10 Topics

V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Relationships Between Assets and Timeseries

We are having a multilevel asset hierarchy in cdf, and ground level assets are only having timeseries linked.we are trying to create Relationships between every parent asset and its child asset’s Timeseries.we used python sdk code snippets to do this. Which are been attached to this for your reference.In python sdk, after running the python relationship code, it is showing relationships are established. But in UI it is not showing from Assets, But we are able to see under Timeseries.even after we tried interchanging the Source and target between assets and timeseries, same result.one unique observation is that we could see the relationship established just for 1 asset which is having 3 timeseries linkage. rest others are not showing(they have more than 20 relations, even 500 for root asset.)we would like to know are we following correct manner, or any restrictions are from CDF tool. plz help us in this regard.from cognite.client import CogniteClientfrom cognite.client.data_classes impo

5
C
Seasoned Practitioner
7 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in How-To Guides

Uploading P&ID diagrams to CDF Through Python SDK [Community Contributed]

hello Community,can anyone help me understand how to upload P&ID diagram files to CDF, Using Python SDK.

4
Dilini Fernando
Seasoned Practitioner
9 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Regarding cdf's DataBase and usage of Spark SQL

Hello Community,cdf stores the data in cloud, could  anyone know what is the database / database structure being used,and any reason for using Spark SQL for transformations.

4
Dilini Fernando
Seasoned Practitioner
5 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in How-To Guides

.csv file Ingestion into CDF using Python SDK [Community Contributed]

hello community, can anyone tell me is there any way to upload .csv files to CDF using Python SDK.

4
Dilini Fernando
Seasoned Practitioner
9 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Triggering to cognite functions

Hello Community,we have a option scheduling in cognite functions to run those functions periodically. But is there any way to trigger Cognite function when a particular event occur.thank you

3
Dilini Fernando
Seasoned Practitioner
10 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Facing Issue while transforming Events.

Below is the screenshot of error , during running transformation. Below is the Query used to transform, Preview is working fine. But During the Transformation Run, it is giving above error, saying start time values  cannot be greater than endTime values. But According to Query it shouldn’t be the case. plz suggest solution. Attached Sample Data(data sheet) For your reference.select `Notification_no` as externalId, `startTime` as startTime, `endTime` as endTime, `description` as description, `type` as type, 1118188859138991 AS dataSetIdfrom(select concat('NO_',QMNUM) as `Notification_no`, --to_timestamp(QMDAT,'M/d/yyyy') as `startTime`, CASE WHEN RIGHT(MZEIT, 2)='AM' THEN TO_TIMESTAMP(CONCAT(QMDAT,' ', SUBSTRING(MZEIT, 1, LENGTH(MZEIT) - 3)), 'M/d/yyyy h:mm:ss') ELSE TO_TIMESTAMP(CONCAT(QMDAT,' ', SUBSTRING(MZEIT, 1, LENGTH(MZEIT) - 3)), 'M/d/yyyy h:mm:ss') + INTERVAL 12 HOURS END AS `startTime`, CASE WHEN isnull(QMDAB) THEN

2
J
Seasoned Practitioner
8 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

SQL Transformation Error

Facing a Critical Error while running the below sql code.SQL Error:(Attached the Raw input Excel for your reference.)Text '9/28/2022' could not be parsed at index 0 | code: 400 | X-Request-ID: 14d6d486-1958-99a3-b552-d19e5937bf82 -- Loads SAP Work Order as events. Data is already contextualized with assets using functional location. An inner join with CDF Assets is used to ensure only work orders for assets already loaded is ingested.select concat('WO_', `Order Number`) as externalId, to_timestamp('Basic Start Date','M/dd/yyyy') as startTime, to_timestamp(`Basic Finish Date`,'M/dd/yyyy') as endTime, 'Work Order' as type, array(`Asset ID`) as assetIds, 'SAP PM' as source, `Description` as description, `Order Type` as subtype, 2395436788557957 as dataSetId, map_concat( to_metadata_except(Array( -- "Order Number", "Basic Start Time", "Basic Start Date", "Basic Finish Date", "Asset ID", "Description", "Order Type"), *) -- map("Priority",

2
Dilini Fernando
Seasoned Practitioner
8 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

help with cdf Relationship resource type

I am trying to establish Parent-Child relationships between two types of events ingested and transformed in CDF which are Workorders and Maintenance Notifications. I have two different datasets for each where the Raw data is staged and have also given corresponding labels (Work_order, Notification) for dataset and later these workorders and Maintenance notifications are linked to Assets in CDF using transformations. Now I need to establish the relationship between the workorders and Maintenance notifications. Although I went through the Documentation for relationship ( Relationships | Cognite Documentation) not able to get the hold of it. Any reference SQL for how relationships are established would also do.

2
C
Seasoned Practitioner
7 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Require Info Regarding Cognite File Extractor

hello community,I need to work Cognite File Extractor, But found very limited resource on documentation. can anyone please provide any available resources regarding that like knowing completly how to use it, it’s configuration etcThank you

1
M
Practitioner
11 months ago
V
Committed
Viswanadha Sai Akhil PujyamCommitted
asked in Developer and User Community

Data in Infield

hello Community,While logging into cognite infield, there is a option to sign in with project name.so that project name is the project created in CDF?in documentation, we can see Infield runs on CDF, Which means CDF project is only way to get data into infield? or any other ways we can get data into infield?is there way to access infield from python sdk?Thank you

1
K
Seasoned Practitioner
10 months ago

Badge winners

Show all badges
Terms & ConditionsCookie Settings