In Database | Summarize Tool | BigQuery | Missing Functions

[JMB001]

This may apply to other databases as well but we've noticed that the Summarize tool has a limited set of aggregations/functions available for our BigQuery in-db environment.

We'd like to see the addition of those that are available in the "local" or non-indb Summarize tool, like:

• LAST_VALUE()
• FIRST_VALUE()
• CONCAT()

[apathetichell]

@JMB001 - sql syntax can vary greatly on some of that. I'd recommend including some of that stuff in your query in the local sql dialect. 

[JMB001]

I understand that it would be a challenge to solve. I agree that would work, if the summarization could happen that far upstream.