I’m just curious if anyone has found a really successful model for visualizing data that you don’t necessarily want built into your data model. I find myself faced with a few options and wonder how others are dealing with a similar scenario.
Sometimes I have user maintained data I want to write SQL directly over, or a non-joinable data-set that I need for analysis and want in Looker for continuity, but don’t necessarily want clouding up a project or model.
- Run the query through pure SQL and export into google sheets/excel for reporting - works, but I hate reporting outside of a BI tool
- Pay for a low-cost provider for ad-hoc SQL requests - I’m thinking something like Redash
- Create a separate project (Ad-hoc) with it’s own repository and use SQL runner to create quick models to deliver insights.
For emphasis, I’m bought in to data modeling, I agree on Looker and data management for 80% of what I need, but the other 20% that’s quick delivery ad-hoc non-modeled analysis I’d still like an easier solution than spending time making it fit into and cluttering my model vs. working fast to deliver something in a timely manner.