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-t...

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:   / 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