microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets

Synapse To SQL Manifest File for Incremental Export DestinationSQLDB Setting

Open
#260 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
Jupyter Notebook
Stars
494
Forks
296
Avg merge
1d 10h
Merged PRs (30d)
5

Description

Hi,

I am trying to use the Synapse To SQL Incremental Export to create a pipeline but it only allows me to use SqlServer as the destination database in the manifest file.

"DestinationSQLDB": { "supportTypes": [ "SqlServer" ] }

How can I update this so I can instead write to a Dedicated SQL Pool, is that possible?

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by locating the Synapse To SQL Incremental Export manifest and inspect the DestinationSQLDB.supportTypes setting. Determine whether a Dedicated SQL Pool is supported as a destination and what manifest value is required; the issue is done when the supported configuration or limitation is confirmed.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, sql
Domain
data-engineering, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.