pinterest / querybook

Querybook is a Big Data Querying UI, combining collocated table metadata and a simple notebook interface.
https://www.querybook.org
Apache License 2.0
1.83k stars 222 forks source link

Global Templating + Last Partition Templating #406

Open czgu opened 3 years ago

czgu commented 3 years ago

Add the ability for the user to define templating for themselves, when running queries, the owner's custom definition will be taken into consideration. These templates need to be able to be represented in text form for ease of sharing with others.

Add get the latest table partition for hive metastore and provide a default function that lets the user get the latest partition of a table via a function call. The signature should be something like

lastest_partition(table_name, pattern=None,)

All available functions and variables should be available to view/update somewhere near the query editor UI.

czgu commented 3 years ago

image image