COGNITE HUB

Developer and User Community

Join the discussions about delivering apps and data-driven decisions powered by Cognite Data Fusion. Click the + CREATE TOPIC button in the menu bar to start the conversation.

  • 389 Topics
  • 1,207 Replies

389 Topics

Y
Active
Yanzhu YuElkem
asked in Developer and User Community

Coloring last reading time in Grafana

Hi! I want to display the latest time when new data come in to a time-series and color it based on the following rule:-Latest value within 48 hours, shown latest time in green-Latest value more than 48 hours, shown latest time in red(With that rule, the numbers should be in green, green and red in my picture) I struggle to find the correct thresholds to make this 48 hours rule work. It seems to be related to unix time. Have thought about calculate the time difference between current time and latest updated time, but didn’t make it work in time series custom query. Any suggestion would be appreciated. :)

0
Y
Active
5 days ago
V
Active
Viswanadha Sai Akhil PujyamActive
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

0
V
Active
7 days ago
P
Seasoned
Peter QuinnSeasoned
asked in Developer and User Community

How to load PI Asset Framework Event Frames?

I’m investigating the Pi Asset Framework extractor. I see how to bring in assets and I think I see how to get time series data. However, I don’t see how to bring in event frames. I’m not an expert with Pi AF by any means, but it seems like these would map nicely to CDF events. What I don’t see is how to configure the extractor to bring in the event frames. Does it do this? What do I need in the config file to turn it on? Is there additional documentation on the PI AF extractor beyond what’s available here https://docs.cognite.com/cdf/integration/guides/extraction/pi_af/pi_af_configuration?

2
P
Seasoned
5 days ago
B
Active
Basudeba MandalActive
asked in Developer and User Community

Getting AttributeError while using "bootstrap-cli prepare" command

Hi Team, I am trying to use bootstrap-cli to create raw DB, CDF groups and datasets. As per the documentation, I am executing “bootstrap-cli prepare” command before applying “bootstrap-cli deploy”. However I am encountering “AttributeError” .  Could you please help me what can be done to fix this? Following are the few details of the issue that is encountered. Command that I used to run the bootstrap-cli prepare.poetry run bootstrap-cli prepare --idp-source-id f2e5b1ef-e601-46ec-87ec-25f62810ad1fError Snippet:Prepare CDF Project ...Traceback (most recent call last):  File "<string>", line 1, in <module>  File "C:\Users\BMandal2\bootstrap\inso-bootstrap-cli\incubator\bootstrap_cli\__main__.py", line 2365, in main    bootstrap_cli()  File "C:\Users\BMandal2\AppData\Local\pypoetry\Cache\virtualenvs\inso-bootstrap-cli-Jo_B4J-G-py3.10\lib\site-packages\click\core.py", line 1128, in __call__    return self.main(*args, **kwargs)  File "C:\Users\BMandal2\AppData\Local\pypoetry\Cach

7
B
Active
5 days ago
E
Practitioner
eashwar11
asked in Developer and User Community

SharePoint Online - File content extraction

hello Community,Can someone please share the approach (along with code) for extracting files from sharepoint online (xls , with multiple worksheets) and extract the content and load them as RAW tables in CDF.  Is there a direct feature available in Sharepoint file extractor that does this job? Should we use SDK to extend the file extraction and then read the content and insert into tables?.  If we have a large set of files and each containing multiple sheets, it can be hard to process all of them dynamically.  Please advise.

1
roman.chesnokov
Seasoned Practitioner
7 days ago
V
Active
Viswanadha Sai Akhil PujyamActive
asked in Developer and User Community

Uploading P&ID diagrams to CDF Through Python SDK

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

2
A
Practitoner
7 days ago
gedi
Practitoner
gediPractitoner
posted in Developer and User Community

Rollout of the User Profile

[TL;DR]Cognite introduces user profile functionality to collect user information such as name, email, and job title for all CDF users to improve search and sharing capabilities. Administrators can, of course, disable the automatic collection of user information. The functionality will enable us to provide you with granular access controls, collaboration features, and much more in the future. Initially, we support user profiles for projects using Azure AD for authentication. We will add other identity providers later. For more information about how we handle your data, refer to our privacy policy at https://www.cognite.com/en/policy.- Cognite Product TeamAt Cognite, we strive to provide a seamless and efficient user experience for all our users. To achieve this, we have rolled out user profile functionality and started collecting user information, such as name, email, and job title, for all Cognite Data Fusion (CDF) users. This will enable Cognite, 1st-party, and 3rd-party application b

0
gedi
Practitoner
8 days ago
N
NickNew
asked in Developer and User Community

Error when triggering Transform through API

Hi all, I ran into an error when running a transform: instances failed with status 400: Request had 37 constraint violations. Please fix the request and try again. [properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 and 2147483647, properties size must be between 1 a

1
C
Practitoner
8 days ago
Stig Harald Gustavsen
Seasoned
Stig Harald GustavsenSeasoned
asked in Developer and User Community

How do i rotate .pdf previewed in the fusion UI?

Example document from the pdf preview in fusion. There is a rotate symbol, but the rotate symbol does not rotate the image, but it resets the view to “fit to full page”. How do I rotate the documents previewed? or do i need to download it and do it an do it in a native app? And if not so, can rotation functionality in the document viewer? and maybe change to icon of the rotate symbol and also maybe remember the rotation of the page in the viewer aswell? cause there are often documents and diagrams combind in a single pdf file?

0
Stig Harald Gustavsen
Seasoned
10 days ago
V
Active
Viswanadha Sai Akhil PujyamActive
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
Practitoner
8 days ago
Chris Selph
Seasoned
Chris SelphSeasoned
asked in Developer and User Community

SQL Transform Join Error

Executing a SQL Transform joining 2 tables from Raw and writing results to a 3rd Raw table.Perhaps there is a syntax issue? Not sure if it matters but I noticed the error msg omits some backticks like here:'ChemPlant.`Alarms-2-INActive`.EventAssociationID' there is no backtick before Event… Thank you.SELECT `ChemPlant`.`Alarms-2-INActive`.`EventID`, `ChemPlant`.`Alarms-2-INActive`.`SourceName`, `ChemPlant`.`Alarms-1-Active`.`EventTimeStamp`, `ChemPlant`.`Alarms-2-INActive`.`EventTimeStamp` AS AlarmOffTime, `ChemPlant`.`Alarms-2-INActive`.`Message`, `ChemPlant`.`Alarms-2-INActive`.`Active`, `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID` as key, `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID`FROM `ChemPlant`.`Alarms-2-INActive` INNER JOIN `ChemPlant`.`Alarms-1-Active` ON `ChemPlant`.`Alarms-2-INActive`.`EventAssociationID` = `ChemPlant`.`Alarms-1-Active`.`EventAssociationID`Error Message:Cannot resolve 'ChemPlant.`Alarm

2
Chris Selph
Seasoned
13 days ago
V
Committed
vidhi.c.jainCommitted
asked in Developer and User Community

Facing issue while writing test cases using monkey_cognite_patch.

Hi Team, We are working on a POC , where we need to create unit test cases where we are facing different issues .For reference we are using code from Cognite HubBelow attaching our code and output expectations .Please help with the approach to resolve this issue ts_retrieved = [    TimeSeries(    id= 3973245479016710,    external_id= "Brazil:3W:Well-Bore-19B_target_throughput",    name= "Brazil:3W:Well-Bore-19B_target_throughput",    is_string= False,    metadata= {},    unit= "Barrel",    asset_id= 3332326574821917,    is_step= False,    description= "target volume for a oil well bore",    security_categories= [],    data_set_id= 8739280581150161,    created_time= "2023-05-02 09:37:04.944000",    last_updated_time= "2023-05-02 09:37:04.944000")]@pytest.fixturedef cognite_client_mock():    with monkeypatch_cognite_client() as client:          client.assets.retrieve().time_series().get().return_value = ts_retrieved        return client   Method code          ts_data = c.assets.retrieve(

3
H
Practitoner
8 days ago
V
Active
Viswanadha Sai Akhil PujyamActive
asked in Developer and User Community

.csv file Ingestion into CDF using Python SDK

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

3
V
Active
14 days ago
T
Active
tibor.vanczaActive
asked in Developer and User Community

Cognite Data Fusion - ANSI support for Function Logs

Are ANSI escape sequences planned to be added to the Cognite Function logs? For now, it seems to be impossible to make the text bold or change the color of the text inside the function logs. 

2
T
Active
13 days ago
E
Practitioner
eashwar11
asked in Developer and User Community

CDF Extractors

I have to build two 2 types of extractors.1. PI extractor to connect to the PI server and fetch the data and ingest into CDF2. SharePoint online - Extract data from files present in SharePoint online and ingest into CDF. I wanted to know the construct in building the extractors. Mainly wanted to account for scenarios where the PI server is not available and PI extractor is unable to fetch the data from the pipeline. How to handle these kinds of situations and incorporate them in the code while building the extractor. Also, how to handle monitoring while performing extractor. Are there some sample code repos that can be referenced for getting complete idea for building extractors.    

9
roman.chesnokov
Seasoned Practitioner
15 days ago
A
Committed
Alex NarayananCommitted
asked in Developer and User Community

Read excel files (spreadsheet extractor?)

 Appears to be an obvious question, may have been asked before. Just wondering if there is an extractor available to read the spreadsheet files and load it into raw/staged data. The Excel can contain multiple spread sheet and perhaps with configuration each of that spreadsheet and its columns can be mapped to the staged tables/columns? 

3
J
Seasoned Practitioner
15 days ago
P
Committed
Paramale AratiCommitted
asked in Developer and User Community

Need to co-relate Events with Timeseries

HI All, I am looking to help in order to display timeseries and events co-relation in Power BI. I want to show when the event occurred in timeseries chart on specific event time.Any inputs would be appreciated! Regards,Arati 

10
A
Seasoned Practitioner
5 days ago
A
Committed
Ankita ManeCommitted
asked in Developer and User Community

Performance issue for event retrieval

We are having performance issues for event retrieval whenever there are more events even below 500.Can you help me to understand how partitioning can be done or pagination, as we need to perform operation for each event after retrieval and send it as a api response.I tried below:  for unstructre_insight in client.events(type="Insight", limit=None,partitions=10):     (“do something with unstructre_insight in each partition in parallel to reduce response time”)I observed that if there are 64 events, then all 64 events are retrieved in one execution, how we can get one partition at a time and perform something for first partition in parallel while retrieving second partition to reduce time.

4
D
Practitoner
6 days ago
S
Seasoned
Sonali Vishal PatilSeasoned
asked in Developer and User Community

By looking at the message it doesn't seems to be like error even though its a error

 

4
Anita Hæhre
Seasoned Practitioner
6 days ago
S
Committed
Shah AyushiCommitted
asked in Developer and User Community

Issue with cognite events

Hello Team,i have deleted some of the events from cognite but still i can see its present and when i click on that then it’s giving resource not found. can anyone please help what can be the issue.and also I am trying to delete all that also not able to delete due to previous issue.PFA. 

3
D
Practitoner
29 days ago
E
Practitioner
eashwar11
asked in Developer and User Community

migrating business logic from excel macros to CDF

Hi, There are raw data files which are used to perform computations (yield tracking measures ) that uses tons of input data attributes to compute the metrics. Currently, VBA macros (excel) is used to perform the calculations and publishing the outputs. WE have to transfer the computation within CDF. Can we use cognite functions in this regard?. Is there a way to create python script that can perform these calculations within the CDF. If not, should we create some external cloud based construct like Azure functions or Lambda routines?Please share some examples are snippets that can help to perform this project task.

5
E
Practitioner
16 days ago
G
Committed
Gargi BhosaleCommitted
asked in Developer and User Community

Getting 408 response on trying to retrieve data from 1) GraphQL explorer. 2) Data managment tab on the fusion UI

Hello team,We have ingested 15671 instances on an indexed model.While trying to view the data on the data managment tab on the fusion UI, we are getting 408 error.When we try to query the data through GraphQL, even if we apply limit of 1 we are getting the same response.Error message: {  "title": "",  "message": "Client request(POST https://westeurope-1.cognitedata.com/api/v1/projects/slb-pdf/models/instances/query) invalid: 408 Request Timeout. Text: \"{\n  \"error\": {\n    \"code\": 408,\n    \"message\": \"Graph query timed out. Reduce load or contention, or optimise your query.\"\n  }\n}\""}Details of the model:space: gb_MovieDMdata model:  Avocet data model

1
D
Practitoner
26 days ago
R
Committed
rsiddhaCommitted
asked in Developer and User Community

Cognite Infield 1.0 Desktop version display limit on number of characters in tag names

Hi  In the current Cognite Infield desktop version, is there a limit on the number of characters for the synthetic tag names, before it displays “….” at the end? If so, what is the limit?We didn’t observe this in the mobile version, which seems to display full tag names that are longer than 40 characters completely (Some of our tags are ~40-50 characters long). But were curious with the desktop version, when the synthetic tags go “...” at the end and seems to hit a limit?Also, assuming this wouldn’t be a case in Infield 2.0, where there is a lot of expected improvement in space/layout. Thanks 

1
D
Practitoner
1 month ago
M
Maysaa AlmatnyNew
asked in Developer and User Community

cognite-charts issue to access (function section)

​​​​​  I am able to browse ds-basics ,  cdf-fundamentals        ….etc

4
D
Practitoner
19 days ago
G
Gangula RadhaNew
asked in Developer and User Community

query in timeseries datapoints

while using python sdk 5.10.5 and downgrade versions getting issue like 'CogniteClient' object has no attribute 'datapoints'.With latest version getting error while hitting micro service. Please find below  file for your reference.

1
D
Practitoner
1 month ago

Badge winners

  • Cognite Data Fusion Fundamentals
    Hesam Salehihas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Data Fusion Fundamentals
    Dzmitry Holubhas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Data Fusion Fundamentals
    poshas earned the badge Cognite Data Fusion Fundamentals
  • Cognite Data Fusion Bootcamp
    wkhalidhas earned the badge Cognite Data Fusion Bootcamp
  • Cognite Data Fusion Fundamentals
    Varvara Vlasyukhas earned the badge Cognite Data Fusion Fundamentals
Show all badges
Terms & ConditionsCookie Settings