User Guide Getting Started Help Center Documentation Community Training
  
English
Français
Deutsch
日本語
Looker 7 Changelog

7.0

7.0 January 10, 2020
added
The New Dashboard Experience experimental Labs feature shows a new landing page for blank dashboards (beta) to help guide users to create content.
added
The New Dashboard Experience experimental Labs feature now supports merged results tiles.
added
The new table visualization provides the ability to limit displayed rows and to show or hide row totals and column totals.
added
A new JavaScript event, dashboard:loaded, indicates when a dashboard has loaded when tiles are not set to auto run.
added
Display which dashboard filters will be applied when creating an alert.
added
Ability to manage an alert from the alert history page in the admin panel.
added
Millisecond and microsecond timeframe support for BigQuery Standard SQL.
added
Introduced dialect support for MySQL version 8.0.12+.
added
Introduced dialect support for Qubole Presto on GCP.
added
Jumping to a view file in the IDE now scrolls the IDE sidebar to the selected view file.
added
Introduced label and description parameters for datagroups.
changed
Previously a group_label was ignored if there was only one field within the parameter; group_label will now group 1 or more fields on the Explore page. That field will still show up nested under the group_label.
changed
Dashboard filters now reset to off for a merged results tile when its merge has changed in any way — for example, if someone reorders the merge queries or adds or removes queries.
changed
Custom fields no longer require the Custom Fields Beta Users group. Custom fields are now visible to any users who have the create_table_calculations permission.
changed
Snowflake JDBC driver upgrade to v3.10.2.
changed
SQL generation for Snowflake symmetric aggregates now uses MD5() because MD5_NUMBER() is being deprecated.
changed
Updated the Oracle JDBC driver to v18.3 to resolve an Oracle database connection error: Cannot connect: connection refused: Java::JavaSql::SQLException: ORA-28040: No matching authentication protocol.
changed
Qubole Presto JDBC driver upgrade to version 2.2.0.
fixed
Non-admin users who can see the admin panel no longer see the error message Looker cannot deliver mail. The SMTP credentials are not valid .
fixed
Time zone settings for a new user are no longer dropped after the user logs in for the first time via email and password.
fixed
Subtotals no longer intermittently fail on random Explores.
fixed
Single value visualizations on dashboards (beta) no longer fail to display a value when pivots are present in the underlying data.
fixed
Having LookML fields with an HTML parameter defined no longer turns the entire text defined in that parameter into a default drill link.
fixed
Embedded dashboards (beta) in the Powered by Looker offering no longer display links directed towards Looker.
fixed
Error emails on staging instances are no longer sent to all users.
fixed
A vulnerability that potentially allowed admin users to retrieve sensitive files from the Looker server by modifying a database connection.
fixed
A modification that removed host, port, and database fields from the PDT override database settings, which resulted in broken PDT workflows.
fixed
Presto ARRAY objects are no longer displayed as [object Object] in SQL Runner.
fixed
A dimension_group field of type: duration now displays the time interval concatenated with the field name.
fixed
Queries from a BigQuery connection no longer display the error The Google BigQuery Standard SQL database encountered an error while running this query. Failed to retrieve data - Function not found: approx_percentile_distinct_disc at [16:10] when filtering on a measure field of type: median_distinct.
fixed
User Specific Time Zones no longer default to a time zone other than the one chosen in the Application Time Zone setting.
fixed
PDT panel now properly displays regenerated PDTs from Explore sources utilizing access filters.
fixed
Explore labels that have been localized no longer display a blank label if no strings file has been defined for that locale.
fixed
Failing data test results now return more API data for null endpoints.
fixed
LookML case parameter with a null label no longer returns incorrect filter results.
fixed
Snowflake table names of mixed-case identifiers are no longer misquoted when querying from the SQL Runner.
fixed
Parameterized Snowflake database connections no longer pass through the name of the attribute when testing a connection's connectivity.
fixed
A value that contained at least one character from each of these sets, ,'"& and ^%_ , is no longer double-quoted, resulting in no data in the drill-down.
fixed
Subtotals for MySQL 8.X queries threw SQL errors due to a deprecation in GROUP BY sorting. MySQL version 8.0.12 has now been added as a new dialect option with appropriate SQL generation.
fixed
Prefetching a database schema no longer yields undesirable behaviors on some database connections.
fixed
Data tests no longer display an incorrect number of assertions or inconsistent results.
fixed
Inability to modify the cron parameter within a BigQuery database connection through PDT overrides.
fixed
Content Validator failed to flag a missing field within custom measure filters.
fixed
Measures of type: median_distinct on BigQuery used to take the lower of two values instead of the arithmetic average.
fixed
Input of non-UTF8 type characters no longer results in a 500 error within the connection's settings or in SQL Runner.
fixed
Users with locales set to en no longer see the error Invalid locale for user "es_ES", not defined in project.
fixed
If Snowflake's session variable TIMESTAMP_INPUT_FORMAT was changed from the default value, queries using TO_TIMESTAMP could fail.
fixed
PrestoDB information schema query to populate SQL Runner and generate LookML files could generate repetitive UNION statements.
Top