Re:We built our customer data warehouse all on Postgres
by doctor_eval on Friday February 02, 2024 @08:05AM
(#39228093)
Awesome, thanks! I update it whenever I work with it, which has ramped up in the last few weeks (added cast support a few days ago). It uses pg_analyse to parse the SQL and uses a few tricks to get everything updated.
The best thing (IMO) is that there is basically no funny stuff, no filename conventions, no funny delimiters. Itβs just regular Postgres SQL, and a couple of very small config files. Works perfectly with git.
The best thing (IMO) is that there is basically no funny stuff, no filename conventions, no funny delimiters. Itβs just regular Postgres SQL, and a couple of very small config files. Works perfectly with git.