Community Discussions

Hello,I wanted to checkout on any upper limits for following if limit exists.Max no of Schemas that can be created in one Data Model in FDM Max no of fields that could be added in one schema Max no of Data Models under one project Also any other limits around the data size or count or number of records that could be fetched in one query or anything related in general if exists.Please help us out with these numbers, this would help us to plan accordingly!

Hi,We are working on POC to build spotfire dashboard on top of CDF for which we are trying spotfire oData connector to trigger CDF APIs. But it returns error code: 426 (attached screenshot).plus, how we can authenticate cdf apis here? oData provides only 3 authentication methods - username/password, windows authentication, Microsoft azure marketplace. 

Hi could you share an example of a transformation to load a type that has multiple links to another type? All the examples I’ve seen only set startNode and endNode but no place to specify which field. For example:type Composite {   frontPart: Part   backPart: Part}type Part {  ...}

I created a data model that contains an interface (this is to allow polymorphism). When a type references the interface then the the Data Management table shows this error:It seems the UI relies on every reference to contain an externalId field, and that this field is implicitly defined for types but not for interfaces, as the GraphQL query returns with this error: "Validation error of type FieldUndefined: Field 'externalId' in type 'Twin' is undefined @ 'listEquipment/items/twins/items/externalId'"In the above Twin is an interface type, and Equipment contains a field which is a reference to an array of Twin.

We are getting error while deployment. We have tried reformatting in local with black. Also while committing we are getting error fatal: Authentication failed for 'https://gitlab.com/pycqa/flake8.git/'. Project is in repo of team member, I have already given access to the samefatal: Authentication failed for 'https://gitlab.com/pycqa/flake8.git/'

I see in videos you can click/drag on the chart to zoom the time axis. When I try that it will only allow “panning”. Is there some mode I need to set? I see that the mouse scroll wheel does zoom the chart but the click drag would be beneficial.

Is there a way of dividing a time series in Grafana over say 7 days into separate predefined time intervalls (e.g. 1 day) without aggregate the data in the time series over 24 hours? I guess what I am looking for is to create 7 different queries for the same time series over a defined time range (7 days) in Grafana, defined for each day in that time range, and then find the difference between the first and the last data point in each query for the specific time series.

I was trying to complete the Cognite fundamental modules. I am getting the below access denied error only while doing the last 3 labs. Could you please assist for the same?

Does Cognite  CDF have a standard PowerApp connector read/write? if not can we build one.

Hello All,I am trying to query the FDM schema after populating (listForecast in slb-pdf project). But i am getting the error! seems like an bug. Can you check if I am doing something wrong.query MyQuery {  listForecast(filter: {oilRate: {eq: 1.5}, and: {gasRate: {eq: 1.5}}}) {    edges {      node {        id      }    }  }} Error I am getting is as below. Can you help if known bug or if I should do differently? "message": "Expected either 'and', 'or', 'not' or a single field condition used in the same filter block.",

In grafana, we want to display total of all timeseries data-points for all assets connected to particular asset for which we are passing query like this:ts{assetSubtreeIds=[{id=$Org4}], name='oil-production-rate'}where value of $Org1 is coming from dashboard variable.and since cognite grafana plugin does not handle cursor api responses and synthetic timeseries api have some limitation in returning 10k records only in a request, to reduce number of data-points, we are trying to use aggregation: ‘sum’ and granularity: ‘30d’ since there could be more than 10k data-points. But its is throwing error saying “sum” is not valid aggregation type of synthetic timeseries. Any reason why “sum” aggregation is not supported for synthetic timeseries.(screenshot attached)

Hi, I am currently doing my Data Engineer Basics - “Learn to Use the Cognite Python SDK “ Course. while executing the notebooks, getting below error with the first “List” notebook even after successful Cognite client authentication.CogniteAPIError: Resource not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: 52b3d730-caea-9d32-bfc4-649041e43c3e Note: I am not using Poetry as I am not getting option to change Kernel in my Jupyter.

When I run the query below, I am getting an error.  If I increase the end time by 1 second I can get a result, but it gives me 2 days and I only want 1.  All my data is consistently daily at midnight, UTC.  Any ideas how to get past this?SELECT  dp.id,  dp.externalId AS `key`,  dp.timestamp,  dp.valueFROM  `_cdf`.`datapoints` dpWHERE  dp.externalId IN (    'f18ae31cbfe544cb7bca08da91e5245a-SuFMiCo0f7c8eca4ce444208853aedd00ded4fb',    '730619216b764ba77bc708da91e5245a-SuFMiCo6bb90df0efbc461d863faedd00df009b'  )  AND dp.timestamp >= TO_TIMESTAMP('2022-09-01T00:00:00Z')  AND dp.timestamp < TO_TIMESTAMP('2022-09-02T00:00:00Z') Gives me a result, but not what I want:  cc @Torgrim Aas  @Sunil Krishnamoorthy 

I have been looking into many work-orders looking for failures or anomalies, but at this point I’m not sure to take the most of the shared information, as example I’ll take the two following events: The work order 6516382362467974 has the following details available:  Description: Exterior leakage - liquid for the main process Shutdown: Revision (full shutdown) Planned Start: 2014-09-11 I also plotted some of the signals from near the planned start, as shown in the below image:  I have a few questions about the first work order:   It seems that the compressor turned off about two weeks before the planned start time (As the green dotted line shows)   is it safe to assume that is discrepancy is because the two-week delay in sharing the data?  Is there a set of signals that I can look into for this work-order, I’m assuming that since there is a leakage, the time series related to lube oil could be affected, or maybe the pressure of the compressor.   The second work order is 54865032

In the TNT application at Statnett we are seeking to collect line and point geospatial features through the FeatureAPI. We have a dataset that has been populated with data about powerlines and substations, and we want to query the client for all of the features in each of these seperately. As there is no list() method in the FeatureAPI, and the search method is limited to 1000 results, we try to do this using the searchStream() method. Our query looks like this:client.geospatial.feature.searchStream('ACLineSegment', { limit: 10000, output: { jsonStreamFormat: 'NEW_LINE_DELIMITED' as const } }); This seems to work fine for the ‘ACLineSegment’ features but when i replace it with ‘Substation’ the call returns an empty string. I’ve tested with the regular search() and this returns features so I would expect the searchStream method to find these as well. Even stranger is that i quickly tested this functionality before the weekend and it seemed to wor

I get the following warning every time I create a CogniteClient: ResourceWarning: unclosed <ssl.SSLSocket fd=5, family=AddressFamily.AF_INET, type=SocketKind.SOCK_STREAM, proto=6, laddr=('10.xx.xx.xx', 49572), raddr=('40.xx.xx.xx', 443)> Is this caused by the connection handling in Cognite SDK? I’m using the following Python modules:cognite-sdk-4.11.0cognite-sdk-core-2.56.1

Hi there, I’m new to Cognite in general, but one task that my team is looking into is utilizing Cognite’s SVG files in our LCI and Plant Management applications and I have been looking into it somewhat.Not knowing all the details of the SVG rendition capabilities, I do see that our customer ‘Interactive P&IDs’ dataset in CDF has SVGs renditions without the comments that are in the PDF files (where applicable).Would Cognite be able to include the comments - now or in the future?The reason this is relevant for us is that a number of our doc profiles only have PDF files. Typically old documents on old installations.We’re missing native files (DGN, DWG), thus contractors are updating these drawings using comment features such as clouds, text, lines, etc in Adobe. That information seems to disappear in SVG renditions, but it’s quite critical information, especially in Plant Management systems. Thanks for listening to me!Best regards,Erik

I have found a problem reading timeseries from Cognite with Power BI. The first bit of Power Query has a filter to limit the timeseries retrieved to just the ones I want. The second one is the same, but does not have the filter. What I have found is that adding the filter causes duplicate rows in the table. Once the timeseries rows are duplicated, the timeseries aggregation values are also duplicated. I know that the first query is not the most performant option, but it should still have the correct answer.let Source = Cognite.Contents( #"cogniteContentsParameters", #"cdfEnvironment"), Timeseries_table = Source{[Name="Timeseries",Signature="table"]}[Data], #"Filtered Rows" = Table.SelectRows(Timeseries_table, each ([IsString] = false)), #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"MetaData", "SecurityCategories", "IsStep", "DataSetId", "CreatedTime", "LastUpdatedTime", "Asset", "Latest", "DataPoints", "StringPoints", "Aggregate"}), #"Filtered Rows1" = Tabl

Hi! After switching from experimental to cognite-sdk 3.9.0 I struggle with deployment. 1: Using handleIf i try to deploy using the handle, then the requirements are not handled. The function deploys, but failing at the imports. How should requiremenents be used when deploying like this? Imports are inside handle():def handle(client, data, secrets): from googleapiclient.discovery import build from googleapiclient.errors import HttpErrorCreating function like this:cognite_client.functions.create( name=function_name, external_id=function_ext_id, function_handle=handle)2 - Using a folder.Then I get this error: [WinError 267] The directory name is invalid: 'C:\\Users\\hknap\\AppData\\Local\\Temp\\tmptzkywbdl\\function.zip'If I debug, the folder “tmptzkywbdl” is created, so there should be no permission issues.  3- Manually uploading the zip fileThis works (including the requirements.txt), thanks for adding this possibility. It is just a little extra hassle ;)  would prefer if

Hi!Almost three years ago we made a feature request regarding search. Specifically we want to:Have support for paging. Do grouping on metadata-fields. Define which fields yields relevance to the search-results. Inclusive search-terms using AND instead of OR.I do understand that satisfying the search-requirements of all your users is a daunting task, but perhaps it would be easier to let us do the job instead? I believe it would be very beneficial if we were able to access ElasticSearch directly in some manner.And please keep in mind that the data itself defines relevancy. No two customers are alike and therefore a good generic solution likely doesn’t exist. @Knut Vidvei @Andreea Pastinaru 

In many cases in diagrams including P&ID, there are shortcuts to represent tags, for instance:F2014A/B/C for F2014A , F2014B and F2014C.The contextualization engine in some cases will pick one of the 3 or none at all.Is there a way for the engine to detect trailing slashes and match to multiple tags?See example of patterns below:Example of patterns 

I'm working on identifying the falling and rising edges of the VAL_23-KA-9101-M01:HSI.StatusMotorOn signal. For that and shifting the TS and rest the values, if I get -1 is a falling edge and for 1 it is a rising edge.  For the first row it works fine:  But I’m also getting a lot of values different than 1 or -1. Especially for more recent years. I guess that the problem is at the aggregating step, since I downloaded the data at a 1m frequency I get not int values for some records. Now, I was trying to download this TS at a 1s frequency, but I get a different number of records depending on the year.  E.G. for 2014 I get 34 records for a 10 days time windows with a granularity 1m.  If I do the same but for 2020 I get 1411, much more than for 2014, but still a tenth of the expected count.  If I change the granularity to 1s, I still get the same number of records, but with more precision in the time stamp:   Considering this, is there a recommended granularity to download the data and min

I am listing time series for a given asset, and get a lot of results. I need to filter based on the time series external ID, but the only option is by using the “external_id_prefix” argument to the list function. So I build up the prefix left to right. Somewhere in the external id is a parameter that I do not care about, and after comes a new parameter that I want a particular value of. Concrete example of external IDs:IAA_Miros_Weather_Data_WIA_008IAA_Miros_Weather_Data_WIB_008IAA_Miros_Weather_Data_WIC_008IAA_Miros_Weather_Data_WID_008IAA_Miros_Weather_Data_WIE_008I am interested in only getting time series with external IDs that contain “_WI” and that end with “008”. Is there a way to list time series with a wildcard? Something like this:client.time_series.list( asset_ids=[my_asset_id], limit=None, external_id_prefix="IAA_Miros_Weather_Data_WI*_008", partitions=4)I could of course obtain the relevant time series by filtering after the fact. Something like thisresult = cl

Hi Team I am trying to deploy the code into new env facing issue because of black --check.

HiI have retrieved timeseries from an asset in PowerBi. That asset is linked through a relationship column to a group of assets. However the asset and the group it belongs to are connected trough 4 steps:groupwanted <- belongsTo - subgroup<- belongsTo - type of group <- connectsTo - group of a few timeseries assets<- belongsTo - timeseries asset Im wondering how to link the relationships in power bi, and how to orient to the right place.