Skip to main content
Gathering Interest

Performance improvement on populating data on Data Models using transformation

Related products:Transformations and RAWData Modeling
  • April 9, 2025
  • 2 replies
  • 45 views

Shashan Udawatte
Practitioner
Forum|alt.badge.img+2

Hi Team, 

We have a request from Aker Solutions that Transformations populating data models takes much longer than populating raw table. We request for a feature to improve the performance of transformation that are populating data on Data Models using transformation. 

2 replies

Andre Alves
MVP
Forum|alt.badge.img+14

Hi ​@Shashan Udawatte 

I don’t have all the details, but based on what we're discussing, this sounds like a heavy workload. You could consider a parallel processing approach to move data from the staging area to the silver/gold layers (data model), using techniques similar to those available in Apache Airflow.

This approach is likely also supported in Cognite Workflows, where you can run Cognite Functions in parallel to process chunks of data independently for each task.

If you can share more details, we’d be happy to suggest a solution that better fits your specific scenario.

This is ideal for ETL/ELT pipelines where:

  • You can split the dataset into chunks.

  • Each chunk is processed independently (e.g., loading different partitions, handling different tables or time intervals).

  • The results are later aggregated or moved to the silver/gold layers.

Regards,
André


Mithila Jayalath
Seasoned Practitioner
Forum|alt.badge.img+8

FYI ​@sebastianheibo.akso