microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets
CDMUtil_ConsoleApp SynapseExternalTables Translate Enum does not work
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 494
- Forks
- 296
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 5
Description
When running the CDMUtil Console App, Translation of Enums does not occur with SynapseExternalTables.
As External Tables replace nulls with empty strings and corrects null dates, it is the best method for running queries against the lake. Ideally, enum translations should function the same in External Tables as they do in views by adding the %_$Label fields.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the CDMUtil Console App code that generates SynapseExternalTables and compare its enum handling with the view-generation path. Confirm how %_$Label fields are added and how nulls and dates are translated; done means external tables provide the same enum label fields as views without regressing existing behavior.
Written by the indexing model from the issue text.
Assessment
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100