CDF Fundamentals Discussion

​@Maryam Al-Anssari I checked from my end and I was able to reproduce the same issue. It looks like a bug, I’ll create a support ticket for this. The support team will get back to you with an update.

Additionally, in working with CDF : Integrate 
in Data points section,
I copied the code and adjusted it as instructed below:

-------------------------------------

SELECT 
concat('Maryam1998:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)

FROM IFSDB.values AS dp,

--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist

_cdf.timeseries AS ts WHERE CONCAT('Maryam1998:',dp.sensor) = ts.externalId
---------------------------------------
I still get empty timeseries ( no data points) in my dataset:
 

Kindly, could you please advise on what might the mistake be

Hello Mithila,
Sounds good, thank you for your help! :)

Hello,
I am facing the same issue mentioned here. Is there a solution that can be applied? 

Thanks in advance for your help! 

Additionally, in working with CDF : Integrate 
in Data points section,
I copied the code and adjusted it as instructed below:

-------------------------------------

SELECT 
concat('Maryam1998:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)

FROM IFSDB.values AS dp,

--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist

_cdf.timeseries AS ts WHERE CONCAT('Maryam1998:',dp.sensor) = ts.externalId
---------------------------------------
I still get empty timeseries ( no data points) in my dataset:
 

Kindly, could you please advise on what might the mistake be

Hi ​@Thiago dos Santos Rodrigues 

For a start, I see that the external id of your time series is “Maryam198” and not “Maryam1998”
 

If you make it match, you should get your datapoint added to your time series!

Best regards, Sofie

Hi Team, 

I have this error, maybe someone know about this issue? 

Thank You! 

Hi ​@LEIDY JOHANNA CAMPOS QUESADA 

According to the error message, it is complaining about the Data Set Id. 
If I go into Data Catalog and search for your data set, I find it with ID 3665583308625309. Which is not the same ID as you used in the SQL Query. I think if you replace it, it will work!

Link to your data set:  https://cognite-learn.fusion.cognite.com/cdf-fundamentals/data-catalog/data-set/3665583308625309?cluster=api.cognitedata.com&workspace=data-management

Best regards, 

I am facing the same issue with time series data points being empty as a few others mentioned. 

I used this query to get data points into my time series, but when i click preview, i see the query returned 0 points. 

 

SELECT 
concat('Dinakar1990:',dp.sensor) AS externalId,
cast(time_stamp/1000 as timestamp) AS timestamp,
cast(value AS double)
FROM IFSDB.values AS dp,

--selecting from _cdf.timeseries means we select from the timeseries we ingested to CDF earlier. We do this to make sure all the time series we try to add data points to actually exist

_cdf.timeseries AS ts WHERE CONCAT('Dinakar1990:',dp.sensor) = ts.externalId

 

How can i fix this?

Hi ​@Dinakar Gollapinni 

Your transformations was successful and you have your datapoint written to your time series.

The preview will not show anything for datapoints since we don’t really do anything to the data, we just make sure we place them into the correct time series.  If you look at the graph on your successful run in the “Run history” tab, you can see that datapoint were written. 

I see that I need to update the datapoint data a bit, that the data it writes in goes back to 2020 (I think something it mentioned about this in the course??) 

Best regards, 

I don’ see any data in my time series. 
 

I also tried to view in charts, i can’t see any data.
 

Also, when I go to a different tab and come back to my charts tab, my filters are reset and i have to search for my data again.