Product User Community

Hi, I want to transform JSON object to Data model column. JSON is populated from extractor to raw table, so its type is by default Object and its structure will be nested.Is there any built-in/ Custom function using which I can parse this json  and convert the specific value into column. I have tried to_josn () which will convert the json structure to string and then with the help of get_json_object() I can get expected value by passing json path to this function. But problem here is it will always return value as String.  

Hi, I have done the Grafana setup from azure managed grafana from azure portal. But don’t have permission to install cognite data fusion in grafana from azure. Please let me know how to install plugin and what permission needed.   

Hi,I am running the DB Extractor, where my Source is an odbc connection(SQL DB) and destination is Timeseries. But I am getting the error: “ [ERROR   ] QueryExecutor_0 - Unexpected error in UB-Training-Timeseries-objects: 'NoneType' object has no attribute 'timestamp'”Attaching the screenshot of my data in SQL, error Log and config file.I am using DB extraction v3.0.0.Please reach out if you need more info.

Hi! We have made the following updates available for Workflows.Support for Workflows in the Cognite Python SDKThe Cognite Python SDK now has native support for Workflows. Documentation can be found here. We have also updated the example notebook, which you can find attached as a file below (Note: Download the file and remove the .txt postfix to open it as a Jupyter Notebook.)New Access Management CapabilitiesYou can now configure access to Workflows directly in Access Management in CDF. Navigate to “Manage” > “Manage access” and for the relevant Groups add capabilities to read/write Workflows as needed (see screenshot below). This replaces the experimental ACLs which were required initially to interact with the service. The capabilities can also be added to a group using the SDK directly, e.g.:from cognite.client.data_classes import Groupcapabilities = [{"workflowOrchestrationAcl": {"actions": ["READ", "WRITE"], "scope": {"all": { }}}}]group = Group(name="Workflow Orchestration", ca

Learn FDM GraphQL Queries . Aggregate query not supporting sort functionality. How to achieve sort functionality in aggregate  

How to fetch documents from multiple folder locations using single config.yml file by Cognite Documentum Extractor? how to write multiple DQL queries in same config.yml? Which configuration parameters to use?I am working on Cognite Documentum Extractor and using DFC Java SDK mode for connectivity.

Hi! I am trying to update “Planned End Date” for a specified work order in staging.I have prepared this table to join to my work order raw table:This is my sql and the error message I got:Is there a way I could update “Planned End Date”? Thanks in advance. :)

@Jørgen LundWe have a use case for Workflow Orchestration feature in a project – an example being we would like to run some workflows (Cognite functions) after successful runs of certain workflows as they have a dependency between them.There are some conversion and allocation factors that vary periodically and will be updated to SharePoint via end users. Based on the dates for these numbers, we will utilize them for further data munging and calculations in other Cognite functions, given that the previous function run was successful.Can we use workflows for this? If yes, can we enable this in our project?

Hi Team, IS there any unit testing examples for cogex based extractors to test integration with rest api

Hi! I have a question about the data modelling in Cognite Data Fusion.We record data from thousands of sensors from a factory. Today we record them as time series in CDF and organized in the asset hierarchy by manually constructing the relationships.I heared the data modelling toolkit is meant to replace asset hierarchies approach in future. Could you please elaborate a bit on how Cognite would suggest to approach our use case, if we started from scratch today.Thanks!

I have a set of timeseries objects t1,t2,t3,t4,t5…..etc. Now I would like to create a derived timeseries objects based on the existing timeseries objects. For instance  T1 = (t1/1000) *141.5T2 = (t2/100 - t3)T3 = (t3/100 - 14)T4 = t4 * t2/100T5 = t5/100How do I perform these steps using cognite SDK. Is there a way to perform these operations?Please advise. Retrieving dataframe from data-points and then create new timeseries objects (T1,T2….) will be challenging and hence wanted if there is an optimal way to handle this in a better way. Is this possible using synthetic time-series?IS there some examples and code snippets that can be shared so that I can grasp them better?  

I have had this problem before but it fixed it self by just waiting. But is the connection to CDF down when you get this error in PBI? Details: "Cognite: Request failed: The remote server returned an error: (503) Server Unavailable. (Service Unavailable)"

Found a bug? Have a question about how something works? We want to hear about it!You can choose to either create a dedicated post (topic) in the Charts group by clicking the Create topic button OR simply post a reply below in this thread. Remember to include a screenshot or video to help the product team best understand what exactly you’re talking about or referring to. 

How do I perform upsert using this dataframe. I also need to associate the timeseries against a specified asset. Please advise. How to use this dataframe and perform associating to an asset id using this line:    client.time_series.data.insert_dataframe(df) I have a dataframe that looks like this as below: DATE LP_Crude API_Meter LP_FRN_KERO_SW_CUTPT LP_KERO_DSL_SW_CUTPT LP_DSL_AGO_SW_CUTPT LP_MVG_HVGO_SW_CUTPT 1/1/2023 28.75472705 271.8662 440.9032 680.3416 928.875 1/2/2023 28.21111702 269.3863 466.2317 686.5167 924.1292 1/3/2023 27.78340123 268.8638 484.6189 684.5542 919.9917 1/4/2023 27.5781529 269.3117 506.7792 686.6708 921.9375 1/5/2023 28.03229217 268.1567 500.2208 688.2208 917.575

Will custom data formats for hosted extractors support events as target type in the future, and if so, do you have a rough estimate on when? 

How can i connect to CDF, using Alteryx ETL tool.Is there any documentation available?

Is there an example available for setting up the metric feature using Prometheus for the OPC-UA extractor, similar to what is shown for the PI extractor in the Cognite Academy? 

Hello,I am running a csv_extractor that loads data to Raw explorer. I run the extractor from my machine locally through cmd. How do I set up an extraction pipeline to monitor this extractor? I created an extraction pipeline from “monitor extractor”, but not sure how to link it to my extractor.Regards,Diana

What is “YOUR_SECRET_API_KEY”? How to get this secret key? Please tell 

Hello,Can I get an example of a CDF function that deploys a .pickle or .joblib model into CDF, then calls the model?Thanks,Diana

Hello all, I’m trying to connect CDF data source to my Grafana instance that I already installed as a plugin, and I get this message:“Angular plugin This data source plugin uses a deprecated, legacy platform based on AngularJS and is incompatible with your current Grafana configuration.”  Then when I try to add it as a new data source, the CDF is not available on the drop list  Is the Angular plugin warning message preventing me from adding the data source? if so, is there any way I can resolve this? Thank you,Yasir

I am working on Cognite Documentum Extractor and using D2 as mode of connectivity. I have not received any CA root certificate from Documentum Server from Client. Client have mentioned that, they don’t have the certificate. So, Can Documentum Extractor work without CA root certificate? If not, Is there any alternate approach which we can use to make it work using D2 mode?Also, If it can’t work without root CA certificate, Please suggest me an approach or steps to generate the certificate from Documentum Server.

Hi team, We are facing an issue while uploading a file to CDF using smb yaml configurations using File Extractor, please find the error below.2023-10-05 12:38:42.043 UTC [ERROR   ] MainThread - Could not upload file xxx.pdf to CDF: [Error 1] [NtStatus 0xc0000043] The process cannot access the file because it is being used by another process: xxx.pdf'How can we fix this issue as many users might be using file share in different locations at the same time while uploading it will be difficult to know? 

Hello Cognite team, Greetings! Below is a screen shot of 4 data points available for a specific timeseries id in a duration of 1 hour For the above mentioned data points when i select the aggregate function (similar value being resulted from aggregate function api) i see an average value which is significantly higher than the original value (calculated manually) The data interval for the below points is for every 15 mins the first 4 data points for this timeseries is what you see in the below screen shot  

New to Cognite.Can anyone help on this:We have CSV files uploaded into CDF dataset (thru’ FileExtractor), and now need to read and parse the csv files contents in the CDF into TimeSeries? And how to run it automatically or scheduled?Thank a lots.​​​​​