Connection to SQL Endpoint on Lakehouse using SMO

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

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
35/100
Issue type
Feature
Clarity
Needs clarification
Activity status
Quiet
Tech stack
csharp, sql
Domain
databases

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.

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.

Dominant language
C#
Stars
143
Forks
28
No merged PRs in 30d

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.

More from microsoft/sqlmanagementobjects

All issues in microsoft/sqlmanagementobjects

Similar issues

More C# issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.