Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
ooohh I did not notice that! Thanks for showing! @Tommy Thorsen
Meh, it would work to have them in the Documents API, but with files being in the UI and in the SDK’s I would prefer to have it in Files API. Nonetheless, if it is more quickly accomplished by adding the hash to the documents it would be great to have in the interim.
Might be because you have it selected twice at the end, although I feel this will not solve it. Putting in aliases for the tables might also help with the debugging, and make sure that the EventAssociationID is indeed in both the INActive and Active tablesSELECT INActive.`EventID`, INActive.`SourceName`, Active.`EventTimeStamp` AS AlarmOnTime, INActive.`EventTimeStamp` AS AlarmOffTime, INActive.`Message`, INActive.`Active`, INActive.`EventAssociationID` AS KeyFROM `ChemPlant`.`Alarms-2-INActive` AS INActiveINNER JOIN `ChemPlant`.`Alarms-1-Active` AS ActiveON INActive.`EventAssociationID` = Active.`EventAssociationID`
Hello!It is by design. CDF allows users to create relationships between data elements using the Relationships resource type, as it provides flexibility in modeling data in graph structures that are meaningful for the organization. However, it is up to the user to define the relationships and create the necessary transformations to populate them. This allows for greater customization and control over the data modeling process without making a tangled web of relationships.You do get some level of “relationship” between resources by having them linked to assets. This allows one to see which timeseries, sequences, files, or events are related to an asset, and this is created when one creates the items in CDF. I would also suggest checking out entity matching as it can help automate this linking.
It sounds like you are downloading an individual event by clicking the download button. I do see your pains on not having a way to download bulk data directly from fusion right in the UI; however, there are multiple other methods that one can leverage to explore data in CDF.PowerBI would be a good option for someone not wishing to code.Some code approaches:I've tacked a similar problem by leveraging the Cognite Spark Data Source (some info in Cognite Docs) where you can execute sql to read the entirety of a particular resource type. The metadata is still in a similar format, but leveraging instructions here should flatten them out to columns. This approach would work best if you able to leverage databricks/pyspark. If you do not have access to databricks/pyspark a similar workflow could be accomplished using the python sdk. Where you can list all of a particular resource type, easily retrieve it as a pandas dataframe, and manipulate the code snippit below to flatten the metadata.###imp
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
