topic Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ? in Data Warehouse

How to read the tables from data warehouse to Fabric lake house using notebook activity ?

bexy — Mon, 13 May 2024 06:12:14 GMT

Please mention sample code template to read tables from data warehouse to Fabric lake house using notebook activity andhow to write from noteboook activity to Fabri data warehouse.

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

Anonymous — Mon, 13 May 2024 06:33:14 GMT

Hi bexy ,

Thanks for using Fabric Community.
At present we don't have any direct way to modify Warehouse from Notebooks. Only TSQL can modify warehouse tables.

I can find a similar questions posted in stackoverflow, can you please check these -
Load data to MS Fabric Warehouse from notebook - Stack Overflow
Updating Fabric warehouse tables through a notebook - Stack Overflow

We also have a good news for you -

After the release - Click Here

Docs to refer -
What's new and planned for Synapse Data Engineering in Microsoft Fabric - Microsoft Fabric | Microso...

Hope this is helpful. Please let me know incase of further queries.

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

bexy — Mon, 13 May 2024 16:11:16 GMT

Anonymous ,the shared stackoverflow links were not helpful in reading the tables from Data warehouse to lakehouse using Fabric Notebook. Can you please explain what else I can do to read warehouse tables? Thanks

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

Anonymous — Tue, 14 May 2024 17:43:37 GMT

Hi bexy ,

Apologies for that, as I already mentioned at present we don't have any direct way to read/modify Warehouse from Notebooks. Only TSQL can modify warehouse tables.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

As per plan, we can expect this feature soon -

Docs to refer -
What's new and planned for Synapse Data Engineering in Microsoft Fabric - Microsoft Fabric | Microso...

Hope this helps. Do let me know incase of further queries.

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

Anonymous — Thu, 16 May 2024 08:51:13 GMT

Hi bexy ,

We haven’t heard from you on the last response and was just checking back to see if you got some insights over your query.
Otherwise, will respond back with the more details and we will try to help .

Thanks

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

Anonymous — Fri, 17 May 2024 09:06:56 GMT

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

bexy — Fri, 17 May 2024 12:10:25 GMT

Hey Anonymous ,thanks for the message.

Re: How to read the tables from data warehouse to Fabric lake house using notebook activity ?

Anonymous — Fri, 17 May 2024 12:24:28 GMT

Hi bexy ,

Glad to know that you got some insights over your query. Please continue using Fabric Community on your further queries.