In Database | Summarize Tool | BigQuery | Missing Functions

Question

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()

JMB001 · Answer

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

apathetichell · Answer

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