PDTs are great for Looker users, but our heavy data users/early company employees/founders are married to their own SQL queries where they can do all kinds of crazy ad-hoc reporting.
Since PDTs are stored with a hashed names in our database, those users can’t reference Looker’s PDTs. The same people are worried that building out PDTs in Looker instead of our database makes us more dependent on Looker. Therefore, the executive team has mandated that we either
- do not hash the PDT names anymore or
- move all PDTs out of Looker and into our database.
Maintaining PDTs in Looker is easier for me. Can anyone help me figure out how I can go with solution 1?