Explore Microsoft Fabric lakehouses in Visual Studio Code

  • Article

You can use the Synapse VS Code extension to explore the structure of your lakehouse in a workspace.

With the extension installed, Visual Studio (VS) Code displays the lakehouse structure in a tree view that includes the Files and Tables sections. All the lakehouses from the workspace you select appear under the lakehouse root tree node.

Screenshot showing the lakehouse list, with Tables and Files nodes under each lakehouse.

Explore a lakehouse and preview table data

Expand the Tables node to find the table entities from the lakehouse. To review the first 100 rows of a specific table, select the Preview Table option to the right of the table.

Screenshot showing where to find the Preview Table option.

Expand the Files node to find the folder and files that are saved in the lakehouse. Select the Download option to the right of a file name to download that file.

Screenshot showing where to find the Download File option.

Copy the lakehouse path

To make it easier to reference a table, folder, or file in the code, you can copy the relevant path. Right-click on the target node and find the options to Copy ABFS path, Copy Relative Path, or Copy URL.

Screenshot of the right-click menu, showing where to select from the copy options.

Related content