Today, we're excited to announce the general availability of Spectacles, continuous integration for Looker.
Two years ago, I was listening to Dylan Bakerâmy future co-founderâspeak on a panel at a meetup. Dylan was venting about a frustrating experience LookML developers encounter daily: âthe drudgery of manually testing dimensions and measures from the Explore page to make sure they donât error.
Dylan sighed, âI would pay for a tool that would go through each explore, click on every dimension, and run it to make sure there are no SQL errors.â
After the meetup, I found Dylan and said, âThat tool you described⌠I think we can build it. Should we do it ourselves?â In my role at the time, testing was vital to maintain the trust my colleagues put in the analytics stack I was building. Iâd learned how an automated approach to testing, called continuous integration, was helping software engineers deploy cleaner code, faster. Continuous integration was catching on in the data world as well.
We thought it was time for Looker developers to adopt the practice and reap the rewards.
Fast forward two years, and today weâre launching Spectaclesâââthe first continuous integration tool for Looker.
Spectacles automatically tests your LookML and content for errors, ensuring Looker stays reliable and accurate for your business, improving the Looker experience for everyone.
- LookML developers can relax, confident theyâre releasing code without database errors that wonât break content.
- LookML code reviewers spend less time proofreading and more time reviewing design decisions and business logic.
- Data consumers and business users encounter fewer errors so have more trust in the analytics team and in Looker.
Hereâs how it works: when you ask to merge LookML into production (say, via a GitHub pull request), Spectacles tests your code for errors so you donât inadvertently put problems into production.
How could you test your Looker instance with Spectacles?
- Dry-run featherweight queries in your warehouse to confirm the SQL youâve entered for each dimension is valid. No more angry red error messages for your marketing colleagues.
- Content validation, but less annoying âexclude content in personal spaces or only show errors that are incremental and donât already exist in production. Keep forgetting to check the content validator? Never again.
- Run Looker data tests for bespoke testing of complex assertions. If your conversion rate is a negative number, you need to know!
You can also trigger Spectacles to test Looker on a schedule or manually while developing. Set up Slack notifications so that ETL schema change at 3 AM doesnât ruin your morning cup of coffee.
Spectacles is a breeze to set up: all you need is a set of API keys and a few permissions on your LookML repo.
Our early customers found their LookML developers are more confident and efficient. Do you care about code quality, flawless Looker UX, and automated testing? Weâd love to show you Spectacles. Schedule a demo today.
By Josh Temple, Spectacles Co-Founder