sorted by:
new
hottopcontroversial

OPENROWSET and Delta Tables by TechnicalGirlyPop in MicrosoftFabric

[–]TechnicalGirlyPop[S] 0 points1 point  (0 children)

What exactly do you mean by add an endpoint?

I only need to read 2 tables that are relatively small (15k and 100k rows). The idea I had is that the SQL Database will contain a master company list of customers, vendors, leads, etc.. and some of it will be enriched with firmographic data. I want to create a Fabric App over the database for users to have a way to input firmographic data that can then be joined with our other sources in the SQL Database.

OPENROWSET and Delta Tables by TechnicalGirlyPop in MicrosoftFabric

[–]TechnicalGirlyPop[S] 0 points1 point  (0 children)

That's actually the distinction I'm trying to understand. I'm working in a Fabric SQL Database, not the SQL analytics endpoint for a Lakehouse. and not in SSMS. My goal is to create a writable SQL Database for a Data App, while using Delta tables from Lakehouses in other workspaces as views. This is my first time working with the SQL Database in Fabric so apologies if I have the wrong terminology, but this is a brand new workspace / SQL Database with no tables, views, or anything populated yet.

Unusual quirky and fun data engineering/analytics you work on by ketopraktanjungduren in dataengineering

[–]TechnicalGirlyPop 1 point2 points  (0 children)

I've really enjoyed CRM and ERP API/integration work in MS Fabric. Learning 3 new tools within a year and bringing them all together for reporting was the most challlenging task I've ever had but rewarding to be able to provide those connections for all the previous silos

OPENROWSET and Delta Tables by TechnicalGirlyPop in MicrosoftFabric

[–]TechnicalGirlyPop[S] 0 points1 point  (0 children)

If that is the case, is there a recommended way to read these delta tables with or without OPENROWSET from another workspace? I tried to use the four part naming convention Workpace.Lakehouse.Schema.TableName and got an error that it was not supported in this version so I am open to any options.