Solved

Hi Team,  We have deployed Grafana on Azure using Grafana Labs available under Azure Marketplace.We need to install “Cognite Data Fusion” Plugin, but the plugin is not available, and we are unable to install it.Could you please let me know how to install “Cognite Data Fusion” Plugin for Grafana labs on Azure.PFA screenshot for the same. Also, please let me know any alternative ways to deploy grafana on Azure which has “Cognite Data Fusion” Plugin already installed. Thanks & Regards,Swati Mane

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 Team,         I would like to explore use cases in https://cogniteapp.com. I have raised request to Cognite admin. Could you please let me know within how many days, can I get access to solution portal? Thanks,N.Shailaja

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.

Hi, I am following the course “Introduction to API v1 using Postman” and I am currently trying to get Access token using provided details in the lab unable to get the Access token when i click on “Get New Access Token” after that in a popup window I get an error message saying “Sorry, but we’re having trouble signing you in.”.I am unable to move further due to this.attaching the error log along with the details used :   Please suggest for this.

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 am currently doing my Data Engineer Basics - “Learn to Use the Cognite Python SDK “ Course.  Are permissions set correctly for this environment?  I can successfully make read calls, but not create ones.Thank you,Terrance

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 am having trouble accessing the cognite training material. I am currently taking the course “Get Ready for Working With CDF”. Under “Create the data set” it asks to navigate to “Create,view, and manage data sets” under the manage category. However, I do not have this option available. Attached you will find a screenshot of my window. Please advise on how to proceed.

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.",

Timestamp too high Error. Course: CDF FundamentalsModule: Working With CDF: IntegrateError: While running Data points transformation: Timestamp too high

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.

I just started this new “Cognite Functions Hands-On ” module today.  When I clicked “Create Client Secret” button,no key seen or copied into clipboard.  When can I find the key?  I may click more than one.For other modules (like python SDK), I used to be able to download for 30 days no issue.

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