{"id":97753,"date":"2023-08-21T17:00:05","date_gmt":"2023-08-21T17:00:05","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=97753"},"modified":"2024-09-03T20:04:50","modified_gmt":"2024-09-03T20:04:50","slug":"fabric-lakehouse-convert-to-table-feature-and-workspace-level-spark-configuration","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/fabric-lakehouse-convert-to-table-feature-and-workspace-level-spark-configuration\/","title":{"rendered":"Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration"},"content":{"rendered":"

I have been working as a no-code data engineer: Focused on Data Factory<\/strong> ETL and visual tools. In fact, I prefer to use visual resources when possible.<\/p>\n

On my first contact with Fabric Lakehouse<\/strong> I discovered to convert Files into Tables I need to use a notebook. I was waiting a lot of time for a UI feature to achieve the same, considering this is a very simple task.<\/p>\n

Convert to Table feature is Available in Lakehouses<\/h2>\n

This feature is finally available in the lakehouse: You can right-click a folder and choose the option “Convert to Table”<\/strong>.<\/p>\n

When converting, you can create a new table or add the information to an existing table. This allows you to make an incremental load manually, if needed.<\/p>\n

It’s simple as a right-click over the folder and asking for the conversion.<\/p>\n

\"A<\/p>\n

Table Optimizations in Lakehouses<\/h2>\n

There are optimizations we should do when writing delta tables. We usually do these optimizations on the spark notebooks we create.<\/p>\n

For example:<\/p>\n