This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I’d like to filter on a string dimension where that dimension matches a
particular regex. For instance, in PostgreSQL, I would do it like so:
where my_field similar to '[0-9]{3}_[A-Z]{4}_[0-9]{3}'
Broadly speaking, we use the Looker API to run a specific look, then use
the google sheets API to upload those look results to a target sheet. We
use a single configuration spreadsheet where any user can add a new
“pipe” that defines their Look URL a...
We built an internal tool to pipe looks to google sheets on a daily /
hourly cadence because our security team wasn’t fond of public look
URLs. Users love it. I imagine a very similar thing could be done to
write to Excel spreadsheets stored in Googl...
Seems like a pretty good solution to the problem Greg - thanks for the
thoughtful response. I guess I’d now consider this a feature request to
create some sort of regex_match() function available to custom filters.
Will post here if we figure out a s...