Migrate relational data towards Azure Cosmos DB playing with Azure Studies Factory

Migrate relational data towards Azure Cosmos DB playing with Azure Studies Factory

During my prior post, I informed me strategies for Blue Databricks while the Apache Spark collect_list mode to execute a two-desk relational research migration so you’re able to NoSQL, by using the embedding approach to support a single-to-of numerous relationship. We used Apache Ignite due to the fact at that time we did not have ideal native functions during the Azure Analysis Facility (ADF) to support this conversion process. Really, we now have it and it is (obviously) called assemble. So it form usually takes several thinking and aggregate her or him for the an enthusiastic selection. We are able to play with collect to create arrays or enough time strings:

This informative article will show you how-to migrate relational analysis in order to Azure Cosmos DB using only Blue Studies Facility, and no password called for. The employment circumstances is strictly just like inside my earlier blog post, I’m adding they here once again to own short site:

One-to-of many dating making use of the embedding method

In a number chatroulette of You to-to-Of many conditions, the recommended means is to try to Embed the countless front on the you to front, therefore getting rid of the necessity for meets. A familiar analogy is when i have a master/detail collection of tables such Purchase Header and you may Acquisition Detail. Continue reading “Migrate relational data towards Azure Cosmos DB playing with Azure Studies Factory”