Does notebook editor support postgresql functions?


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:

Hi @sherryummen
Custom Expressions are Metabase functions - they are similar to some database functions, but not the same. - upvote by clicking :+1: on the first post

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?

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