Activity
Mon
Wed
Fri
Sun
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
What is this?
Less
More

Memberships

Learn Microsoft Fabric

14.5k members โ€ข Free

2 contributions to Learn Microsoft Fabric
Notebook to connect with lakehouse dynamically
Current my notebook is connected with default lakehouse and I am able to do all operations. But I have a use case where I need my notebook to connect with any lakehouse dynamically using some configuration. Is this possible? How can I get it done?
0 likes โ€ข Sep 23
Hi @Will Needham , I am tried %configure option to set a default lakehouse but table read is failing with below error. I am not sure how it is working for others; can you please help on this. "Artifact not found: `<no-lakehouse-workspace-specified>`.`bronzelh_dev`" Below is the code I am using Cell-1 %%configure -f { "defaultLakehouse": { "name": 'bronzelh_dev', } } Cell -2 %%sql select * from bronzelh_dev.employees limit 10 I tried with below config as well but no luck %%configure -f { "defaultLakehouse": { "name": 'pnssilverlh_dev', "id": 'dummy-id(renamed here)', "workspaceId": 'dummy-workspace-id(renamed here)' } } @Vinayak K @Adeola Adeyemo
0 likes โ€ข 19h
Finally, my Lakehouse attachment problem is solved with newly introduced variable library support for notebooks. Below is the solution post https://l1nk.dev/wHVON
D๐ฒ๐ง๐š๐ฆ๐ข๐œ๐š๐ฅ๐ฅ๐ฒ ๐ฌ๐ž๐ญ ๐ฒ๐จ๐ฎ๐ซ ๐๐ž๐Ÿ๐š๐ฎ๐ฅ๐ญ ๐ฅ๐š๐ค๐ž๐ก๐จ๐ฎ๐ฌ๐ž for Notebooks
Hey Microsoft Fabric folks, now you can ๐๐ฒ๐ง๐š๐ฆ๐ข๐œ๐š๐ฅ๐ฅ๐ฒ ๐ฌ๐ž๐ญ ๐ฒ๐จ๐ฎ๐ซ ๐๐ž๐Ÿ๐š๐ฎ๐ฅ๐ญ ๐ฅ๐š๐ค๐ž๐ก๐จ๐ฎ๐ฌ๐ž in Microsoft Fabric notebooksโ€”it's now generally available and makes managing environments easy! This can be done even across workspaces using variable library values, so no more manual UI Lakehouse attachment needed, when switching dev/test/prod. Here's how to set it up - super easy: โ€ข First, create a ๐•๐š๐ซ๐ข๐š๐›๐ฅ๐ž ๐‹๐ข๐›๐ซ๐š๐ซ๐ฒ in your workspace (e.g., name it "myVL"). โ€ข Add string variables like: - LHname โ†’ your lakehouse name - LHid โ†’ lakehouse ID (needed only for cross-workspace) - WorkspaceId โ†’ target workspace ID (needed only for cross-workspace) โ€ข In your notebook, make the ๐ฏ๐ž๐ซ๐ฒ ๐Ÿ๐ข๐ซ๐ฌ๐ญ ๐œ๐ž๐ฅ๐ฅ a ๐๐ฒ๐’๐ฉ๐š๐ซ๐ค cell and add this code: %%configure { "defaultLakehouse": { "name": { "variableName": "$(/**/myVL/LHname)" }, "id": { "variableName": "$(/**/myVL/LHid)" }, "workspaceId": { "variableName": "$(/**/myVL/WorkspaceId)" } } } โ€ข Run the cell (it may ask to restart the sessionโ€”just say yes). That's all! Your notebook now automatically uses the lakehouse from your variables. Drop the id/workspaceId parts if it's in the same workspace. Perfect for reusable notebooks and automated pipelines. Who's already using this? Drop your thoughts below! https://l1nk.dev/wHVON Full details: https://lnkd.in/gShwbfwH #MicrosoftFabric #DataEngineering #Lakehouse #Notebooks #VariableLibrary
2
0
1-2 of 2
Guna Sekhar
1
4points to level up
@guna-sekhar-7597
This is Guna Sekhar from India, I am working as Data Architect. I joined to the community to stay up to date on Microsoft fabric also prep for DP-600.

Active 14h ago
Joined Aug 23, 2024
Bangalore, India
Powered by