Hi all,
what's the best way to write a condition in the transformation query, that checks for presence of certain key in asset metadata?
Example asset metadata:
"KEY": "VALUE"
pseudocode:
select * from _cdf.assets A where ‘KEY’ in A.metadata.keys
I’ve been provided with following solutiion by Cognite support, with a note to ask here. Is there a better/other solution?
select * from _cdf.assets
where metadata['KEY'] is not null;