Developed by AICG, a company from South Carolina, DLH combines the best of data ingestion, synchronization, transformation and analytical dashboards to facilitate the construction of business intelligence and big data solutions.
Architecture
DLH has pre-build connectors for Salesforce and a few other known and common used SaaS applications. Once connected, DLH will synchronize the data automatically from its APIs on a real time basis and transform the data with Data Build Tool from dbt Labs. A few of those sources are available on dbt Hub but other data sources can be connected per request.
The information is stored on dimensional tables into Snowflake Data Cloud plus the information is available on analytical tools such as Looker with pre-build analysis following the best practices for each business vertical.
You can find the DLH open source code on https://hub.getdbt.com/datalakehouse
Conclusion
DataLakeHouse is a modern and complete end-to-end platform built with the most modern tools in the market. It has dozens of data source connectors and pre-build ELT and Data Warehouse tables feeding several Analytics and Dashboards.
About the author: Angelo Buss is a Solutions Architect and the founder of BRF Consulting - an AICG partner with expertise on Data Engineering.
Comments