Product User Community

Hi  I am looking for information on the CDF clusters currently available world wide in Azure and possibly GCP or other clouds. I’d like to book mark the link, that’ll help design our deployment models. Appreciate if you can share the info. RegardsAlex 

One or more employees must belong to a department and each employee instance is non nullable. Below type is accepted through UI in CDF. type Department {name: String!,employees: [Employee!]!}2. Zero or more employees can belong to a department and it can be a null object or an employee instance. Below type is accepted through UI in CDF.type Department {name: String!,employees: [Employee]}3. Zero or more employees can belong to a department and it has to be a non null employee instance. Below type isn't accepted through UI in CDF.type Department {name: String!,employees: [Employee!]}I am trying to enforce field nullability use case as suggested here - https://www.apollographql.com/docs/apollo-server/schema/schema/#field-nullabilityBelow example may make my above question more meaningful in the CDF FDM context.type Department {name: String!,employees: [String!]} How can I ensure that the list of strings are non-nulls? Also, Would Strings be stored in a separate node and connected thro

I’m trying to Create a new Numeric DataPoint transformation and when I created a new transformation the UI shows a question on how it should handle NULL values (keep existing value or deleting).I’ve setup my query with a CAST function to convert values to double. I understand that this will return NULL values when CAST is not possible, so I would expect the transformation to follow the settings defined for the transformation, but instead the transformation fails with the following message:Column 'value' was expected to have type Double, but NULL was found Can you please clarify what is the expectation regarding the Numeric DataPoint Transformation. Can it have NULL values as input or not and what is the settings for NULL values about?Thanks

Hi,This is regarding creating of bounding box on PDF fileAssume we can get bounding box details from another source.And that is for whole string 18"-1S6(10S)-471454, using that need create bounding box for 471454. To find the differences we manually created the two bounding box Below are the bounding box details also attached the  screenshot.#smaller bounding box"textRegion": { "xMax": 0.12297021616798368, "xMin": 0.10935503986439225, "yMax": 0.6030244780685147, "yMin": 0.5957594432410297 } Bigger bounding box we got from XML#bigger bounding box"textRegion": { "xMax": 0.1245098493906997, "xMin": 0.0782598493906997, "yMax": 0.6047371474808384, "yMin": 0.5915995895210239 } So we can observe if we can reduce only xmin and we create  bounding box for 471454 and keep all other values same.As we have to do this for lots of places in PDF, can we get any

Hi Team,  I am trying to use uniqueness constraint in model using Cognite UI - type EntityNew @container(indexes: [{identifier : "entityTypeIndex", fields : ["id"]}], constraints : [{identifier:"id",constraintType:UNIQUENESS,fields:["id"]}]){  id: String!  name: String!  dept: Department} type Department{  name: String}I am getting error - invalid: 400 Bad Request. Text: "{ "error": { "code": 400, "message": "Missing required field: constraintType" } }" I also tried using GraphQL API and facing same issue. Can you please help.

Incremental load version should be LongType or TimestampType. | code: 400 | X-Request-ID: XXXXXX 

Does DB_extractor yaml config support execution of store procedures? If yes how to do that?

Hello Team,Not able to open the FDM from fusion ui on below url. Can you helphttps://slb.fusion.cognite.com/slb-pdf/data-models?cluster=westeurope-1.cognitedata.com&env=westeurope-1 Also when I hit below api its giving 500{{baseUrl}}/api/v1/projects/{{project}}/models/datamodels?inlineViews=trueResponse - {    "error": {        "code": 500,        "message": "Unexpected state"    }} Can you help on this ? 

Hi, I have created one FDM model having JsonObject field. In the transformation query I referred that field , example query:SELECT Series_Title as externalId,       Series_Title as name,       Overview as description,       int(Gross) as gross,       float(IMDB_Rating) as imdbRating,       int(Runtime) as runTime,       int(Released_Year) as releasedYear,       '{"key1":"value1","key2":{"key3":12,"key4":"hello","key5":{"key6":10}}}' as dataFROM movies.moviesFDM model is:type Movie {  name: String!  description: String  watchedIt: Boolean  imdbRating: Float  releasedYear: Int  runTime: Int  gross: Int  actors: [Actor]  data: JSONObject}  The transformation is failing with this error:Unknown property type Json. May be I am missing something, Can you please help?

Hi All,I am going through the cognite fundamentals training, however while I try to implement hands on for Match Entities or create interactive engineering Diagrams, I get an error as insufficient rights, could you please let me know how we can implement the Match Entities and create interactive engineering Diagrams feature while going through the training, can we get access or is there anything that we can do from our end like a workaround to get hands -on for this feature?

As soon as I add a measurement in a checklist template and click on "Confirm" it is not saved. After opening the template again, my measurement input is no longer available. Am I doing something wrong here?All fields (name, unit, min/max value) are filled in. 

Hi,The below Bootcamp CDF project is already existing one. Can you replace or recreate this bootcamp CDF project to Demo Prod CDF project under the same cluster EUROPE1(GOOGLE). Instead of Boot-Camp Project, replace or recreate the Demo Prod CDF project.Details for demo prod:CDF Project Name: accenture-demo-prodTenant ID: e0793d39-0939-496d-b129-198edd916febAdmin group Object ID:a1ecb42a-75c3-4b13-8fc8-361a449da0d4Group Name: cognite-accenture-tiger-demoprod-environment-admin Below is the mail for your reference. Thanks,Shylashri.S

We are trying to connect CDF Project instance : accenture-demo-dev through python SDK. We are getting the below error :Cognite API error : Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: 941c405e-bd77-9105-9485-4bfe9575c998We have provided all capabilities access to this project. cdf project link : https://accenture.fusion.cognite.com/accenture-demo-dev?cluster=api.cognitedata.com    

My Question is : Is it possible to use  Asset Hierarchy in Grafana?I found many things related to timeseries  but not related  Asset Hierarchy to Grafana. Thanks. 

I get this when I am trying to sign up from grafana with my Azure AD linked account dmangal@slb.com.Any idea how to solve this? 

It seems I can create transformations for types but there is no option to select a relationship when creating a transformation to a data model. Below it shows the “Target type and relationship” dropdown only has types but not relationships. Is there anything I missing?  

I encountered the following SSLCertVerificationError when trying to run the example notebook "1_Authentication" under "using-cognite-python-sdk".  The authentication via interactive login was successful. However, it threw the SSL error when executing “client.login.status()”ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1129) I updated “certifi” as suggested in another discussion thread, but the error still exists. I’m using Python 3.9.12.ANy suggestion is appreciated.

Getting an error on 2_List_Search_Retrieve.ipynb:c = cauth.create_cognite_client(method="client-secret")AttributeError Traceback (most recent call last) c:\Users\tomas.kurten.perez\Downloads\COGNITE\using-cognite-python-sdk\notebooks\2_List_Search_Retrieve.ipynb Cell 7 in <cell line: 1>() ----> 1 c = cauth.create_cognite_client(method="client-secret") AttributeError: module 'auth' has no attribute 'create_cognite_client'

Below works and the data model is published.Data Model Version - 1type Employee @view(version: "1"){name: String}Next stepBelow doesn't work and I get an error "Can not change the nullability of the property\n We do not support modifying a field's 'required'ness at the moment."Data Model Version - 2type Employee @view(version: "2"){name: String!}

Hi. I have a working solution in ITG. The solution is a model with Fields, Facility, Discipline_Area, Function_Area, ControlObject and Weightobject.These Object’s is grouped to ConstructionNode in relation to Facility and WeightObjects.I have started migrating to FDM.I started replicating the ITG solutions, but am having problems publishing the solution.Example with Fields and Facility:type Fields {  Key: String  IsDeleted: String  Facility: [Facility]  Field_Name: String!  Location: String  Status: String  Discovered_Year: Float  Original_Reserve: Float  Remaining_Reserve: Float  Production_Start: String  Operator: String  EpocTimeChanged: Int  PopulationSystem: String  PopulationSource: String} type Facility {  Key: String  IsDeleted: String  Fields: Fields  "Discipline_Area: [Discipline_Area]"  Name: String  Description: String  SystemFullName: String  Project: String  SubProject: String  CadID: String  SapID: Float  ComosUID: String  EpocTimeChanged: Int  PopulationSystem: String 

SHOW COLUMNS IN `RawDBName`.`RAWTablename`;its throwing an errorTable or view not found: `RawDBName`.`RAWTablename`; line 1 pos 16; 'ShowColumns [col_name#28876297]

More of a design question: only interfaces are allowed after the implements keyword, so you have to know what types you plan to extend beforehand, but this is not always possible or reliable. Since interfaces also produce views, I am tempted to make everything an interface, but are there any downsides?

Hi Team, I am trying to populate FDM data model using Transformation.I am using direct relationship in my model. Let say EntityRelationship View has two fields to and From which referes to Entity view. These fields are coming as Struct<String,String> as destination type intransformation.I was trying to add Space:externalId in this field. However it is giving Incompatible type error.Can you please help.Thanks,Snehal.

Hi, I’m running a transform from Raw to insert/update Numeric values./* MAPPING_MODE_ENABLED: false *//* {"version":1,"sourceType":"raw","mappings":[{"from":"","to":"id"},{"from":"","to":"externalId"},{"from":"","to":"timestamp"},{"from":"","to":"value"}]} */SELECT dp.Tagname AS externalId,to_timestamp(DateTimeStamp, 'yyyy-M-d h:mm:ss') AS timestamp, cast(value AS double) FROM `ISTC_WW_InSQL`.`wwHistory` AS dp , --selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist_cdf.timeseries AS ts WHERE dp.`Tagname` = ts.externalId--And to_timestamp(DateTimeStamp, 'yyyy-M-d h:mm:ss') Is Not Null  When previewing the code above, you can see some null values. Also, if you “run” the code it complains about nulls. (Not pictured.)   I think I’ve confirmed that the DateTimeStamp column in `ISTC_WW_InSQL`.`wwHistory` contains no null values.When, we UnComment the last line

Hi: I’m doing DATA ENGINEER BASICS - INTEGRATE course.Trying to execute Notebook 1, I cannot pass through the cell getting the authentication with Azure, namely:creds = authenticate_azure()Any help?P.S. I’m using Google Colab