Solved

I am following the Cognite training and trying to create the asset data transformation. when hit Run bottom it shows a different error on each run. can understand what is the root cause and the mitigation action. Appreciate feedback. Thanks ever display the exactnumber of 36 rows we have in the asset.csv file

I had run transformation giving me error for Duplicate node externalIds for space 'PDM' even after deleting all the data from the model for space PDM still giving the same error, I also verified by api still there is no data still giving the error for Duplicate node externalIds for space 'PDM' . 

Currently Cognite’s Streamlit apps have issues with for example:with st.spinner('Wait for it...'): time.sleep(5)st.success('Done!')The code itself should wait 5 seconds before writing out Done!, but is executed instantly. Another example is when you try to make your application responsive while waiting for some data to arrive from a remote location. For example, when you want to print out a wait message for the user because sometimes it takes some seconds to load the data, but the app doesn't work as intended. In the following example I am trying to print out a message while waiting for the function to finish, but it fails:call_func_button = st.button("Call function with current parameters", key="button_func_call")if call_func_button: func_call = example_function.call(data=input_data, wait=False) st.info("Waiting for function...") while func_call.status == "Running": func_call.update() if func_call.status == "Failed": st.error("Function failed to run!")

I wanted to know, can I create a Table in RAW database, which will contain only column names initially with 0 rows added in it?

We’re in development of an API retrieving the latest values from timeseries from CDF using the C# SDK. Initially we set the code to look 200 days back (‘200d-ago’). Now, this stopped working all of a sudden this week. My first reaction was to go event further back (‘365d-ago’), but what works is using an even shorter timespan (‘30d-ago’).So question is - are we limited by a quota or have there been changes limiting this functionality lately?

I have a CDF chart that is showing some output based on the timeseries associated with. I want to flag the points on the chart that are beyond some threshold. (say anything >0.5 and <-0.5 is abnormal and need to be flagged off in the chart) IS there a way to show that in the CDF charts visualization.

  Getting above error whenever trying to reach documentation

Have been having issues with Cognite Charts since it’s been merged into CDF. Whenever I try to go to charts, I have to clear the cache in my browser for it to work, otherwise it doesn’t load. This is a small nuisance that can prevent people from adopting the use of Charts as their daily tool.

Manage data catalog not visible under manage section in cognite data fusion  

When I run the following code in Jupyter notebook in CDF, I dont get any problem and it runs fineimport pandas as pdroot_asset = 'LPM_YT_MODEL'def handle(client, data=None, secrets=None, function_call_info=None): start=pd.Timestamp(data["start_date"]) end=pd.Timestamp(data["end_date"]) ts_names_list = client.time_series.list(limit=None,asset_subtree_ids=[client.assets.list(name=root_asset)[0].id]) time_series_data_extids = ts_names_list.as_external_ids() data_points = {ts: client.time_series.data.retrieve_dataframe(external_id=ts,start=start,end=end,) for ts in time_series_data_extids if not client.time_series.data.retrieve_dataframe(external_id=ts,start=start,end=end,).empty}  but when this is executed as cognite function, it is throwing following error Traceback (most recent call last):File "/home/site/wwwroot/function/_cognite_function_entry_point.py", line 455, in run_handleresult = handle(*function_argument_values)File "/home/site/wwwroot/function/handler.py", line

I am trying to take cognite training and while playing the video i get the error:-”The video file cannot be played.(error code 232011)”  

There is a requirement for me where the stakeholder wanted to download all the charts (120+) in one-GO for a specific date range and then validate them. There are some charts (out of 120+) that are using the timeseries objects with some calculations. (ta * tb) /1000 , (ta + tb + tc)/1000 , 141/(ta) - 131.5,…… I cannot go to each one of them manually and download them, but the customer wants to download them all in one and then validate as per their choice.  Please advise

I have some issues, like end of electric power during the course, mainly on the final test, because at my house have 4 blackouts at afternoon. So I need to make the final test to get the Certificate.

Below is the screenshot of error , during running transformation. Below is the Query used to transform, Preview is working fine. But During the Transformation Run, it is giving above error, saying start time values  cannot be greater than endTime values. But According to Query it shouldn’t be the case. plz suggest solution. Attached Sample Data(data sheet) For your reference.select `Notification_no` as externalId, `startTime` as startTime, `endTime` as endTime, `description` as description, `type` as type, 1118188859138991 AS dataSetIdfrom(select concat('NO_',QMNUM) as `Notification_no`, --to_timestamp(QMDAT,'M/d/yyyy') as `startTime`, CASE WHEN RIGHT(MZEIT, 2)='AM' THEN TO_TIMESTAMP(CONCAT(QMDAT,' ', SUBSTRING(MZEIT, 1, LENGTH(MZEIT) - 3)), 'M/d/yyyy h:mm:ss') ELSE TO_TIMESTAMP(CONCAT(QMDAT,' ', SUBSTRING(MZEIT, 1, LENGTH(MZEIT) - 3)), 'M/d/yyyy h:mm:ss') + INTERVAL 12 HOURS END AS `startTime`, CASE WHEN isnull(QMDAB) THEN

I have a set of timeseries objects in CDF. I want to create a chart using SDK based on some function using the base timeseries objects. How Do I do that using SDK I have a timeseries object with externalID ‘ts-ext1’. I need to create a chart that follows the operation as below.[141/(ts-ext1)   - 131.5 ]  How do I do this in code iteslf?

Hi!I was trying out this API: https://pr-ark-codegen-1646.specs.preview.cogniteapp.com/v1.json.html#tag/Instances-(New)/operation/byExternalIdsInstances.When i try to Retrieve a node by external id by giving source details as well, it works fine for a single View-ID pair. But when i try to do for more than one, I’m getting empty response.Example: Say Id1 belongs to View1, and Id2 belongs to View2.Querying with (Sources : View1, items : id1) as well as (Sources : View2, items : id2) gives correct response as expected. But when I try (Sources : [View1,View2], items : [id1,id2]), i get empty response. I was hoping it would provide information on both Id1 and Id2

HI Team, Can we have one timeseries associated with two different asset?If yes, how can we handle such scenario in PBI ? Will this same share TS have same ExternalId? We have seen one business UC where one TS is getting shared between two different assets. Regards,Arati 

While performing SQL query preview in Transfer Data getting an error.Error:Verify that the 'SaiRam1995.assets' relation exists | code: 400 | X-Request-ID: 5bd0b793-6b30-94c6-986a-f00a8859afae 

In the extractor I wanted to ingest the datapoints for the created timeseries in the given dataset.even though its ingesting datapoints for the created timeseries But also ingesting datapoints for timeseries which are not available or not created. It's also creating timeseries and ingesting datapoints.OR is there any way to add config or mapping for extractor??  

I want to retrieve data frame based on external IDs for the past 24 hours. So, if current date = 08/15/2023, it should try to get the previous day’s datapoints for 24 hours i.e, from 08/14/2023 00:00:00 to 08/14/2023 23:59:59. Please share with the actual code on how to put the parameters.  from cognite.client import CogniteClientclient = CogniteClient()df = client.time_series.data.retrieve_dataframe(... id=12345,... start=<What to fill here>,... end=<what to fill here>) 

Facing a Critical Error while running the below sql code.SQL Error:(Attached the Raw input Excel for your reference.)Text '9/28/2022' could not be parsed at index 0 | code: 400 | X-Request-ID: 14d6d486-1958-99a3-b552-d19e5937bf82 -- Loads SAP Work Order as events. Data is already contextualized with assets using functional location. An inner join with CDF Assets is used to ensure only work orders for assets already loaded is ingested.select concat('WO_', `Order Number`) as externalId, to_timestamp('Basic Start Date','M/dd/yyyy') as startTime, to_timestamp(`Basic Finish Date`,'M/dd/yyyy') as endTime, 'Work Order' as type, array(`Asset ID`) as assetIds, 'SAP PM' as source, `Description` as description, `Order Type` as subtype, 2395436788557957 as dataSetId, map_concat( to_metadata_except(Array( -- "Order Number", "Basic Start Time", "Basic Start Date", "Basic Finish Date", "Asset ID", "Description", "Order Type"), *) -- map("Priority",

Hello, I am trying to use “Filter time series” or “List time series” endpoints. However, because of 1000 limit, I need to parallelize these calls as I would like to retrieve thousands of timeseries. The challenge I am facing is the pagination used in these endpoints which is based on id of timeseries. Is there a way to use index as pagination? 

Hello,I have a question regarding the post-bootcamp exercise. Task says:MainOil would like to improve their maintenance monitoring and decisionsupport at their oil platform named Stella by using Cognite Data Fusion. They would like toleverage their data to get a better overview of their maintenance operations and improvecollaboration between their maintenance and operations teams.For those, who are not into oil&gas industry so much, what exactly is required to do, i.e. what is the desired data and calculations that need to be implemented?

Hi,To apply a startWith filter on a property, we can do:prop_view = client.data_modeling.views.retrieve(('myspace', 'myview'))filters.Prefix(prop_view[0].as_id().as_property_ref("myPropertyName"),"xxx")This is working fine. However, as the externalId is not a property so the code below doesn’t work:filters.Prefix(prop_view[0].as_id().as_property_ref("externalId"),"xxx")and the error message is: “Invalid prefix filter with property reference [myspace, myview/94b12855a09cf4, externalId]. View myspace:myview/94b12855a09cf4 does not have property externalId.” Could you help find out how to apply a startWith filter on externalId in python sdk? Regards,Xiaofeng

Is the data persist both on staging and the contextualized layer(destination layer after transformation as per target data model)? Or only on staging layer? If only on the staging layer, is the data pulled from staging layer during the API calls and presented as per the target model? RegardsVikash