Intro to Foundry's Applications

Currently Playing: How to use Contour's SQL Expressions Board

Contour’s Expression board lets you add custom functionality to your Contour analyses. Using Spark SQL expressions, you can derive new columns, filter data, and perform aggregations in ways that would be cumbersome or just not possible with Contour’s other boards. In this tutorial we’ll see how to use Contour Expressions through a few examples that you can use in your own analyses. You can find the expressions used in this video in the accompanying blog post: https://www.ontologize.com/blog/how-to-use-contour-expressions *Ontologize* Founded by Taylor Gregoire-Wright, a former Palantir implementation engineer, Ontologize offers courses & live trainings for Palantir Foundry. Visit https://ontologize.com or connect on LinkedIn: https://www.linkedin.com/in/tgregoirewright/ *Chapters* 00:00 Intro 00:22 Adding Expression Boards 00:40 SQL syntax 01:10 SQL Expressions vs Statements 01:53 Quick tips 02:28 Case/When Expressions 02:52 Window Functions 05:38 Aggregations 06:34 Advanced Expressions: t-statistics 09:06 Parameters 09:27 Saved Expressions 10:12 Ideas for Saved Expressions 11:18 Outro