Community Discussions

Dear Power and Renewables community members,We're evolving! The Power and Renewables group is closing, but exciting new groups are on the horizon. We'll be launching early adopter groups for our power and renewable industry domain specific offerings.Don't worry about losing valuable content - everything shared here will be available in our community knowledge base. Stay tuned for invites to our early adopter groups, and in the meantime, we hope you'll continue the discussions with everyone in our broader community. Thank you for being a part of the Cognite Hub Community. Your expertise is essential, and we're eager to continue the journey with you in our community spaces.Best,Ingar Beck Landet, VP Power & Renewables in Cognite

Hi I have an application to read data from and I have two options either to use ODBC or OPC UA directlyWhat are the benchmarks or limitations when it comes to aboveI have 30,000 data points to read with sample time of 1s and 5s and 10s 

Hi Team,I’m using OPC UA Extractor to extract time series data from Honeywell PHD source system.I have configured history in configuration for backfilling for 30days.But, i can see more historian data than expected please find the screenshot below.I have used following configurations in history. start-time: 0 end-time: 30d-ago max-read-length:30d  Let me if this configuration is correct for fetching 30days previous day.Please provide configuration if above one is wrong.

Hello! Is there a repository where the Aker BP open data is available for direct download? ( asset hierarchy, work orders, P&ID file)? 

Hello everyone,First off, big thanks to everyone here. You've been super helpful as I've been figuring things out with Cognite. I've hit a bit of a snag though, and I'm hoping someone here might have an answer.Check out the attached screenshot. It's got a 3D view of an asset and one of its time-series. Now, I've also got this other chart that shows the time-series for the asset, along with some predictions and models I’ve been playing with. (See Below) Here's my question: When I'm looking at the 3D view of the asset, is there a way to see this full chart with all the models and predictions instead of just one time-series? I've looked all over the forums and tried searching everywhere, but I can't find an answer. If someone could help out, that'd be awesome. Thanks so much for always being there and helping out. I'm excited to show off what I've been working on with Cognite! Cheers, Vishnu Iyengar

I’m getting this error after running the Timeseries transformation:  It is relevant to mention that the preview of the SQL query looks fine, prior tu actually running it, looks fine (data can be find here):  Many thanks in advance for your comments. Luis

what is cybersecurity or data governed for moving data from Datasource in customer site to CDF ?

Hi everyone,We are working on a new project related to video analytics and would like to know if there are any features available at Cognite that we can count on as possible components of the solution, such as Cognite Cluster for running object detection/classification, object tracking, partial video events, and overlaying video output.

 Hi,I have one basic question on Cognite connectivity with PBI. Currently, I see, I have only one option as imported connection. Is there any way we can pull LIVE data from Cognite? We would like to have real data coming from cognite connected thru Power BI  if that’s possible. Thanks in advance!

Hi. I’ve found a few references to “unit catalog”, “target unit”, and “target unit system” in the python sdk documentation. However, I wasn’t able to find a more complete description of this functionality. I assume it is there to assist with unit conversion, simliarly to what you can do in Charts? Can this also be used with custom units, that are not in the Charts standard units?Is documentation/explanation of this feature available somewhere?

Hi! Recently we received a warning from Grafana, that AngularJS-based plugins (incl. CDF data source) are going to be deprecated by the end of summer 2023 and AngularJS functionality will be removed in the Grafana v11. We tried updating to the latest version (3.1.0) but the warning is still there. https://grafana.com/docs/grafana/latest/developers/angular_deprecation/  Provided we update the plugin on time, is there still reason to worry about it? Thank you!

Hi all!This is an update from the Data Modeling team on an upcoming change.We are making a change in how we treat the absence of data in an object when making a query in a data model graph. Currently, if an instance has no value in an optional property, it will not be included in the response to a query for instances where that property is NOT some value.As an example, consider a field “completionYear” which is not always populated - a query for instances where completionYear is NOT “2023” would return only instances where completionYear has a value, and that value is not 2023. Instances where that property is not set would not be included.We intend to change this behavior such that instances without a value in that property would be included in the query reseponse, as this behavior is more in line with the expected behavior in most cases. This also resolves an inconsistency with the search and aggregation queries where this behavior is already happening.We consider this a bug fix, so

As Data Engineer I need access to GraphQL through python SDKto modify Data Models GraphQL: to update versions of imported views from different Data Models to read Data Models GraphQL: to parse specific info that I can not get through python SDK. For example check if view was imported what the source of imported view

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.

Can someone revert with proper procedure for using any of the cognite data fusion API using postman 

Hi Team, From the cdf-fundamentals training, I have mapped required details but data is displaying as a linear format not trends.   

Hi there,Are there any plans to make the PI Extractor open source, following the same approach as opcua-extractor-net?

Hi! We have made the following updates available for Workflows.Optional TasksDefining non-critical tasks in a workflow as optional, meaning that in the event of a task failure, the workflow itself should continue, has been a much requested feature. You can now set the policy for how to handle failures and timeouts for each task in a workflow. By default, the workflow will fail if a task fails (after retries) or if the task times out. Alternatively, you can set the parameter to skip the task in the event of a failure or timeout (after retries). This means that the workflow execution will continue even when the task does not complete successfully. The feature is documented in the API specififcation here (navigate items > workflowDefinition > tasks > onFailure). Concurrency Policies for TransformationsIf a job is already running for a given Transformation in CDF, a new job cannot be started concurrently (fails with error message “A job already runs for this transform”). To better

Hi Community Members!We’ve recently published a cloud-based Virtual Flow Metering (VFM) system tailored for a late-life well with high water cuts. This solution employs a hybrid physics-data approach, delivering precise and near-real-time estimates of water production per well in gas fields.Link to the full article: https://www.sciencedirect.com/science/article/pii/S277250812300042X Enhancing Production OptimizationIn the oil and gas production domain, understanding the fluid composition and production rates of multiphase operations is crucial for effective planning and optimization. With wells yielding a diverse mix of oil, gas, and water, often with varying compositions, ensuring accurate measurements is essential for maximizing production efficiency. Ratios change in time, and this gets more and more important as the water cut grows in the late part of a water flooded well life. This article explores how Virtual Flow Meters (VFMs) offer a cost-effective alternative to traditional me

Hello everyone,I'm relatively new to using Grafana, and after reading this post (Cognite Hub) on Cognite Hub, I've come to understand that Alerts in Grafana may not be compatible with the CDF connector. Please feel free to correct me if I'm mistaken.Considering this, I'm wondering if anyone has a good setup for monitoring the data coming from the CDF connector. I have around 900 time series, and listing all of them is not very efficient. Additionally, I'm having trouble figuring out how to write an SQL query to count the time series that have a timestamp older than, let's say, 3 hours. this could be a way, to count data not coming in. Would anyone be willing to share their setup or offer any tips?Thank you in advanced :) 

In September, we embarked on an incredible journey with our partners at CNTXT Academy, bringing Cognite Data Fusion (CDF) training to the heart of Saudi Arabia. We were thrilled to host not one, but two engaging Cognite Data Fusion Fundamentals sessions right at the epicenter of innovation - Saudi Aramco's headquarters in Dhahran. Our participants came from diverse backgrounds, each with their own unique experiences with Cognite Data Fusion. So, we tailored the training to ensure it resonated with everyone, addressing their everyday work challenges that Cognite Data Fusion can brilliantly solve.The first part of the training focused on contextualization, mastering Cognite Charts, and seamlessly connecting CDF with Grafana to tackle a real-world use case. The participants got hands-on experience, putting their newfound knowledge to the test right in CDF. In the second part, our exceptional instructors introduced participants to the Cognite Python SDK, taking their skills to the next lev

Hi Team, I need help to write the unit test using pytest,below is the code:    row_list = cognite.raw.rows.list(file.destination.database, file.Extractor_Last_Run_Table, limit=-1,                               columns=["key", "LastUpdatedDatetime"]).to_pandas()    if not row_list.empty:        val = list(row_list[row_list.index.isin([file.Extractor_key])]['LastUpdatedDatetime'])Could you please help to write the unit test for above code?Thanks

SOLVED:The Cognite client was set up wrong, hence the Cognite API error when uploading data to CDF. See docs posted by Peter for setting up config.yaml for the extractor. Specifically these were the changes:``` COGNITE_BASE_URL=https://westeurope-1.cognitedata.com (not Fusion URL)COGNITE_PROJECT= {some project name}COGNITE_TOKEN_URL= https://login.windows.net/{some_tenant}/oauth2/v2.0/token(Different from OpenID connect token URL)```_______________________________________________Hello curious and helpful members of Cognite Hub,I’m building my first REST extractor to GET a response (sensor data) from a camera_sensor API, where I then aim to upload the data to corresponding timeseries. I have multiple cameras with each its URL path, so it seems @extractor.get_multiple(paths) gives me the desired behaviour of essentially looping @extractor.get through the URLs. However, this error arises when my extractor tries to upload datapoints to the timeseries in CDF.^CTraceback (most recent call la