Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
Hi
We are testing out a new deletion transformation for a view in data modeling. The transformation looks something like this:
select
externalId
from
cdf_data_models(...)
where
project in ("ProjectA","ProjectB")This transformation always times out and returns a “Graph query time out” error message. However, when changing the transformation to this the transformation just runs fine:
select
externalId
from
cdf_data_models(...)
where
project = "ProjectA"
union
select
externalId
from
cdf_data_models(...)
where
project = "ProjectB"For context, the project column here is indexed and the view has around 10 properties and about 1.7 million rows. The transformations all query the same view.
We are therefore wondering how the filtering in transformations handles filtering in data modeling and why these transformations are performing different. Learning more about this would benefit us greatly when working with transformations and data modeling in the future :)
Thanks in advance!
Sebastian
