UiPath Process Mining uses internally DBT and Snowflake. DBT and Snowflake are in principle powerful and widely used ETL tools. This begs the questions whether these can replace traditional ETL outside of UiPath? In particular, I’d like to create a datalake on Azure and I’m wondering whether it is viable to use UIPaths integrated Snowflake/DBT for all the ETL and then export Data to Azure or whether I rather need to do the ETL outside of UiPath, for example with Databricks on Azure? At which point would I need to use an external ETL solution?
hi @dataguy - You are right that the ETL tools for UiPath Process Mining are built on DBT & Snowflake. They are architected for internal usage of the product and are not designed for general purpose ETL solution right now.
The data transformed as part of UiPath Process Mining cannot be exported outside (planned for later this year) and once we have it, even then, it will be primarily designed around process mining scenarios.
For your use case of creating a datalake on Azure using Databricks on Azure or Azure Data Factory will be more appropriate.