Solved

We have a unique use case where there are data points collected from PI server for refinery plant and alongside, we have other refinery data like Crude assays, Diet, Mass Balance. All these data points (in tabular format) are collected and then some formula is applied across to get properties (like swing cut %, CBLISS, Vol%, etc.) and some derived tables are created. Then some input feed is made from the actual data sent to a Petro-Sim tool (math simulation tool/modeling) and then output from that tool is collected and stored. All these data wrangling is done and finally charts are finally made for some 50+ crude product variants to measure yield tracking (Actual data, non-linear model data, linear model data). As per design, we are planning to use the CDF raw tables and then do all the computations and create derived raw tables to fulfil the purpose. Then use Petro-Sim connector and then store the data output from the model tool as well in raw tables. So, we don't tend to see the typi

Do we have any api in cognite which will help to show preview data of transformations?

I am currently working through “Learn to Use the Cognite Python SDK”. I am unsure where the workspace/code is provided so that I am able to take the final the test and succeed in this course. I was originally using a colab research google file that includes prompts. But the questions on the final test did not corelate with this file. Can you please instruct me on how I find the correct files/workspace.  Thank you in advance. 

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

Hello May I know if inventor 3D model is supported in CDF? 

I noticed that calling a pre-existing Cognite Function requires the functionsAcl:WRITE capability. Essentially this means that I cannot make a function available to users/dashboards/applications without simultaneously giving them permission to delete functions. What is the reccommended pattern for ACL when making Cognite Functions that are to be called by others?https://docs.cognite.com/api/v1/#tag/Function-calls

Hi, I am observing below error(in bold) in extractor log for timeseries query: 2023-01-24 03:31:03.345 UTC [INFO    ] QueryExecutor_0 - Starting extraction of avocet-timeseries2023-01-24 03:31:03.345 UTC [DEBUG   ] QueryExecutor_0 - Query: 'SELECT ITEM_ID + PROPERTY_TYPE+'Avocet' as "externalId", START_DATETIME as timestamp, PROPERTY_VALUE as value FROM ITEM_PROPERTY1 WHERE START_DATETIME is not null and PROPERTY_VALUE is not null and LAST_UPDT_DATE is not null ORDER BY LAST_UPDT_DATE ASC'2023-01-24 03:31:03.612 UTC [INFO    ] QueryExecutor_0 - No more rows for avocet-timeseries. 2 rows extracted in 0.267 seconds2023-01-24 03:31:03.873 UTC [DEBUG   ] ThreadPoolExecutor-9_0 - https://westeurope-1.cognitedata.com:443 "POST /api/v1/projects/slb-pdf/timeseries/data HTTP/1.1" 200 222023-01-24 03:31:03.875 UTC [DEBUG   ] ThreadPoolExecutor-9_0 - HTTP/1.1 POST https://westeurope-1.cognitedata.com/api/v1/projects/slb-pdf/timeseries/data 2002023-01-24 03:31:03.877 UTC [INFO    ] QueryExecutor_0

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

We multiple are seeing 408 response code from graphql query api. There are multiple combinations of filters which are not working. For eg the below one returns 408, i think the problem is with the array length of filter entity.entityName. If the array length is 2 it works else it is not working.query MyQuery {          listTimeSeriesRef(filter:{and:[{entity:{entityType:{in:["NAVIGATOR","SCREEN_CFG_REF"]}}},{property:{in:["TUBING_TEMP"]}},{entity:{entityName:{in:["Process.ReAllocation","Analysis Point by Desks","Downtime.GroupDowntime.DateTime.Subsystem"]}}}]}) {            edges {              node {                property        entity{        lastUpdated        entityType        entityName        }              }            }          }        }

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 

Cognite Data Fusion Architecture and Implementation FundamentalsImplementationyes:second question marked as incorrectbut:correct answer from video part 

Hi. I’m trying to understand why no alert has been triggered for the following monitoring job.Am I right to understand that this monitoring job should trigger an alert when the time series is above the specified threshold? (I am a bit confused by the text “alert when the threshold is”. Is this perhaps not monitoring the time series itself, but a threshold specified on the threshold tab?) 

While going through the academy course, many pages are not displaying properly. Starting with the “Check your knowledge” page under section “Introduction to entity matching” through the remainder of the course.

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

Hi Team, Please enable and configure Air setup in the below CDF project. (Accenture-demo-dev) under cluster EUROPE1-GOOGLE. Please let me know for any details. 

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.

Request with id 1912a13b-f4d1-9e0d-a7df-056276ca269e to https://westeurope-1.cognitedata.com/api/v1/projects/****/timeseries/data failed with status 400: Expected numeric value for data point.how to get to know that for which external id this error is shown?

Hello! Excited to be part of the Cognite community! I just started the ‘Learn to Use Cognite Python SDK’ course, and am running into an issue as I try to clone the repository using Git (invalid syntax error) per the Overview of Installation and GitHub ‘Getting Started’ instructions. I installed Git separately, verified that I have the git version 2.40.1.windows.1, but still no luck. Please let me know if I am doing something wrong. Thank you!

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

In the Asset transformation part I tried to select Asset hierarchy (presented in the instructions) but this option does not appear.I have already restarted my page twice. Anyone else had this problem? How did you solve it? 

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

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. 

Hello everyone,As a marine automation and instrumentation engineer, I'm looking to further enhance my skills and knowledge to benefit my career. I would greatly appreciate your assistance in finding the right course or training program that would be most beneficial in this regard.Are there any specific courses or certifications that you would recommend for someone in my field? I'm particularly interested in areas such as advanced control systems, industrial networking, or any other relevant topics that align with marine automation and instrumentation.Thank you in advance for your insights and recommendations.

Hi,Is there a tentative date when the remaining modules (Match entities with Python SDK and the courseAssessment”) in the course “DATA ENGINEER BASICS - TRANSFORM AND CONTEXTUALIZE” is expected to be uploaded in the Cognite academy?Best Regards,Philips