Overview Did you know that the Snowflake data platform is the perfect fit for ETL, data integration, and data preparation tasks? In this blog post we will give you some hands-on advice on how you can use Snowflake as an ETL engine for data preparation. Let’s take this common scenario as an example: Your company has built a data lake ...
A brief history of ETL The rise of ETL and the rise of the data warehouse are tightly coupled. It’s like the chicken and the egg. There would be no data warehouse without ETL and no ETL without data warehouse. Once in a while non-sense such as data virtualisation or NoETL will pop up. However, if you want success with ...
In our previous post Optimisation algorithms for converting XML and JSON to a relational format, we explained that Flexter ships with two optimisation algorithms. These algorithms make the life of downstream consumers of the output of Flexter easier as they simplify the relational target schema that Flexter auto-generates. In this post we will be showing you a second optimisation called ...
In this post we will guide you through the easiest way of processing your XML data to a relational format on MySQL . We will be using Flexter as a Service (FaaS) to process the GTDF XML standard. FaaS follows a monthly subscription model. Flexter is available in three editions. An enterprise edition, which can be installed on-premise. A managed ...
In this post we will guide you through the easiest way of processing your XML data to a relational format on Snowflake . We will be using Flexter as a Service (FaaS) to process the OSCRE Real Estate Industry Data Model (IDM) XML. FaaS follows a monthly subscription model. Flexter is available in three editions. An enterprise edition, which can ...
