When you extract a file into Fabric (LH or DW) Table from a CSV, you can leave columns as the default varchar(8000), or with additional work apply the proper data types.Some questions we seek to answer Does the correct data types improve performance, given that storage is delta parquet and not a SQL format ? … Continue reading Should you use Datatypes on Staging Tables in Fabric ?
Author: Bob Duffy
Its common to have spreadsheets in SharePoint and want to ingest them into OneLake in Fabric. Typically this could be master data, mappings, budgets or any type of data that does not reside within a core enterprise system. We've developed a Python class that can be used in Fabric Notebooks that wraps the Graph API … Continue reading Integrating Sharepoint Online with OneLake in Fabric