microsoft / microsoft/sqlmanagementobjects
Connection to SQL Endpoint on Lakehouse using SMO
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 143
- Forks
- 28
- PR merge metrics
- No merged PRs in 30d
Description
After talking with @jovanpop-msft who was trying to load data into a lakehouse using the SQL Endpoint and dbatools, I went down a rabbit hole of trying to get this to work. Then I talked to the wonderful Drew who pointed out that this was not possible and suggested opening an issue.
Is this something that can be implemented to enable automated querying against Lakehouses?
I can see that the use case will be using many automated runners to interact with data stores in Fabric via SQL Endpoints.
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
No file, test, or entry point is named. Start by locating SMO's connection support and how it handles SQL Endpoints, then compare that path with the Fabric Lakehouse scenario described; done means establishing whether automated querying is supported and defining an implementable scope with tests or documented limitations.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Quiet
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100