Does notebook editor support postgresql functions?

Get Help
1

Hi,

I want to create this query

select date_trunc('month', start_date) as month
from table_name;

using the notebook editor. is that possible?

I could not figure how or where to specify the postgres functions

Thanks :slight_smile:

2

Hi @sherryummen
Custom Expressions are Metabase functions - they are similar to some database functions, but not the same.
https://www.metabase.com/docs/latest/users-guide/expressions.html

https://github.com/metabase/metabase/issues/16870 - upvote by clicking :+1: on the first post

3

Thanks for the quick reply. I wonder whether we could have the feature in where the expression could be anything. then entered expression could be used as it is in the the query generated by metabase ? then perhaps you just return the error given by the server and metabase dont have to do any validation from its own side?

4

@sherryummen That is very unlikely. Then you should probably just use SQL all the way.