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.
The implementation here depends on whether this is an external use case
(utilizing SSO Embed) or an internal one (for dashboard filtering). For
an external case, you would want to use access filters: {<!-- -->{
_access_filters["customer.schema"] }} For an in...
Agree 100% on Standard SQL. So so much less headache. That said,
converting to Standard SQL turns into a large project. Unlike Redshift
or, say, Vertica, Legacy BigQuery required a lot of custom SQL and
Derived tables. One way to address Legacy -> St...
Overall, a very much needed feature that partially solves a problem of
default redundant fields. There are a couple of problems though: speed.
With a large number of groupings, there is a significant delay in the
time UI takes to load. I have now obs...
After brainstorming it with RealSelf guys, @ajit1 and @Grayson_William
(fyi they are hiring), we have arrived at the following logic: (SELECT *
FROM TABLE_QUERY(schema, "(table_id >= CONCAT( 'table_name_' ,
STRFTIME_UTC_USEC(IFNULL({% date_start some...