Skip to main content
Solved

CDF Transformations filter at dataset level


Is there a way to query metadata of TimeSeries from a particular dataset in CDF Transformations?

Something like this, but this query isn’t working

select
  cast(`externalId` as STRING) as externalId,
  cast(`dataSetId` as STRING) as eid
from
  `_cdf`.`timeseries`
where dataSetId == <data_set_id>;

Best answer by Jatin Sablok

Yes it did. THanks

View original
Did this topic help you find an answer to your question?

6 replies

Everton Colling
Seasoned Practitioner
Forum|alt.badge.img
  • Seasoned Practitioner
  • 163 replies
  • April 25, 2024

Hi Jatin,

The query you shared works fine. I just tested it on my side, both in the Fusion UI and using the API, as below:

Can you confirm if you passing the dataSetId as an integer?


Forum|alt.badge.img

I agree with @Everton Colling , also tested on my side in the UI
with both 

where dataSetId == 638923115923336 OR

where dataSetId == ‘638923115923336’

It returns everything as expected. 

What message do you get? 

If you are looking to see the metadata of the timeseries, you can add “select metadata as metadata” to your query


  • Author
  • Seasoned
  • 34 replies
  • April 25, 2024

Thanks. I think I was using dataset name instead of ID. But thanks once again !!!


Forum|alt.badge.img
  • Seasoned Practitioner
  • 285 replies
  • April 25, 2024

@Jatin Sablok , There’s a builtin CDF function for this:
https://docs.cognite.com/cdf/integration/guides/transformation/write_sql_queries#dataset_id

you use the external_id and it will resolve the id for you.  Scales across cdf dev/stage/prod projects this way:)
Jason


Dilini Fernando
Seasoned Practitioner
Forum|alt.badge.img+2

Hi @Jatin Sablok,

Has the information provided helped address your concerns?

 


  • Author
  • Seasoned
  • 34 replies
  • Answer
  • May 31, 2024

Yes it did. THanks


Cookie Policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings