Edit

Transform Azure Synapse Link for Dataverse data with Apache Spark

  • Article

You can use the Azure Synapse Link to connect your Microsoft Dataverse data to Azure Synapse Analytics to explore your data and accelerate time to insight. This article shows you how to transform your Dataverse data using the Apache Spark engine available in your Synapse workspace.

Note

Azure Synapse Link for Microsoft Dataverse was formerly known as Export to data lake. The service was renamed effective May 2021 and will continue to export data to Azure Data Lake as well as Azure Synapse Analytics.

Prerequisites

This section describes the prerequisites necessary to transform Dataverse data with Apache Spark after using the Azure Synapse Link for Dataverse service.

  • Azure Synapse Link for Dataverse. This guide assumes that you have already exported data from Dataverse by using the Azure Synapse Link for Dataverse.

  • Storage Account Access. You must be granted one of the following roles for the storage account: Storage Blob Data Reader, Storage Blob Data Contributor, or Storage Blob Data Owner.

  • Synapse administrator. You must be granted the Synapse Administrator role access within Synapse studio.

Transform your data with an Apache Spark notebook

  1. In Power Apps, select your desired Azure Synapse Link from the list, and then select Go to Azure Synapse workspace.

    Go to workspace.

  2. Expand Databases, select your Dataverse container. Your exported tables are displayed under the Tables directory on the left sidebar.

    Find tables in Synapse.

  3. Right-click the desired table and select New notebook > Load to DataFrame.

    Load to DataFrame.

  4. Attach the notebook to an Apache Spark pool by selecting a pool from the drop-down menu. If you do not have an Apache Spark pool, select Manage pools to create one.

    Attach Spark pool.

  5. Add code cells to transform your data. Run individual cells by selecting the play button at the left of each cell or run all the cells in succession by selecting Run all from the top bar.

    Spark notebook.

See also

Blog: Announcing Azure Synapse Link for Dataverse

What is Apache Spark in Azure HDInsight