Solved

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  

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.

Course: PostgreSQL GatewayLearning Path: https://learn.cognite.com/path/data-engineer-basics-integrations/postgresql-gateway I get an error when trying to import the Schema, as described here: Step 5: Map the source and destination tables“Test Connection” succeeds, and I can list out all the tables, such as public.assets, but I get an error when trying to import the schema: 

Hello! I've created a function with the CDF UI using a zip file containing the handler.py file and requirements.txt.In the handler.py file I have some imports for the cognite.client and pandas, then some data wrangling using client.assets and then the handle function.I don't have the login code for the cognite client within the code in handler.py as I've understood that is not needed on runtime.When calling the function from CDF UI, I receive the error related to the "client" as it doesn't recognizes it. Should I provide an .env file within the zip file along with the code for instantiating the CogniteClient()? Or provide the needed env vars as secrets when creating the function from UI? Thank you

Hi All, I am having 3D contextualized model in CDF and i want to show this as is in Power BI along with some conditional formatting based on asset status. May i know how this can be pulled into Power BI?Thanks in advance! Regards,Arati

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

Hi, I’m trying to complete the Fundamentals course and have completed 9 modules.  At the end of the 9th module, it tells me to Start Assessment, but when I go to do that, it says I have to complete the Cognite Data Fusion Architecture and Implementation Fundamentals module.   I’m stuck at how to resolve this as I’ve completed that module (12 of 12 lessons complete - 100%) although the system doesn’t think I have for some reason.

Hi, Since the relationship have been created between types in the data model. I am wondering why it can’t be made at the backend by CDF but required user to make the relationship transformation manually ? Is it by design ? Thanks, Kind regards, Carrie 

I have been using RAW tables and creating a final table out. After creating a transformation, I could see the number of rows as ~8000 but that's a wrong number. After changing the transformation a bit, now I got the correct number post running the transformation which  is around 4000 but the final RAW table isn't changing.I could see that the table isn't being overridden with the new data. Can anyone explain me why? Thanks in advance!

Hi, I have entered Authorization tab details in postman per the lesson instructions but am receiving a “Sorry, but we’re having trouble signing you in” message.  Please see attached screenshots.  

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

If I have view B which implements view A, in the definition of view B do I need to list the properties (e.g. container mappings) that are “inherited” from A? I noticed that if I don’t list them, this works fine the first time when view B is created (I can see the inherited properties automatically included), but if I try to update view B (even if nothing changes) the call fails saying that there is a change in the property list and the version needs to be changed. I’m assuming this is because the inherited properties are missing from the definition. Is this behavior by design and I have to explicitly list the properties, or would it be considered a defect?

HI, May i know how to schedule a refresh in Power BI for Cognite as i am facing below error?When i try to schedule, i see it is disabled for me.I tried to install the gateway locally as well but it says installation failed.While establishing the connection with CDF on PBI desktop i get pop-up as third party connector. Does that mean PBI service doesn't support scheduling for Cognite?Please help.TIA.Regards,Arati

Hello, it’s kind of easy to get all edges via rest api, but how i can filter them by start node? It’s not clear from documentation how to create such filter. Or any other approach using rest api will help me.{ "instanceType": "edge", "limit": 1 "filter: { "property": [], "value": "value" }}My filter is not correct here, but what I want is to filter all edges where “startNode”: {“space”: “name-space”, “externalId”: “some-id”}

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. 

Is there any known limitation in cognite-sdk-dotnet to be consumed in enterprise solution?

Could you please suggest how to limit source?

When following the CDF Fundamentals - Working with CDF: Integrate, I accidently performed the events and timeseries transformations using the data set ID of the AvevaNet data set, and not the IFSDB data set. I don’t know how to undo this. Any help would be much appreciated.

I was trying to upload a machine learning model file in pickle format of size 5GB. I observed that whenever the file is getting uploaded, the size of the uploaded file is 969 MB. The entire file is not getting uploaded. Only a part of it getting uploaded.Are there any restrictions on size for file upload ? Can we increase the that restriction while uploading?

https://github.com/cognitedata/cognite-sdk-js/tree/master/samples/react/msal-browser-react, I am trying to run npm install and $ REACT_APP_CDF_PROJECT=... REACT_APP_AZURE_TENANT_ID=... REACT_APP_AZURE_APP_ID=... npm startgot the following error:node:internal/modules/cjs/loader:1024  throw err;  ^Error: Cannot find module '/Users/kevin.peng/code/cognite/cognite-sdk-js/samples/react/msal-browser-react/start'    at Function.Module._resolveFilename (node:internal/modules/cjs/loader:1021:15)    at Function.Module._load (node:internal/modules/cjs/loader:866:27)    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:81:12)    at node:internal/main/run_main_module:22:47 {  code: 'MODULE_NOT_FOUND',  requireStack: []}

type SimulationModel { modelName: String! nodes: [SimNode]}type SimNode { modelName: String input: [Key]}type Key{ modelName: String unit: String}With the above sample schema, I am able to fetch all the SimNodes together with their Keys for a specified SimulationModel instance using the GraphQL:query MyQuery{ listSimulationModel(filter:{externalId: {eq : "00000000-0000-0000-0000-000000000000"}}){ items { externalId modelName nodes(first:100){ items{ externalId modelName input{ items{ externalId modelName unit } } } } } }}How to do do the same with the APIs, could you give an example? Not sure which API should be used(instances/list, instances/byids, instances/search, instances/query). 

Currently, we choose the Instance Space same as Data Model ? What is the purpose of Space ? When we need to create one different with data model ? thanks :)