Jul 18 in Technical
I need help transferring data from db to dataset in synapse
Hello everyone 馃憢,
I'm working on a project where I need to dynamically copy all tables from a source SQL database to a dataset in Azure Synapse using pipelines. I'm looking for insights and ideas on how to achieve this effectively.
Specifically, I'm interested in:
- Dynamic Table Copy: How can I dynamically iterate through all tables in the source SQL database and copy them to the target dataset in Azure Synapse?
- Pipeline Configuration: What are best practices for configuring Azure Synapse pipelines to handle dynamic table names and automate the data copying process?
0
2 comments
I need help transferring data from db to dataset in synapse
skool.com/microsoft-fabric
A community for passionate analysts, data engineers, data scientists (& more!) looking to learn Microsoft Fabric - the end-to-end analytics platform.
Leaderboard (30-day)
1
+24
2
+21
3
+20
4
+17
5
+14
powered by