Ryan Mason (Data Scientist): Square uses MySQL, Hive, and Vertica. We work with a variety of data sources, each with a separate interface.
Ryan: It’s really all about making our analysts productive and enabling them to perform analysis as easily as possible.
With multiple databases that analysts query across, we’re always looking to make analysis faster. Switching context and interfaces slows down work sometimes so anything that can ease that friction is great.
Collaboration between analysts is really important for us here at Square. We encourage sharing of work like best practice methods, great queries, recommended filters, efficient JOINs, and more so that everyone can learn from the more experienced analysts.
Documenting data and keeping it up-to-date is a major initiative. We want to be able to provide full information to analysts and promote knowledge sharing around data so they don’t have to send out as many emails asking about certain data sets or spend as much time trying to find experts on specific items.
At Square, Alation has been able to
Ryan: Alation has really helped boost productivity and the analyst experience here at Square. We use Alation as a data dictionary, business glossary, as well as an analyst tool for day-to-day work.