Copying data from synapses serverless SQL pool view to tables in the pool

Athira Reghuraman 20 Reputation points
2023-03-16T10:32:21.6366667+00:00

Hi ,

I have created views for all D365 F&O tables in synapses serverless SQL pool using the CDMUtil solution . I am looking to transform the data from views to table in the same or a different DB , i.e. cache mechanism, to reduce the cost of call the views over and over again while reporting . Is there any procedure to achieve this .

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,338 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,365 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee
    2023-03-20T09:12:36.1+00:00

    Hi Athira Reghuraman,

    Thank you for posting query in Microsoft Q&A Platform.

    You can use Azure data factory or Synapse pipelines for this. You can use copy activity to push data into your tables. If you would like to perform some kind of transformations on your data, you can consider using mapping data flows.

    Hope this helps. Please let me know if any further queries.

    Please consider hitting Accept Answer button. Accepted Answers helps community as well.