Combine Looker and Dataform for the complete analytics solution
Looker has revolutionised the way data teams operate: rather than creating one-off dashboards, data teams use LookML to define the relationships between datasets, enabling business teams to explore data directly. Dataform helps teams prepare the datasets that form the foundation of a successful Looker implementation.
Looker PDTs are a simple tool for transforming data. But for a growing team, and an organization with complex data needs, PDTs are missing some key features: data tests, fine-grained scheduling, integrated SQL developer tools and incremental table builds. Dataform is the data modelling tool built for enterprise scale.
With Dataform you can write queries in SQL IDE, preview and inspect the results, and validate your SQL queries, all from a rich web interface. Queries are automatically deployed to your data warehouse, creating tables and views that can be accessed in LookML.
After defining your transformations in Dataform, add a few extra lines of code to ensure your datasets are tested by Dataform’s automated CI/CD platform. Errors will be picked up before being released to your production environment; incorrect data making its way to Looker reports will be a thing of the past.
If your business is scaling fast and you want to ensure data quality, make your life easier, leverage engineering best practices and remain BI tool agnostic then don’t hesitate to use Dataform for a second!
Having modeled data using other tools in the past, this is much simpler and an easier environment to code in. The code compiles in real time and lets you know if there are errors in the syntax. It also helps generate a dependency graph for the data pipeline which is insanely useful.
After using Dataform for a while I really discovered the power of integrating an IDE with an ETL tool. The web based IDE completely eliminates the hassle of maintaining local dev environments.