Prodata DWA - Data Warehouse Automation Templates and Samples

Welcome

Welcome to the Prodata open source library for Fabric DWA. The code contained here is open source/free with no warranty or support implied. Feel free to ping me bob@prodata.ie if you found it useful. No this is not a product! but you can contact us to help build your own data warehouse or analytics solution using these syle of templates combined with our automation Framework

Sample Notebook Templates

• Ingest-SFTP. Extract from SFTP into LH.
• Extract-CSV. Extract from CSB into LH. Merge, clean headers, archive, dedupe, checksum, etc.
• Extract-SP-Excel. Extract from SharePoint directly to LH. Support for Wildcards and multiple worksheets.
• Extract-O365-API. Extract Office 365 logs to create historic log in LH
• Extract-Dictionary. Extract Data Dictionary of all artefacts, tables and semantic model details.
• Extract-Fabric-Logs. Extract Refresh Logs. Coming Soon - Log Analytics DAX query logs.
• Extract-XML. Extract XML and optioinally use XLST to flaten into table.