Solved

I am doing some ETL jobs in Azure Databricks and have successfully managed to use Cognite’s Spark Data Source to read and write time-series, datapoints etc from and to CDF. I know that databricks itself is a cloud platform. However, it is interesting for me to be able to run some or all of the jobs locally during development phase. I wonder if it is still possible to somehow test-run Spark jobs locally? The configuration does not seem to be trivial.  I played a little bit with PySpark, and I was able to run it on my Mac but I could not create a connection to “cognite.spark.v1” to read or write data. Do you know if it is possible to perform such operation? If not, what would you suggest?  

Hi community!I got a query from our customer that they’d like to control the float precision in Chart.I found “Round” function in “Operators” and confirmed applying that indsl to the timeseries data does work.But I’d like to ask if there is any other, easier, way because creating function per every timeseries data is a bit boring.Thanks!

Hi,Is possible to make a sql query to an external SQL server from a Cognite Function? 

Can the default option be that the week start on a Monday, or maybe give the user the ability to say what day is the first day of the week? This probably varies in different parts of the world. Where I work and live and do things; Monday is always the first day of the week :). 

Hi, Both a colleague of mine and I keep getting the following message for the first 10-30 seconds when we try to view the list of public charts :  “Could not load chartsFirebasError: {code=permission-denied]: Missing or insufficient permissions.”After some time, the list of public charts appear. This time interval can vary between a few seconds and up to over a minute. Other colleagues of us are not experiencing this issue.  It seems strange that the error only occurs for a short time, but it reappears every time we try to open public charts. We have tried deleting all cookies in the web browser without this affecting the issue. Do you have any clue what could cause this? 

I am getting the error during transformation click after OIDC set upPlease guide me where i am missing the step.  

Currently when fetching datapoints from multiple timeseries, the Python Cognite-SDK splits up the requests into one request per timeseries, while the underlying CDF API supports up to 100 timeseries per requests. This slows down fetching multiple timeseries, which is a problem when you display multiple timeseries (or aggregated of timeseries) in a frontend application. 

Hi,If you are to share a chart today, you have to share it with everyone. Are there any plans for making it possible to share it with a specific group? The reason for asking is that we have a project that is interested in using charts, but they only want to share their charts with their own users. Ola

We are currently migrating to OIDC where we need to give access through access groups linked to Azure AD.On our Statnett cluster it seems that a user needs to explicitly be member of a group “transformations” in order to to delete (or edit) a transformation.The admin group has the capabilities  (on “test”) {'transformationsAcl': {'actions': ['READ', 'WRITE'], 'scope': {'all': {}}}}]But we need to login to the legacy login without OIDC and have a service account linked explicitly to the group “transformations” in order to delete a transformation. The group “transformations” has no capabilities set.I have tried both Fusion and the API/python-SDK (read is possible):CogniteAPIError: Transformation not found. This may also be due to insufficient access rights. | code: 403 | X-Request-ID: b7c0beb6-d3e0-9ec4-ba50-895533ac1996

At release, will Schema Services support being federated into a GraphQL schema, like with Hot Chocolate or Apollo?  This is how we are planning to utilize combining what is available in CDF with what we are providing in our GraphQL schemas and I was assuming this is feasible.  But, a dev mentioned that the downstream services have to support being federated for it to be made available at the federation gateway. If you are using Lighthouse for your implementation, then I see it has preview support for being federated, but I need to confirm you will configure it this way or whatever you may be using will support being federated. Thanks!

Hei!In the current schema setup, I might make a query such as this:The terms ‘edges’ and ‘node’ is a bit confusing to me. I’m not sure what they really mean in this context (I understand it from a graph db point of view, but its a bit confusing from other points. I might expect something like this instead{  listAsset() {    items {      externalId    }    pageinfo {      cursor, ...    }  }} Curious to hear your thoughts on this :)

Hi, I am trying to use templates to model domain specific connections between assets and time series in CDF, and I have come across an issue that I would like some feedback on.If I have the following schema type:type StringOrNumber @template { Asset: Asset NumericTS: TimeSeries}and do the following query:query StringOrNumber { stringOrNumberQuery { items { NumericTS { __typename isString datapoints(limit: 1) { __typename timestamp value } } } }}then the datapoint output __typename has the value “DatapointString” even though the timeseries is not a string timeseries:{ "data": { "stringOrNumberQuery": { "items": [ { "NumericTS": { "__typename": "TimeSeries", "isString": false, "datapoints": [ { "__typename": "DatapointString", "timestamp": 1634534671570, "value": 14.3

What is best practice for global error-handling in the JS-SDK?

Hi.I am following the course “Working with CDF: Integrate” and I am currently trying to create a transfrom job for the IFSDB data set. The problem is that when I go to “Schedule and run” after I have run the preview, I get an error message saying “Selected recipe is invalid. Starting av transformation job is at your own risk.”, and the Transform-button is unavailable.Please advise.RegardsLars Kjetil Sørhus

For the Retrieve data points API and a few other API’s that allow date range input, we are able to specify a string where, “The format is N[timeunit]-ago where timeunit is w,d,h,m,s.”  This is able to specify a time in the past.  I am now trying to specify end as “-365d-ago” to set a date 365 days in the future, but this is giving an error.Is there another syntax available for specifying future dates?N[timeunit]-afterNow?365d-afterNow?

Hey,At Statnett we’re thinking about our progress towards a world of more flexible data models. Although your introductions have been great,  we’re still confused about the particulars surrounding the transition between types of models.In particular, we consider the lineage of and managability of transformations of data. In the language of your data-modelling: we want the arrows between Source, Domain and Solution models to be versioned and configured as code. Is this a planned feature? If so, do you have any sketches of how this will look?Transformations might be what we call “Interfaces” in the Domain and Solution models. I.e. the physical transformer from (e.g.) Siemens is implemented by a functional 300kv to 132kv transformer at the Substation “Foo”. Currently, we model this as two assets (phys. trafo and func.trafo) with a Relationship with label “Implements”. These relationships are more or less hand-crafted. But, we would like to have these mappings, and links, as code. Preferra

Are Synthetic Time Series able to reference other Synthetic Time Series in their formulas specified?   This is the problem I am trying to solve:Synthetic Time Series is limited to referencing 100 time series Sometimes a unit/facility/system/functional location/site may have more than 100 direct child assets I need to calculate a “Synthetic Time Series” that is the daily average of a time series found on all child assets My thought is that, for 300 assets, I would have:STS A: Sum for assets 1-100 STS B: Sum for assets 101-200 STS C: Sum for assets 201-300 STS D: Sum of STS A, B, and C divided by 300Is there a better way to accomplish something like this in CDF?

As a part of the Cognite Fundamentals course Working With CDF: Consume, one has to log in to Charts and look at a few timeseries. Logging in to charts works without any further problems, but charts is completely empty. Can anybody help me figure out what is wrong? 

I am learning Cognite Data Fusion Fundamentals course from learn.cognite.com and i am performing Hands-On from Working With CDF: Integrate module. In the module i was implementing how to upload 3d model to cognite fusion. I followed all the steps as shown but i am getting error while uploading 3D model(3dmodel.zip file). After uploading the status is failing i have tried multiple times but the status remains failed.Attaching the error message and logs. 

Hello, Thank you for all the great docs and tutorials you’ve put together on CDF.  I would like to get an expert opinion on the best way to accomplish a specific use case I have.We have a daily time series that we calculate for predicted availability of an asset, for a time range that is usually between 5 and 40 years (usually between 1,826 and 14,610 data points per time series).  We have a view were an engineer will want to see this time series graphed, but also will want to see a single KPI value that represents the average of the time series from today to end of the range.  For all of our assets, this KPI could be ready several times a day as people view this KPI.  When we were storing this data in Azure SQL, to speed it up, we pre-calculated and stored this KPI average and stored a new time series (throwing away some of the time series points and linear interpolating).  That way, reading a single data point representing the average of from today to the end of the range and display

Hi! If one or more of the source-timeseries are missing data-points they will also be missing in the synthetic timeseries output..We would like an option to default to zero for missing values so that the API will use the available values to calculate a partial result. Example:TS1: [1,2,3]TS2: [3, undefined, 4] Output now if calculating a sum of TS1 + TS2:[4, undefined, 7] What we would like:[4, 2, 7]  

can you enable scrolling just for the section of the page where one creates the logic? (see attached picture) it would be nice if I could specify the degree of an exp. for instance y = ax^b+c would be a second order exp, For my specific usecase a = timeseries, b = constant and c = constant.

We would like to change a name of our dataset in Fusion (specifically data set id=7661001648160088 on statnett, test), but get the error message [  {    "status": 400,    "message": "Either set must be populated or setNull must be true."  }]` The dataset has related timeseries and asssets. What does it mean that the dataset must be populated? And what are we missing?

A college has lost the Cognite hub account in the authenticator app.He cannot register as new account since his account exists.He needs to re-register Cognite hub but does not have the account details to manually enter them.Could you please provide details of the code and URL.Note that currently Cognite hub only provides the option to authenticate via the authenticator app. Could you also provide the option to authenticate via a text message. 

Hi!Im a designer,  working on improving the front page of Charts.I would love to talk to 4 of you, to get feedback on our thought so far. I will show you what we are thinking, and you can help us move forward in the right direction.Comment here, or send me a mail to emmy.reehorst@cognite.com We want to do this for more features and improvement in the future. So even though we only need to talk to four of you this time, there will be several more opportunities in the future!