Migrating Existing Table Transformations

Coalesce supports data transformations from most data warehouses. Here are some tips and tricks when bringing data transformations into Coalesce.

• Bring all the entities in as Sources.
• Build a node of each source that matches the type they type there. For example, if it was a dimension table previously, add a dimension table off the new source node.
• Create and Run the graph to materialize the tables in Snowflake.
• Apply column constraints and transformations on a node-by-node basis.
• Remove references to the source nodes, as they are no longer necessary.
• Update the queries in the "Join" tab for each node.
  • Point these queries to other nodes that reflect the same transformations applied in your original data warehouse.
• Finally, these nodes can be treated as Targets. They will function the same way as nodes in a data warehouse natively built within Coalesce.