Impact 2024: The Industrial Data and AI Conference for and by Users | Nominate Speakers Now for a Ch...
We have customers using InfluxDB as a local on-prem storage mechanism. What’s the best extractor to use to push this data to CDF? I’ve heard OPC-UA is the way to do it, but what I find online are ways to store OPC-UA data into Influx, but not ways to get InfluxDB data into a OPC-UA server so I could use the OPC-UA extractor to get it into CDF.
When I look at dates in CDF, it represents them as AA.BB.YYYY. As an American, used to seeing dates in the MM-DD-YYYY format, I have to think a minute about which is the day and which is the month. Specifically, I’m looking at the list of data models and the Last Modified column. Charts uses YYYY-MM-DD, which is somewhat better as it’s more clear, but still not “normal”. Extraction Pipelines tell you the delta “3 months ago” or “2 days ago” with a tooltip in YYY-MM-DD.It would be nice if dates were shown using the browser’s locale. There are functions in most languages to get the browser locale and format the dates accordingly. So, I would see MM-DD-YYYY and my European colleagues would see DD-MM-YYYY. It would be nice if it were done consistently across CDF too.Note, I’m not talking about time zones, only the date/time formatting. Adjusting for time zones is another topic entirely.
I’m investigating the Pi Asset Framework extractor. I see how to bring in assets and I think I see how to get time series data. However, I don’t see how to bring in event frames. I’m not an expert with Pi AF by any means, but it seems like these would map nicely to CDF events. What I don’t see is how to configure the extractor to bring in the event frames. Does it do this? What do I need in the config file to turn it on? Is there additional documentation on the PI AF extractor beyond what’s available here https://docs.cognite.com/cdf/integration/guides/extraction/pi_af/pi_af_configuration?
I have some code working great via a Notebook, but I want to move it to a server where I can run it as daemon. The authentication is failing when I run it on the server.I suspect the problem is with the Scopes - User impersonation might work in the browser where I’m already logged in to the right project. What scope should I use instead when I’m calling directly from Python?Also tried myscope = '[f"https://westeurope-1.cognitedata.com/.default"]'as suggested in the documentationoauthlib.oauth2.rfc6749.errors.AccessDeniedError: (access_denied) Unauthorizedfrom cognite.client import CogniteClient, ClientConfigfrom cognite.client.credentials import OAuthClientCredentialsfrom cognite.client.data_classes import TimeSerieshost = "https://westeurope-1.cognitedata.com"myproject = "rok-buandcollaborators-53"clientid = "realStuffWasHere"secret = "secretsecretsecretsecretsecretsecret"#myscope = "https://westeurope-1.cognitedata.com/.default"myscope='["IDENTITY", "user_impersonation"]'token="https
I created a set of timeseries via the API. The Python examples do not show how to include an externalId nor do they say one is really needed. Looks like they need one, otherwise they don’t work in Charts. That’s all fine. My problem now is to add the externalId to existing timeseries.I think the right way to do this is with a transform, but I can’t get it right. I can get it to preview correctly, but it fails when I run it.My transform is:Select name as name, concat(name,"123") as externalIdfrom `_cdf`.`timeseries` where dataSetId = 8883655420989208;The error is Request with id 2463250f-1635-9a05-aa9a-709366e80349 to https://westeurope-1.cognitedata.com/api/v1/projects/rok-buandcollaborators-53/timeseries/update failed with status 400: Time series not found. Missing externalIds: [Tank-401-01-TT123].Looks like it’s trying to query for the timeseries with that externaId when I’m trying to set the externalId. How do I get it to set the value?
We have customers who want to have the ability to put up a chart and not touch it and see it update and scroll as time passes. Grafana has some nice features to allow a user to set the update frequency - this is to request is to bring this kind of functionality to Charts.
Hi,I’m just getting started with Cognite. I’m trying to create some assets. I’ve loaded them into RAW and I’m trying to write a SQL transformation to load them into assets. Is there documentation on what functions are available? I’ve gone through the online training and the simple example there, but it doesn’t cover what I’m trying to do.My specific questions are that I’m looking for documentation to answer are (for now):What data type is the id, parentid, and other fields How do I cast the string data in the csv to right type. I assume there is a Cast function The UI tells me I have the wrong type. It doesn’t tell me which field and what type it expects. That would really be helpful. In this case, I know what field, but I don’t know the type it’s looking for. For a top level asset in the hierarchy, what do I use for parentID? If I have spaces in the field names in my CSV, how can I reference the field?
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.