Thanks for this, lots of useful feedback. I’ll respond to a few things here, and others might have additional feedback/questions.
The graph feature is part of Enterprise Edition. Let us know if that’s something you’d like to evaluate. More about the differences here: https://www.dremio.com/enterprise-edition/
As for regexp_extract, there are several functions documented here: http://docs.dremio.com/sql-reference/sql-functions/string.html
In addition, you might look at extract_pattern, eg:
extract_pattern(full_address, ‘\w+’, 0, ‘INDEX_BACKWARDS’)
There’s also regex_split, eg:
regexp_split(full_address, ‘\Q \E’, ‘FIRST’, -1)
Run shortkey has been on my wish list too. Hoping to get that in soon.