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

7.4

7.4 March 12, 2020
ADDED
Google Drive and Google Sheets integrations are now available via the Looker Action Hub.
ADDED
New filters syntax is more concise and simpler to write. The square brackets denote an array with key-value pairs.
ADDED
Measures can now be sorted by other measures in the order_by_field parameter.
ADDED
Tiles on dashboards (beta) now support the grid layout option.
ADDED
A tile's content on dashboards (beta) can now be downloaded in these formats: TXT, Excel, CSV, JSON, HTML, Markdown, and PNG.
ADDED
Merged results tiles are now filterable and fully supported on dashboards (beta).
ADDED
Dashboards (beta) can now be downloaded in PDF and CSV formats. Note: PDF formats will still render the old dashboard design.
ADDED
You can connect multiple Slack workspaces to a single Looker instance and access Looker content from the home tab in Slack.
ADDED
More blocks and visualizations are now available in the Looker Marketplace (beta): Salesforce, Hubspot, Square, Time Tracking Essentials, and Zendesk Analysis blocks and Aster Plot and spider visualizations.
ADDED
Whitespace is now respected in filters.
ADDED
Users now have the ability to switch filters on/off for embedded Looks via the Embed settings on the Admin page. Note: This setting applies to all embedded Looks on the instance.
ADDED
The datagroup label and description parameters are now visible in the Datagroups page in the Admin panel. Both subparameters can be localized using locale strings files.
ADDED
The database connection now runs tests for a database user's ability to use PDT stable views (CREATE VIEW, SELECT, DROP VIEW) when adding a new Looker connection.
ADDED
Boards are now easier to organize — users with edit access can now drag and drop sections to rearrange them.
CHANGED
The Snowflake JDBC driver has been updated to version 3.11.1 for Apache Arrow results format support for improved result-fetching performance.
CHANGED
The Dremio JDBC driver has been upgraded to version 4.1.4 for SSL support. Existing connections may need to be updated in the Admin page under Database Connections; check Verify SSL Cert to enforce strict hostname verification.
CHANGED
The connection parameter in a LookML file will now automatically suggest database connections that are available on the instance.
CHANGED
The user permission download_without_limit can now be set to specific models instead of its previous implementation of instance-wide.
CHANGED
The PDT admin page now loads about 100x faster than before.
CHANGED
In the IDE, the collapse icon is now always visible, instead of visible only on hover.
FIXED
PDTs with the parameter publish_as_db_view set to yes will now publish stable views for all production models that the PDT is associated with.
FIXED
Table headers are now following customizations made in the visualization settings.
FIXED
A vulnerability that allowed a user with the explore and access_data permissions to maliciously leverage series menu options to introduce a cross-site scripting (XSS) vector has been resolved.
FIXED
A vulnerability that allowed developers to maliciously leverage measure labels and values to introduce a cross-site scripting (XSS) vector has been resolved.
FIXED
A vulnerability that allowed users to maliciously leverage value labels in Bar visualization settings to introduce a cross-site scripting (XSS) vector has been resolved.
FIXED
In the dashboards (beta) experience, table tiles are no longer cut off when users scroll to the bottom of the tile.
FIXED
Users will no longer enter a bad git merge state when files have been deleted from a different branch.
FIXED
Subtotal amounts no longer change when users click around table cells.
FIXED
Scheduling or downloading content that yields no results will no longer fail with the error message RendererNoRenderFinishedEventReceivedError - retried.
FIXED
A user's schedules will no longer fail to send while that user has Development Mode enabled but does not have develop access to the model the schedule's content is built on.
FIXED
Scheduling or sending Looker content no longer fails when the fr_FR locale is utilized on an instance.
FIXED
An ellipsis option for long filenames has been added in the IDE to prevent an overflow of text.
FIXED
Deleting multiple models from the IDE no longer prevents a user from deleting all configured models under the Manage Projects page.
FIXED
Users will no longer receive a 404 error message when they attempt to delete git branches that contain a forward-slash character, "/".
FIXED
Datagroup labels and descriptions, when being localized, no longer return the IDE error message parameter "label" must be a string. Hash was given.
FIXED
Snowflake and MySQL based dialects should no longer return undefined method errors when additional JDBC parameter separator characters are used.
FIXED
LookML data tests must have unique names across a model: An IDE error will be thrown if a test with the same name is defined more than once.
FIXED
The time zone rendered with the query_timezone parameter in non-persisted Native Derived Tables no longer shows an invalid value.
FIXED
The PDT reaper now effectively removes stale stable PDT views.
FIXED
The PDT reaper will now remove temporary PDTs that were not previously caught by the reaper.
FIXED
PDTs no longer fail to build with the error message duplicate key violates unique constraint.
FIXED
PDTs will no longer rebuild upon updating to a new Looker version.

7.2

7.2 February 6, 2020
ADDED
Introducing a new experimental version of the Looker API, version 4.0.
ADDED
The LookML parameter parameter is now supported in the following dashboard (beta) filter types: radio buttons, button group, drop-down menu, advanced (is).
ADDED
Support for static maps (regions) and in dashboards (beta).
ADDED
The ability to create and manage alerts with a new simplified UI in dashboards (beta) is now available.
ADDED
Introducing these new blocks and visualizations into the Looker Marketplace (beta): Salesforce, Square, Spider chart, and Aster plot.
ADDED
Introducing a BigQuery project select box within the SQL Runner UI for BigQuery dialects that support multiple databases.
ADDED
Introducing the ability to select from multiple databases when selecting Create View from Table in the IDE.
ADDED
Introducing a new beta endpoint on API 3.1 called dashboard_lookml.
ADDED
Introducing the ability to create generic LookML files in the IDE to use for data tests or Explores.
ADDED
Introducing keyboard shortcut options to fold: Alt + Command + 0 and unfold: Alt + Command + = code in the IDE.
ADDED
The dialect now shows database views in both SQL Runner and the Create View from Table option in the IDE.
ADDED
Introducing PDT support for the Amazon Athena dialect.
ADDED
Introducing the ability for admins to disconnect existing Slack connections for the Slack (beta) App action.
ADDED
Introducing the ability to override the Looker-detected field types and pivot columns within a SQL Runner visualization.
ADDED
The Scheduler now monitors the scheduled job queue for jobs that have been enqueued for an hour or more while more recent jobs have been successfully dequeuing. While this is a rare occurrence, if this occurs, the scheduled job is closed and reported with an error on Looker's Schedule History page.
ADDED
Introducing query concurrency limit of 1 for dashboards and Explores based on the system__activity model to improve impacts on performance.
ADDED
Users without the explore permission are now able to download a Look in PNG format.
ADDED
System Activity dashboards are now able to be shared with other users via actions from the Action Hub.
CHANGED
Homepage settings are out of Labs (beta) and in the Admin section under General Settings.
CHANGED
Removed SQL Explain from Explores for DataVirtuality because it is not supported by this dialect and added SQL Explain functionality to Explores for the MS SQL Data Warehouse dialect.
CHANGED
Upgraded the Presto JDBC driver version to version 0.230.
CHANGED
Upgraded the Exasol JDBC driver to version 6.2.3.
CHANGED
The following dialects are now considered dialect integrations: Oracle ADWC, Qubole Quantum, and Spanner.
CHANGED
Curated Search is no longer a beta Labs feature and is now generally available in the Looker platform.
CHANGED
Upgraded the BigQuery JDBC driver to version 1.9.6. This upgrade also resolves the error Google Standard SQL database encountered an error. Unsupported type: DATETIME from being incorrectly generated by queries.
CHANGED
Default tables in BigQuery connections, like publicdata and fh-bigquery, will no longer be automatically populated in SQL Runner.
CHANGED
The column menu in table charts has been simplified and now contains the following sizing options: Autosize All Columns and Reset All Column Widths. In addition, width changes made using the column menu now persist.
FIXED
The parameter value_format and number formatting implemented in the Explore UI will no longer lose precision for numbers with more than 17 digits.
FIXED
The error NoMethodError : undefined method `each' for nil:NilClass is no longer displayed when a visual config is not defined in a LookML dashboard being converted to a user-defined dashboard.
FIXED
Projects with IDE Folders disabled and containing a strings.json file now properly display LookML files in the IDE.
FIXED
Drop PDT table before rebuilding to avoid the following error: SQL Error in CREATE TABLE as SELECT: org.postgresql.util.PSQLException: ERROR: relation "lr$rmp" already exists.
FIXED
Users now have the ability to extend localizable properties on parameters when one parameter has a default locale mapping of the property value and the other does not.
FIXED
Aliasing a dimension of type: location with another dimension of type: location no longer yields a measure of the aliased dimension in any Explores the field is in.
FIXED
Postgres dialects will now quote table/schema names that have spaces in them in both of the following cases: the SQL generator will write proper sql_table_names and the SQL Runner snippets will target the correct schema/tables.
FIXED
Using the Find and Replace functionality in the IDE no longer prevents the overlay of Jump to File from appearing.
FIXED
Pivoting on a dimension that has an underlying field of datatype float in the BigQuery dialect no longer renders this error: Failed to retrieve data - Partitioning by expressions of type FLOAT64 is not allowed.
FIXED
Using the option to Get Dashboard LookML on a user-defined dashboard no longer generates incorrect LookML by displaying fields of type: time as type: string.
FIXED
Validating through the content validator will yield a more useful error if the filters being implemented are of the wrong datatype.
FIXED
The API endpoints run_query and run_inline no longer trigger PDT rebuilds even if the parameter rebuild_pdts is set to false.
FIXED
Disabled the externalbrowser value for the authenticator parameter within Snowflake’s JDBC driver to prevent arbitrary calls to browser applications on the Looker server.
FIXED
Dashboards with no tiles will no longer block the schedule's queue and will render an empty dashboard.
FIXED
Alerts no longer allow you to reference a field that does not currently exist in a tile's query. Alerts referencing fields that no longer exist in the tile's query will continue to yield this error message: undefined method `[]' for nil:NilClass.
FIXED
The ability for a user with Scheduling permissions to select Add Schedule... to a Look from the Look's menu options.
FIXED
A ZIP file of a dashboard with Japanese characters in the tile titles can now be opened as expected.
FIXED
Single-value visualizations will no longer be included in an alert's email message to prevent mismatched data from being displayed.
FIXED
Setting the visualization setting Limit Displayed Rows to Hide last 0 rows no longer renders corrupted files.
FIXED
The full field name no longer appears when downloading a Look with Visualization options applied, even if Show full field name is disabled.
FIXED
Schedules of dashboards that yield a ZIP of CSVs now show the error message from the query itself instead of Error streaming dashboard-/.csv to out.
FIXED
Utilizing the _theme={} function no longer flickers on load for dashboards. This behavior did not occur with Dashboards (beta) enabled.
FIXED
The pop-up window for deleting content in an SSO embed context no longer displays the word Looker.
FIXED
Bars within the table visualization now display as expected when the visualization option Truncate Toggle is enabled.
FIXED
Single value visualizations on dashboards (beta) are able to properly show a comparison when a spreadsheet format for value is in use.
FIXED
Single value visualizations no longer improperly display percentages on dashboards (beta).
FIXED
Admins are able to view, edit, and delete private alerts and unfollowable alerts, but they cannot follow unfollowable alerts.

7.0

7.0 January 10, 2020
ADDED
Stable, statically named view tables can now be generated on top of PDTs. A stable database view will only be published for its underlying PDT when that PDT gets rebuilt.
ADDED
For every rebuild of a PDT, the given table name will now be unique. This will yield increased stability and faster rebuilds for certain dialects.
ADDED
The ability to perform bulk move and delete actions on folders and files.
ADDED
The ability to use Shift + click as a shortcut to select a range of folders or files within the IDE sidebar.
ADDED
The ability to move a file to a collapsed folder.
ADDED
The ability to expand a folder after hovering a file over the folder.
ADDED
The ability to collapse the IDE sidebar.
ADDED
The ability to see imported project files natively in the IDE, organized into a folder called imported_projects in the IDE sidebar.
ADDED
The Looker Marketplace (beta) labs feature is now enabled by default.
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
Boards now provide users the ability to add section descriptions.
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.
ADDED
JSON format is now supported for model localization strings files.
CHANGED
Enhanced System Activity dashboards to improve the monitoring experience of the Looker instance.
CHANGED
The classic IDE is still available as a legacy feature called IDE Folders Toggle. View the Legacy Features End-of-life Schedule.
CHANGED
Item added January 28th, 2020: Implemented a change that removed the ability to retrieve datasets outside the default project for a BigQuery connection.
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