For another article (which is still in the making) I required good sample data. The latest AdventureWorks database (2019’s DW-version) from MS SQL Server was a good choice in my opinion, but I struggled to connect it to some BI tool. Instead of jumping to another sample data of a system I knew that would work (e.g. Airline bookings for Postgres), I liked the idea to write my own ETL-job (Extract, Transform, Load) that shifts the whole data to a separate PostgreSQL database. I am only doing some minor transformation, hence the ‘T’ in the title in brackets.
Data Dude and SQL enthusiast. Occasionally does Pixel art◾