3.x Release Notes

Starting in Looker 3.46, items marked with a flash_on indicate changes to existing functionality that may require your attention as you update.

Looker 3.56 2016-09-25

flash_on Looks

• Looks are now stand-alone documents. Looks have been refreshed to focus on content presentation. Some things to look for include:
  • Increased emphasis on the visualization pane
  • A collapsable Details panel, which exposes quick information about the Look including its description, creator, created and last updated times and scheduling and dashboard information
  • On-Look configuration options including scheduling, deleting, and access control
  • An on-Look edit overly, where the query and Look title can be modified
  • Reset Look and Explore from Here links, which allow users to play with the query and dig deeper without affecting others' consumption of saved content.

Dashboards

• On-Dashboard Editing. When in edit mode, users can now modify tiles directly from the dashboard.
• Added a message on dashboards over 25 tiles informing users that performance may be impacted.
• LookML Dashboard notes will transfer to user-defined dashboards after being converted.

Visualizations and the Explore Page

• flash_on Filtering on a dimension by clicking on a value in the results data table or a table visualization now adds that dimension as a filter on the current page rather than refreshing the entire page. This disables such dimensional filtering on dashboard table visualization elements.
• Added an Unpin from Zero option to allow charts to focus on the area for which data exist rather than showing the full scale starting at zero.

LookML

• Introduced ${EXTENDED}, which allows you to refer to refer to both the object being extended and the extension object at the same time. Learn more.
• Renamed SUPER* to EXTENDED* for lists. Learn more.
• Persistent derived tables built in Development Mode will now always have a maximum persist_for of 24 hours. Learn more.
• The LookML generator will now add a description parameter to freshly generated view files.

Dialects

• BigQuery. Introduced initial support for BigQuery Standard SQL. Includes support for the query size estimator and symmetric aggregates.
• Impala. Added support for persistent derived tables.
• DataVirtuality. Fixed an issue that could cause symmetric aggregates to generate invalid SQL.
• MS SQL:
  • Fixed an issue where a field could not use more than 30 characters.
  • Introduced a static dialect (Microsoft SQL Server 2005) to connect to the deprecated 2005 version of MS SQL.
• Snowflake. Fixed an issue where certain combinations of date filters incorrectly returned no results.

Admin

• On the Groups page, added the ability to filter on the list of users within a Group.
• A user's page will now display the Reset Password link below the send button.
• Groups on the Groups page are now ordered alphabetically.
• Users on the Users page are sorted alphabetically, with null user names at the end of the list.

General Tweaks and Bug Fixes

• Updated the 404 page across Looker to reflect that the page could be a result of missing content or a lack of permissions.
• Updated Save, Copy, and Move dialogs that display Space or Dashboard trees to show the Spaces a user may save to.
• Groups may now be set in an SSO Embed URL.
• Cursors will now focus on the first field any modal.
• Fixed an issue where the Look Validator could take longer than normal to return results.
• Disabled the "Open in Browser" option when the file format is Excel.
• Fixed an issue where not all subSpaces would load in the Save, Copy, or Move dialog.
• Fixed an issue where the Get Dashboard LookML explore option did not generate all dimensions and measures.
• Improved the error message when users cannot move content into Spaces to which they don't have access.
• Fixed a series of color picker-related issues.
• Fixed an issue where secondary, tertiary, and further pivot sorts were not respected on the Explore page.
• Fixed an issue where inputting text into the visualization configuration boxes could be jittery.
• Fixed an issue where IE11.0 users could not click on the Choose Field drop-down in the dashboard filter modal.
• Fixed an issue where start_date and end_date evaluated to null when using the "is on the day" date filter option.

Looker 3.54 2016-08-28

Content Management & Spaces

• Access Controls for Spaces: Introduce the ability to manage who can access various Spaces and at what level. Learn more.
• Groups for User & Content Management: A new Groups paradigm governs collections of users. Groups may be given access to Spaces as a unit. Groups can be set up automatically through existing authentication methods like LDAP and SAML. Learn more.

Looker Design

flash_on Updates to Mobile Dashboards for easier viewing, including:

• Larger tile size
• Improved filter usability
• Updated navigation for improved screen real estate

LookML

• Added new timeframes including second, millisecond, and microsecond. Learn more.
• Added the ability to filter on the second timeframe. Learn more.
• flash_on The LookML Validator will now correctly warn when order_by_field is declared on a non-dimension field or references a measure. Learn more.
• flash_on Introduced a legacy feature to prevent dimensions from referencing measures. Learn more.
• flash_on The LookML Validator will now correctly warn when filter fields are declared with type: time. Learn more.

Explore

• Added the ability to copy values in a column of the data table. The copied values will be accepted into the filter input box if pasted there.
• Added the ability to replace field references in table calculations and custom filters with the Look Validator. Learn more.
• Filters now default to the same interval as the timeframe being filtered on. For example, when filtering on "created_hour", the filter will default to "hours" instead of "days".
• Descriptions for dimension groups now appear at the dimension group name level rather than repeated for each dimension. Learn more about descriptions. Learn more about dimension groups.

Visualizations

• Added a visualization option to reverse the direction of the x- or y-axis.
• Added the ability to hide totals on the table visualization.
• Reference lines now leverage a color picker instead of hex value inputs.
• Charts now use the null symbol (∅) rather than the string "null".
• Pie charts and the associated legend will now be centered as a unit instead of centering the chart itself.

Scheduling & Downloading

• Resource Manager for Scheduled and Downloaded Tasks
  • By default, the system will process downloading and rendering tasks in pairs. Instance administrators will see a new source in the query panel called "renderer".
  • These changes should result in fewer timeouts on rendered content and reduce impact on the Looker instance.

General Tweaks and Bug Fixes

• Tweaks to Spaces
  • Improved the load time of the Spaces page.
  • Improved the loading time of the Space picker in the Save, Copy and Move modals.
  • Ensured that the title of Spaces properly propagate to the browser tab.
  • Updated the styling of the Edit Space modal to match other modals.
  • Cursors now focus in the first editable field in Space modals.
• flash_on Retired support for Internet Explorer 10. Learn more.
• Added a new permission to allow users to view drill overlays on dashboards without being able to explore the data.
• Requesting a password reset link from the login page now offers a confirmation when the password has successfully been reset.
• Introduced a new keyboard shortcut (ctrl+shift+d) to enter Development Mode.
• Standardized the presentation of the closed Filters section on Explores and Dashboards.
• In the "Choose Field..." drop-down in the dashboard filter edit modal, values will now respect associated view labels.
• Added built-in support for creating local version control.
• Improved the efficiency of the LookML Validator.
• Improved query killing for Presto versions 0.133 and above.
• Added explanatory language for the Temp Database on the edit connections page.
• Ensured that datatype: date fields are filtered properly in certain dialects.
• Fixed an issue where symmetric aggregates removed newlines on most dialects.
• Fixed a bug where validating LookML could crash an instance.
• Fixed an issue where totals could be omitted when pivots are sorted with a column limit.
• Fixed an issue that could result in mismatched colors between titles and text in single value visualizations.
• Fixed an issue where default color palettes may not apply everywhere.
• Fixed an issue where sections of the Field Picker could not be expanded or collapsed when using Firefox.
• Fixed an issue where timeframes produced a LookML error when using can_filter: false.
• Fixed an issue where LookML dashboards with text objects wouldn't download.
• Fixed an issue where reassigning ownership of scheduled plans could cause recipients to be removed.
• Fixed an issue where the can_filter parameter could allowing filtering when interacting with drilling.
• Fixed an issue where a filter could switch to matches (advanced) after a query is run.
• Fixed an issue where timezones could change on drill-down.
• Fixed an issue where filter values were reliably removed from the filter input boxes on the explore page.
• Fixed an issue where measure sorts could remain in the query after the measure was removed.
• Fixed an issue where SQL did not reliably generate on the SQL tab on the Explore page.
• Fixed an issue where a user's Space could hang if the user lacked access to certain Spaces.
• Fixed an issue where editing filters on a dashboard copied from a deleted user's space could produce a Validation Failed error.

Looker 3.52 2016-07-31

Looker Design

flash_on Redesigned Navigation Bar

• Widened available working canvas to expand real estate for working with tables and visualizations and accommodate landscape viewing on additional devices.
• Simplified navigation by removing icons and focusing organization on user actions. The navigation includes:
  • Browse: Have a look at existing content; start from existing Looks and dashboards
  • Explore: Start a new query
  • Develop: Enter the LookML editor, the SQL Runner, and turn Development Mode on/off
• Increased the available Help and reorganized the menu. The help menu includes:
  • Search for Docs and Discourse
  • Links to official Documentation and Looker Discourse
  • Information about the current Looker release (including release notes and number)
  • Chat support with Looker's Department of Customer Love (only available to developers and instance admins)
• Menu cleanup. Tweaked a number of menus and lists in order to facilitate navigation and unify design.
  • Alphabetized a number of lists including Roles, Connections, and Explores in the dashboard Filters modal
  • Left aligned gear menu items and appended "..." to options that launch another modal

Visualizations

flash_on Series Tab in Visualization Editor

The Series tab introduces an improved interface for editing the color, name, and type of a series. Everything that had been modified using key-value pairs in the Style tab's free text boxes can be found in the Series tab, which has replaced the Style tab for cartesian charts.

Learn more: Column charts / Bar charts / Scatter charts / Line charts / Area charts

Explore

• Data tables now display column totals when row limit is reached. Learn more.
• Explore descriptions are now displayed in the Explore drop-down on the top navigation bar.

Scheduling & Downloading

• Stand-alone Permission to View Scheduled Information. The see_schedules permission allows access to the scheduled plan and the scheduler history panels. Learn more.
• flash_on Improved Layout for Pivoted Downloads. Downloaded .csv, .html, .md, .txt, and .xlsx files now display one row per pivoted dimension to more closely match the display in Looker. If you have processes that rely on a single header row, please make use of the "Single Row Table Headers" legacy feature. Learn more.
• Clarified the error that users receive when Looker is unable to render PDFs due to PhantomJS not being installed.
• Clarified the error that users receive if they are a recipient of a scheduled plan made by a user who has been deleted or disabled.

LookML & Development Environment

• Autogenerated Context as SQL Comments for PDTs. When generating PDTs, Looker will issue a comment to indicate the model, view, ID of the user generating the table (if available), whether or not the user is in Developer Mode, and the instance slug. Learn more.
• Updated the Look Validator to improve design and include the ability to replace the name of fields, views, explores, and models regardless of the error. Learn more.
• Fast File Switching. The LookML development IDE now instantly switches between files and does not require a full page reload.
• flash_on Truncated SQL Runner Table List. The SQL Runner limits the table preview list to 500 to limit browser impact.
• Completely removed the scoping parameter. Learn more.

Dialects

• BigQuery:
  • Fixed an issue where Symmetric Aggregates could be incorrectly calculated in the presence of negative numbers.
  • Improved the efficiency of the week timeframe.
  • Improved the behavior of measures in fanout_on fields.
• Snowflake:
  • Added information about whether PDTs are functioning.
• flash_on Hive:
  • Hive version 1.2 is the minimum supported version (rather than Hive version 0.13).
  • Hive now uses LIKE instead of regular expressions for string filtering.
• Spark:
  • Looker now uses HiveQL 1.2 instead of HiveQL 0.13 syntax.
• Presto:
  • Incorporated the standard Presto JDBC driver (version 0.149). Learn more.
• DataVirtuality:
  • Added an SSL option in Looker's connection panel.
  • Fixed an issue where DataVirtuality didn't properly load error messages.
• flash_on MS SQL:
  • Updated the JDBC driver to v4.2. Note that SQL Server 2005 will no longer be supported.

General Tweaks and Bug Fixes

• flash_on API (beta) Changes:
  • Ensured that JSON format will return the values of type: number fields as numbers rather than strings. Learn more.
  • Replaced the run_async and create_query_and_run_async routes. API users should transition to the create_query_task route.
• Performance and Stability Tweaks:
  • Improved performance when fetching cached results.
  • Reduced memory usage when reading from and writing to the query cache.
  • Changed the way Looker connects to internal MySQL databases to make the connection more robust.
• Visualization Bug Fixes:
  • Fixed an issue where maps did not work with hidden columns when table calculations were present and all measures were hidden.
  • Fixed an issue where right padding on charts could be misaligned.
  • Fixed an issue where the value format of table calculations did not appear on the y-axis of a visualization.
  • Fixed an issue where time label format would only work with a label rotation value.
  • Fixed an issue where visualizations would render empty if a min or max y-axis value was used with a log scale type.
  • Fixed an issue where a chart warning could push the x-axis out of view.
• Addressed an issue where different Looker systems could process and sort results in different orders across various areas (dashboards, Explores, downloads, etc.).
• Fixed an issue where the visual indication that a filter input box was looking for suggestions failed to appear or continue to disappeared while running.
• Fixed an issue where labels were inconsistently truncated on PDF downloads.
• Text tiles on LookML Dashboards no longer produce "Element must specify an explore" warnings.
• Fixed an issue where gear menus from fields in tables would overlay empty state messages on the data table.
• Fixed an issue where the default value for a dashboard filter was not properly integrating with other filters if set up to do so.
• Fixed an Issue where embedded dashboards could return empty results on the first run.
• Fixed an issue where custom filters using yesno dimensions could produce incorrect SQL.
• Fixed a bug where extended explores incorrectly returned the error "ignore unexpected list of fields in explore".

Looker 3.50 2016-07-05

flash_on Legacy Feature Updates

The following 3 features are being turned off and will be removed entirely in 3.50:

• $$ substitution
• Joins declared in views
• LookML "scoping" Parameter

Details on how to migrate off these features can be found in this Community topic.

Visualizations

Trend Lines [Labs] and Reference Lines

• Added the ability to specify the location of reference line text. Options are Left, Right, Center. Learn more.

• Added the ability to specify trend lines.

  • Options include linear, exponential, logarithmic, and moving average.
  • Moving average type has options for 7, 14 and 28 as it is typically used for days.
  • Any number of trend lines can be added.
  • Each trend line can be set to a specific series.

  See documentation: Area Charts - Bar Charts - Column Charts - Line Charts - Scatter Charts

Plot Region Data on Interactive Maps

• U.S. Zipcode Tabulation Areas and U.S. Counties Map Layers. These new map layers can be used on the interactive map. The zipcode field type automatically works with the interactive map. Learn more.
• TopoJSON Map Layers on Interactive Maps.
• All existing TopoJSON map_layers in LookML now work on interactive maps, including built in maps like Countries, U.S. States, and U.K Postcodes, and the new Zipcode and County layers. Learn more.
• Added a heatmap opacity setting and now map labels can show above or below the heatmap. Learn more.

Explore

Custom Filters

See documentation: Custom Filters & Looker Expressions

• Full control over filter logic via ANDs, ORs, and parentheses
• Access to same functions available in table calcs
• Can be used in conjunction with regular filters
• Contextual help pane

Table Calculations Enhancements

See documentation: Table Calculations & Looker Expressions

• New running_product function. See documentation.
• New pivot_where function allowing references to pivot values based on content instead of position. See documentation.
• New pivot_offset_list and pivot_column functions. See documentation.
• New log function. See documentation.
• Yes and No have now been added as constants that can be referenced in functions. See documentation
• New editor including type-ahead assistance, in-editor documentation, and links to the relevant documentation website pages. See documentation.

Improved Explore URLs

The explore page URL now has a shorter, more stable, format and the URL does not contain filter values or other data. Learn more.

Powered By Looker

• Embedded Explore pages now broadcast a JavaScript event whenever the page state changes. Enables the ability to build a custom saving mechanism for embed users. Learn more.
• Support for wildcard subdomains in the embed domain whitelist. This makes it much easier to whitelist groups of embedded domains.
• Fixed an issue where downloading a PDF from an embedded dashboard did not work.
• Fixed an issue where filter values on embedded dashboards did not wrap properly.

Scheduler

• Improved unsubscribe flow for scheduled content.
• Text objects on Dashboards will now appear in Dashboard PDFs.
• When scheduling content, the To section now accepts comma-separated lists of email addresses.
• The schedule reassignment modal (accessed via admin/scheduled_plans ) now includes the name of the Look or Dashboard.

LookML

• **Added date_start and date_end to date filters**. This allows the beginning and end dates in a date filter to be explicitly referred to in LookML. This is useful for table wildcard functions in BigQuery or partitioned columns in Hadoop.
• PDT Trigger Check / Regenerator can now rebuild tables concurrently. See documentation.

Dialects

See dialect support level definitions.

• flash_on Changes to Database Connection Credentials. Looker will no longer pass authentication information through the driver's connection string and will instead pass credentials as part of the connection properties. Learn more.
• Denodo. Added Level 2 support. See documentation.
• flash_on Oracle. Changes to database connection configuration. See documentation.
• Snowflake. Queries now support timezone conversion. This change will enable features like User Specific Timezones on Snowflake. Learn More.
• Presto. Added support for PDTs.
• flash_on Vertica. Updated the Vertica 7 connection to Vertica 7.1 (Vertica 7.0 users should use the Vertica 6 connection; to use all Vertica 7 features, update Vertica to 7.1 and connect with that option)
• Teradata Presto. Added support for version 141t. For more details on connecting, open a support request.
• Hive. Deprecating support for 0.13. This is the last Looker that will support Hive version 0.13. Starting with 3.52, Looker will support Hive version 1.2+.

Administration & Security

• Additional Sub-Admin Permissions. Permission to view the PDT panel can be given with the see_pdts permission. See documentation.
• Usage panel update. Can now be downloaded as a PDF. See documentation.
• Connections page update. Offer to configure PDT support exists only if the dialect supports PDTs. See documentation.
• Regenerator based PDT builds now appear in query panel.

General Tweaks and Bug Fixes

• Restored the ability to color values in Single Value visualizations. See documentation.
• Model sets on the admin/model_sets/new page will now appear in alphabetical order.
• Updated 404 Message to let users know that either the page is not found or they do not have access to view it.
• Fixed an issue that caused filter input boxes to take up unnecessary space.
• Fixed an issue where scheduled tasks could temporarily be sent from a staging instance.
• Fixed an issue where text objects caused LookML Dashboards to break.
• Fixed an issue where scale types didn't update correctly when switching series positions.
• Fixed an issue on PostgreSQL with slow relative date filters.
• Fixed an issue where errors due to ${TABLE} deprecation caused broken dashboards.

Looker 3.48 2016-06-08

Dashboards

flash_on Improved Dashboard PDFs

• PDF dashboard downloads now look like they do in the browser.
• Vector-based rendering allows zooming without losing quality.
• Note the following requirements:
  • Looker Labs feature must be enabled
  • The default layout for scheduled emails will change to the new format
  • Customer-hosted installations must be running PhantomJS 2.11. Check your version and update.

Explore

• Table Calculations editor now works properly with special characters or ambiguous calculation names.
• Single Value Visualizations have improved support for fields that display images via HTML.

LookML

• Faceted Filters enabled at an explore level when using access filter fields or sql_always_where: When an explore has sql_always_where or access_filter_fields set, full_suggestions defaults to true for all fields exposed by that explore. Individual fields can still opt out of full_suggestions query behavior by setting full_suggestions = false, and can opt out of suggestions altogether with suggestable = false. Learn More.
• New timeframe month_name. Dates can now be bucketed by name of month. Learn More.
• New can_filter Parameter: Accepts the inputs true or false. When set to false, the field cannot be used as a filter. This parameter can be applied to measures and dimensions. Learn More.
• Explore and View names can now start with numbers.
• Built-In Named Value Formats for British Pounds and Euros: gbp_0, gbp, eur_0, and eur. These are used as inputs to the value_format_name parameter. Learn More.
• Unsafe Liquid parameters have been deprecated with a Legacy Feature.

Dialects

• MySQL. Fixed an issue where NULLs would be filtered out of pivoted tables.
• Spark. Fixed an issue that was causing connections to break due to long index name values.
• Redshift. Provides a more useful error when Redshift Admin kill queries.
• BigQuery
  • Added support for User-Defined Functions (UDFs) as part of a PDT definition: Docs.
  • Streaming downloads are now possible
  • Fixed an issue where wide queries would fail in Looker
  • Updated to a new BigQuery driver that includes Google Drive support
  • Expanded the max field name length to BigQuery's documented 128 character length limit from the previous limit of 24 chars.
• Bityota. Removed support for Bityota
• Redshift & MS SQL. Limited the duration of the long running query statements Looker uses for query killing tests on Redshift and MS SQL.

Administration

User-Specific Database Connections

• Connections can be configured to use the user's LDAP credentials to connect to the database. Learn More.
• Allows user-specific, database-level permissions to be enforced within Looker, as well as query auditing.
• NOTE: public URLS and PDTs are not supported for these types of connections

New Sub-Admin Permissions

• New permissions for various admin panels can be granted to users without making them full-blown admins.

Documentation

• Added Looker versioning in documentation.
  • Use the Looker version selector in the upper right to select your version.
  • Versioning officially starts with 3.48 features but we have preserved some pre-3.48 version-specific content that can be viewed using the selector.
  • The Looker version selector appears on all pages in the "Exploring and Visualizing Data" and "Sharing, Importing, and Embedding Data" section and will gradually appear on all docs.looker.com pages.
• Added a button to jump back to the top of the page.
• Added +/- to the side menu to show when a menu item can be expanded.
• Moved the search bar to the top of the side menu.

General Tweaks and Bug Fixes

• flash_on Added a "Scheduled By" note to the bottom of scheduled emails.
• Fixed a bug causing a parse error in exploring from the SQL Runner.
• Fixed an issue that prevented suggestions from populating in filters that depended on some PDTs.
• Fixed an issue that caused LookML Dashboard elements to overlap when using layout: static.
• Fixed a bug causing the group by clause in the SQL related to some pivoted tables to call the wrong field.
• Properly warn when attempting to filter a measure on a raw timeframe.
• Fixed a few small table calculation bugs related to pivoted dimension handling.
• Fixed an issue with connectivity to the internal database (when using MySQL) which could lead to outages.
• Fixed an issue where instant dashboard would cause a dashboard not to return from cache if the prior run resulted in an error.
• Fixed a bug where Looker would incorrectly filter "empty" in "is equal to" string filter.
• Fixed an issue where Looker tried to convert timezone to '' certain generated SQL.
• Fixed an issue where filters on some date timeframes were generating incorrect SQL.
• Fixed an issue where scheduled dashboards could send from Dev mode.
• Removed an unneeded warning for unset database timezones in the Connections panel.
• Fixed an issue where field_group_label was causing an erroneous error.
• Fixed a few errors related to PDF downloads that reflected 'No Results' incorrectly.

Looker 3.46 2016-05-08

Dashboards

flash_on New Dashboard Look & Feel

• More modern aesthetic with font tweaks, better use of whitespace, and removal of clutter.
• Single values read more naturally with titles on the bottom.

flash_on Dashboard Edit Mode

• Once activated, provides the ability to move and resize tiles, add or edit filters and notes, and add/remove tiles to the Dashboard.
• This also introduces notices when saving Looks that show which Dashboards will be impacted by the changes.
• This feature is derived from and replaces the Lock feature that was in Labs.

Headers and Free Text Boxes

Allows for title, subtitle, and body text to be inserted into dashboards. Can be resized and arranged just like a regular tile.

Better Tile Dragging and Resizing

• Improved Dragging Logic makes it easier to move and resize tiles on dashboards.
• More Flexible Sizing for Dashboard Tiles Tiles now exist on a 24-across grid instead of a 12-across grid.

Visualizations

Single Value Visualization Enhancements

• Callout Numbers.
• Progress Bars.
• flash_on Dashboards auto-adjust text size so tiles all match.

Updated Column Truncation Logic for Table Visualizations

• Added seconds to the Dashboard Refresh function found in the gear menu on Dashboards.
• Browser tab titles now reflect dashboard names.

Explore

Table Calculations Updates

• New date functions
  • add_{interval}: add_seconds, add_minutes, …, add_years.
  • trunc_{interval}: trunc_minutes, trunc_hours, …, trunc_years.
• Date improvements. Comparison operators (>, <, >=, <=) now support dates.
• Improved field completions to include labels.
• flash_on ANDs now takes precedence over OR. In the past, these statements evaluated left to right, so existing equations that didn't use parentheses may change.
• Added the ability to filter on "is not" with day of week index.
• flash_on Increased checking for type mismatches to avoid errors. However, this change also means that if you need to modify any expressions where you compare yes/no fields to strings.

Scheduling

Webhooks for Scheduled Looks (Labs)

• New option when scheduling a Look or dashboard to perform an HTTP POST to one or more servers instead of emailing the results. Learn More.
• Use a service like Zapier or a custom web server to upload data from Looker to an S3 bucket, Dropbox, an FTP server, etc. See example with DropBox.
• Introduces a new permission send_outgoing_webhook that is automatically given to all Looker Admins, and is required to use this functionality.

Scheduling Updates

• Added a "Test" Button. Sends test email to the scheduler but not recipients.
• Added a Formatting Option. New option to use formatted values in CSVs, TXTs, etc. (just like with downloads).
• flash_on Timezones. Always explicitly set the timezone of a scheduled look and thus detach it from the application's timezone. The scheduling modal defaults to the application timezone when creating a new schedule. Changing the application timezone thus effects all newly created plans, but not existing ones.
• flash_on Scheduling Modal Changes. Full control over range of hourly option and improved UI.
  • Expanded the hourly range available.
  • Support for scheduling on a particular day of the week occurrence in the month was broken and has been removed. Current schedules set to run on a particular day of week and week of month will automatically be reassigned to the first day of the month.

LookML

• Improved reliability of the LookML Generator. The LookML Generator now only generates for the requested schema instead of always generating for the default schema as well, resolving issues with duplicate field definitions and "exists" errors for view files.
• New Value for Timeframes Parameter. Added day_of_year timeframe.
• New Filter syntax for filtering on Quarters. 2015-Q2 will now work in Matches(Advanced).
• flash_on LookML Deprecations. Learn More.
  • $$ substitution is now a legacy feature. It should be replaced with ${TABLE}.
  • Starting in 3.46, joins should only be defined inside an explore: definition. Defining a join: in any other location is deprecated.
  • The scoping parameter has been deprecated. Using scoping: false will now produce a LookML Validator error. Models should always use scoped field names.

Dialects

• dashDB: Now supports PDTs and Query Killing.
• Streaming Dialects. Aster, Data Virtuality, Exasol, Greenplum, Hive, Impala, Microsoft Azure SQL, Microsoft SQL Server, Presto, Spark, and Teradata. See the What are all the row limits in Looker? Best Practices page for more information.
  • Spark: Fixed issue that could cause filter suggestions to generate invalid SQL
  • Presto:
  • Now possible to create views from multiple catalogs in PrestoDB, not just the one specified in the connection.
  • Fixed issue where connection tests were remaining in the Presto queue.
• PostgreSQL Fixes:
  • Fixed an issue that caused filtering on a quarter to be incorrect.
  • Fixed an issue with slow queries using relative date filters.
  • Fixed an issue that caused uppercase letters to require quotes.

General Tweaks and Bug Fixes

• Added ability to search by models in Spaces.
• Instant Dashboards (Labs) now takes advantage of improved caching.
• Added a link to the instance in "Welcome to Looker" emails.
• Fixed a bug causing a slow resize of embedded pages.
• Fixed a bug on the LDAP Admin page that caused text values to overflow from form spaces.
• Fixed a bug for users of Microsoft Edge where visualizations didn't fill space completely.
• Updated the explanatory tooltip on see_lookml permission the permissions page to show that it also allows users to see SQL.
• Updated the tooltip text on the Generate Project Model page.
• Fixed a bug where large result sets were being put into cache and causing outages.
• i__looker updates:
  • Added embed_user as a join to the user explore
  • Added sql_text to history explore
  • Added links to admin/queries as well as schedule plan.
• Fixed a bug where disabled series' labels were remaining on vis.

Looker 3.44 2016-04-07

Important Changes

• Instant Dashboard is being removed as a feature. Dashboards will load more quickly from cache.
• Loading assets from CDN is now enabled for all Looker-hosted customers.
• Several Legacy Features are going to be turned off by default, but can be re-enabled. Learn More.
  • Field Labels Can Override View Label
  • Leading Period in Field Names
  • Upper Case Labels in Downloads and Chart Configurations
  • Send email from looker@looker.com
  • Default Redshift PDT Distribution Style EVEN

Dashboards

• Automagic Heatmaps: The "Fit to Data" feature is supported when using heatmaps.
• Improved Error Messaging on Dashboard Tiles. Incorrect filter syntax errors are now displayed.
• Fixed an issue where tiles were loading in a compressed way before properly filling the screen.

Visualizations

• Custom X-Axis Limits. Introduces a setting to show or hide the first or last X rows as specified by the user.
• Logarithmic Y-Axis is now available for charts.
• Fixed an issue with misaligned stacking pieces in stacked bar charts.

Scheduling

• New Scheduling Admin Panels
  • Scheduled Plans. Displays all currently scheduled items in your Looker instance with relevant details, including task owners.
  • Scheduled Job History. This section shows recently run items on your instance with details, including the query, runtime, and success or failure state with errors (if applicable).
• Looks can now have more than one schedule. Brings Look scheduling into alignment with how Dashboard scheduling works. Now, Look schedules are created per user, so different users can have different schedules for the same Look.
• New schedules will start at the first scheduled time. They will no longer send an email immediately after scheduling.
• Schedules that belong to a user who no longer exists in the system (i.e., they've been deleted) or have been disabled are automatically reassigned to the first enabled user with the "Admin" role.
• Fixed issue with dashboard display on the iPhone mail app.

LookML & the Developer Environment

• Custom Field Groups. Adds the ability to group fields together in the Field Picker using the new group_label: parameter. Learn More.
• Ability to Rename Projects. Accessible in the "Project Settings" option located under the Sync button.
• Updated Distance Field
• New In-App Links to Documentation applies to:
  • LookML validation errors, where applicable.
  • Applies to deprecated features and the Legacy Feature Panel to help transition off of old features.
• Multiple conditions in HAVING clauses and filtered measures now are always each wrapped in parentheses.

Dialects

• Spark/Hive Updates:
  • Fixed an issue where EXPLAIN was broken for Hadoop-related dialect issues.
  • Fixed an issue where SQL Runner queries were running slowly on Spark SQL.
  • Tests for PDTs are now run at connection time for Spark SQL.
  • Spark SQL now gets schema information from SQL instead of JDBC calls.

General Tweaks and Bug Fixes

• Update to the create_table_calculation Permission: Users now do not need the create_table_calculation permission to see table calculations. This permission is still required to create calculations.
• Fixed an issue where switching into dev mode while looking at a file that only exists in production caused an immediate 404.
• Made updates to the Explain function in the SQL Runner to apply more dialect-specific functionality and remove forced limits.
• Fixed a bug where table calculations didn't work when exploring queries from the SQL Runner or i__looker.
• Fixed a bug in which one failed SAML validation would cause all subsequent checks to fail, even with a valid file.
• Fixed an issue where a new version of Chrome was causing dashboards to crash the browser.
• Fixed a bug where dashboard changes were not being reflected due to caching.
• Fixed a bug where filtering on nulls as strings did not work.
• Fixed a bug that made navigating LookML files in Developer Mode very slow.
• Override a chat client setting that caused the chat window to open unnecessarily.

Looker 3.42 2016-03-13

Lookerbot

With Looker 3.42, we unveiled the Lookerbot, a Slack integration with Looker that allows you to bring Looker data into your chats.

Labs Features

• LookML Extensions is no longer a Labs features, and will be automatically available for all instances. Learn More.
• Drill Menus for Visualizations: See below.

Drilling Updates

Drill Menu

• Clicking on a drill link now always shows the drill menu. The ... is used to indicate external links and/or dashboards. Hierarchical and dimensional drills will not display this icon.

Drill Preview

• Drilling loads the results of the drill in a preview overlay. This keeps users in the same context (i.e., on the same Explore page or Dashboard). Users can then choose "Explore From Here" to jump into the full Explore experience. Learn more.
• Measures with only one drill possibility directly open the Drill Preview.
• If there is a problem with Drill Preview, it can be disabled by enabling the "Legacy Drill Behavior" on the Legacy Features panel. Read more about Legacy Features.

Drill Menus for Visualizations

• Enables drilling into visualizations via drill menus. This is now the default behavior and has been removed from the Labs section. Learn more.
• Drill menus on visualizations other than tables, single value, and single record no longer show the "Filter on..." drill options.
• Drill menus work on pivots in both tables and visualizations.

Visualizations

Table Visualization Improvements

• Columns can be renamed, including the names of pivoted columns. Learn more.
• Styles can be applied to tables, including black & white, transparent, and greyscale. Learn more.

Totals Labels for Stacked Charts

• There is a new "Totals Labels" option for stacked column, bar and area charts. Learn more.
• There is a new "Show Silhouettes" option. When series are deselected in a stacked chart, a gray bar ("silhouette") shows the total of all series behind the subtotal of selected series.
• Important note: row totals in the data table will no longer display in stacked charts.

Map Layers in LookML

• The relationship between a dimension and a particular set of map regions can now be defined in LookML, rather than requiring each visualization to configure a custom TopoJSON URL. This affects the "Static Map (Regions)" visualization. Learn More.

Powered by Looker

JavaScript API for Events

• Embedded dashboards can now communicate out to their parent page. Learn More.

New URL Parameters to Customize Embedded Objects

• Ability to hide the title.
• Ability to hide the footer.
• Option to redirect an embedded Look to the explore page version by adding /explore to the end of the URL.
• Option of linking to the explore page with the Field Picker open. Learn more.

Dialects

• Raised the default number of database connections from 30 to 75 for Microsoft SQL Server, Redshift, PostgreSQL, and MySQL connections.
• Retired Spark 1.3. Spark customers should use 1.4 or higher.
• BigQuery:
  • Fixed an issue where counts with filters, on a fanned field, was not working.
  • Fixed an issue that caused a 500 error when generating tables.
  • Fixed an issue where text suggestions sent up "undefined".
• Updates to Timeframes
  • hour and hourX now return values in the form YYYY-MM-DD HH.
  • minuteX now returns values in the form YYYY-MM-DD HH:MM (matching the minute timeframe).

General Tweaks and Bug Fixes

• PDFs and scheduled visualizations will now have darker text for increased readability.
• Tooltips on charts now reflect custom axis names.
• Added the ability to set a custom mailer port via Looker command line options (Option is: --default-mailer-port=[port number goes here]).
• Allow the ability to hover over sections of a chart that are mostly composed of tooltips and still get the tooltip to appear.
• Fixed a bug where items scheduled to send on Sunday were also being sent on Monday.
• Fixed a bug in which filter values would duplicate and overwrite one another when adding multiple input boxes per filter.
• Internet Explorer Fixes:
  • X-axis labels will now appear.
  • Fixed an issue in which legends in charts caused errors when charts were too small.
  • Fixed an issue that was causing multiple vertical scrollbars to appear when only one was necessary.
• Fixed several issues pertaining to Automagic Heatmaps, in which they weren't properly loading or reloading with changes.
• Fixed a bug where adding and removing a note would mess up alignment on dashboard tiles.
• Fixed an issue where Time Label Format was inconsistent between Explore and Dashboard.
• Fixed an issue where publicly embedded tables were not sortable.
• Fixed an issue where some queries with No Results incorrectly return as "Query Killed" in SQL Runner.

Looker 3.40 2016-02-25

Dashboards

• Lockable Dashboards [Labs]. Prevent changes to a dashboard without explicitly unlocking it. The feature also surfaces additional information to users about the connections between editing Looks and editing Dashboards for all viewers of those pieces of content. Must be explicitly enabled in the Labs section.
• Automatically Link Across Dashboards [Labs]. Provides a drill menu to surface and link to dashboards that have a filter matching the field you are drilling on. The menu will also surface links to external URLs using native drills, although those are available without enabling the drill menu. Learn More.

Visualizations

• Table Visualization
  • Truncate column names to reduce width of columns.
• Pie Chart Improvements
  • Cleaned up the presentation and positioning of value labels.
  • Series Labels now function on pie charts.
• Drill Menu in Visualizations [Labs]. Drill into the data directly from a visualization rather than through the table. Learn More.

Explore

• Table Calculation Updates
  • Allow the removal of table calculations from the data table instead of forcing user through the table calculations modal.
  • The percent format will now multiply by 100.
• Filtering Updates
  • Queries that produce suggestions for filters now do not time out when users click out of the filter box.
  • Filters on type: tier now work even with negative values.
• Data Table Updates
  • Dates in tables now do not wrap. (Note: This may widen date columns, changing users' tables).
  • Tables switch to virtual scroll at 10,000 cells instead of 5,000.

Dialects

• Presto is now a fully supported dialect. Looker 3.40 will support versions up to 0.132 natively. For later versions, contact support.
• Spark is now a fully supported dialect. Looker 3.40 will support versions up to 1.5.2.
• Hive: Auto suggestions are now automatically disabled on filtered fields. To re-instate suggestions for any given view file, comment out the line suggestions: false. Additionally, field-specific settings override the view-level default. Also applies to Presto and Spark.
• BigQuery: Symmetric Aggregates are now supported.
• BigQuery: Service account no longer needs read permissions on every dataset in a project.
• DataVirtuality: Fixed issue with query killing.
• Vertica - The dialect picker on the connections panel now includes "Vertica 6" as an option for those customers with Vertica 6 drivers. The "Vertica" option is for customers with Vertica 7 and above.

Admin Panel

• Query Panel. PDTs now differentiate between Building PDT and Waiting for PDT, which means that the waiting query needs a PDT which is being built by a different thread. While it is waiting, it is not holding a connection from the DB pool.
• Authentication via LDAP. Configure servers that don't allow paginated results. See full LDAP documentation here.
• Option to Force Two-Factor Authentication on Every Login. Available as a configuration setting on the Two-Factor Admin page.

General Tweaks and Bug Fixes

• LookML <> SQL Update: Updated the way multi-item WHERE clauses are written from WHERE A AND B to WHERE (A) AND (B) to ensure proper parentheses in more complex WHERE clauses.
• Fixed a bug where sorts on tables weren't being passed through to the dashboard.
• Fixed a bug where Explore permissions were being shared across Roles.
• Fixed a bug where LookML Dashboard embed using / rather than :: does not render correctly.
• Fixed a bug where sorting on measures in table visualizations was broken.
• Fixed a bug where relative date filters were breaking with Matches (Advanced).
• Fixed a bug where PDT builds were locking up all queries on a Looker instance.
• Fixed a bug where value_format was not properly passing through decimal points to display, especially on percent_of_total and percent_of_previous fields.
• Fixed a bug where single value visualizations continued to display their previous value if the new value was null.
• Fixed a bug in the prefetching code that mistakenly produced 200 responses when 404s should have been provided, for example if the prefetch fails due to an error in one of the tiles.
• Fixed a bug where the trash icon in the color picker wasn't doing anything when clicked.
• Fixed a bug where drillable single value tiles on dashboards were changing colors sporadically.

Customer-Hosted Installations

• Added check to deter downgrade in the startup process. Learn More.

Looker 3.38 2016-01-12

Dashboards & Visualizations

• Reorderable Filters. The order in which filters are displayed can now be configured in the Add/Edit Filters options found in the gear menu on Dashboards.
• Tiny Charts. Dashboard visualizations are simplified as they are reduced in size to allow for smaller-than-ever dashboard tiles that still contain readable information. Learn More.
• Column Limit Warnings in Dashboard Tiles. Since visualizations that reach a column limit can produce inaccurate charts, Looker now surfaces a warning inside the visualization panel, and on dashboard tiles, for improved data interpretation.
• Charts with pivots, or multiple measures with the same value_format, now apply that format to the axis tick marks.

Powered By Looker

• Custom Styling for Embedded Dashboards. Includes background colors, chart colors, font colors, and more. Applies to both LookML and Drag and Drop Dashboards. Learn More.

Explore

• Table Calculation Updates
  • Ability to drag and rearrange table calculation columns.
  • Introducing a new rand() function. Learn More.
  • Table Calculation names are now required to be unique.
  • A formatting drop-down now surfaces a list of named, common value formats. This eliminates the need to type in formatting strings.
    

LookML

• Select Starting Day for Week Dimensions. New parameter week_start_day allows setting the start of a week (for example, Sunday instead of Monday) for each model. Learn more.
• Named Value Formats. Adds the ability to name and reference specific value formats using value_format_name. Looker includes several common, named value formats by default. Learn More.

Dialects

• Updated Dialect Options. The dialect picker on the connections configuration now includes specific options for Amazon Aurora, Google Cloud SQL, Microsoft Azure Data Warehouse and Microsoft Azure Database. We recommend updating your connections to reflect the correct dialect so that you can take advantage of future dialect-specific improvements.
• Basic support for SAP HANA.
• BigQuery project names that include characters like : and . now work properly.
• Fixed an Impala issue preventing queries from being killed in some cases.

Admin

• Implemented per-user query throttle to prevent any individual user from overwhelming or locking up the database. Learn More.

General Tweaks & Bug Fixes

• Added a button to refresh schemas and tables in the SQL Runner and view generator.
• Save Dashboard to Space modal now leverages the Hierarchical Space Picker.
• Host URL can now be set via provision.yml file.
• Fixed an issue causing fields to be missing from generated Dashboard LookML.
• Fixed Source for Dashboard queries to restore prior analytics in the Usage Panel.
• Fixed an issue with Excel downloads that caused them to use up too much memory.
• Fixed an issue with Excel downloads that caused excess whitespace to be inserted into downloads.

Legacy Features

Please note the upcoming changes to Legacy Features to ensure a smooth transition as features are removed. Learn More.

Newly Deprecated Features

• LookML decimals Parameter and int Field Type. The decimals parameter and int field type are now deprecated and will display warnings in the LookML validator.

  Named value formats now offer a more flexible alternative to decimals, including decimal, percent, and financial formats. For example, please use value_format: decimal_2 or value_format: '0.##' in place of decimals: 2.

  Replace type: int dimensions with type: number. Learn More.

Legacy Features removed in this Looker 3.38

• Old Field Picker

Legacy Features to be removed in Looker 3.40

Please transition off of these features over the course of the next month prior to your next update.

• Field Labels Can Override View Label
• Leading Period in Field Names
• Upper Case Labels in Downloads and Chart Configurations
• Send email from looker@looker.com

Legacy Features to be removed in Looker 3.42

Please transition off of these features over the course of the next 2 months.

• Default Redshift PDT Distribution Style EVEN

Looker 3.36 2015-12-08

Labs Features

As of 3.36, Looker has an expanded definition of Labs features. In addition to those experimental features that exist on the Labs page, select features throughout the application will be presented as part of the Labs program to let users know that they are still being considered for additional functionality.

• New & Improved SQL Runner with an updated interface and the ability to share, download, and explore from SQL queries. This feature will automatically be on for all instances. Learn more

Explore

• Table Calculations for Pivot Rows. Additional functions enabling aggregates across pivot rows, cleaner complex offset computations, and row-level aggregates. Learn more about pivot rows, offset lists, or lists
• Updated Dashboard Modal. Shows the type of visualization added to increase clarity while building dashboards.
• Share Public Look as Images. Easily share visualizations as a static image that updates as your data does. Learn more
• Row Limit Warnings for Scheduled Looks. Items scheduled from the Explore page will include warning in email.
• Restored the ability to copy/paste table headers from the Explore page.
• Updated the Make Public Modal to require a user to press Save to enable public links.

Dashboards & Visualizations

• Dashboard Tiles Now Grey Out on Run. Provides visual clarity on running tiles.
• Dashboard Stop Button. Displayed while queries are running.
• Single Value Visualizations Color Setting. Learn more
• API for Prefetching Dashboards. This will allow Lookers to take advantage of a robust data pre warming system.

LookML

• New Parameter distribution_style with possible values ALL or EVEN. This allows an explicit choice between all vs. even diststyle in persistent derived tables not distributed by key. Applies only to Redshift. Introduces a legacy feature, which preserves the old default of even distribution. 3.36 forward will default to ALL diststyle.
• Time Fields Now Generate all Timeframes by Default. Previously users specified an enumerated list of timeframes that they want. Users can still specify a list to get a subset of timeframes.

Powered By Looker

• Embedded Dashboards with User Timezones. Instance allows user timezones and connection is configured for timezones. Embedded dashboards will no longer show timezone mismatch warnings.

Spaces

• Spaces now show all subspaces instead of limiting to four.

Admin

• Permissions Updates.
  • Permission Page now reflects Permission Dependencies
  • Users must have the download or download_with_limit permission to download Dashboard PDFs
• LDAP configuration changes. Now allows an admin to say which user attribute to use for searching. This enables mapping LDAP groups to Looker Roles if using the posixGroup style.

Dialects

• Increased DataVirtuality Support. Added support for Symmetric Aggregates and fixes for day_of_week parameter.
• Increased DashDB Support. Query killing is not yet available.
• Increased Exasol Support, including PDTs
• BigQuery. Update for FLATTENS to allow for multiple fields not on same branch of tree

General Tweaks & Bug Fixes

• Looker now supports improved navigation by keyboard keys for greater accessibility.
• Browser tabs now indicate the part of the app being used on each tab.
• Fixed an error where Save Look Modal opened with an error.
• Improved the error messaging when column limit reached for pivots.
• Fixed a bug causing visualizations to error out inaccurately.
• Fixed an issue where dashboard tiles gear menus were overflowing the screen and thereby not selectable.
• Fixed an issue where dashboard element wasn't reflecting sorting done on the Explore page.
• Fixed a bug where clicking "Add to Table" on a filter removed the Filter from the query.
• Fixed a bug where Automagic heat map breaks if join does not include xxx_bin_level in fields parameter.
• Fixed a bug where the Run button occasionally would not show up on an embedded Dashboard.
• Fixed a bug where an XLS file didn't download properly due to excess whitespace.
• Fixed the Move Space modal.
• Fixed an issue where saving over a Look added it to a Dashboard twice instead of updating the Look.
• Fixed a BigQuery bug in which create view from table can't generate LookML for projects with deprecated project names containing . and :.
• Fixed a bug where, in an embedded context, users could use hotkeys to open the edit dashboard modal and chose looks modal.

Looker 3.34 2015-11-10

Visualizations

• New Visualization: Interactive Maps. New maps zoom and pan, and are reactive to filter changes. Learn More.
• Color Improvements for Charts. Learn More.
  • New series of color palettes that can be used in visualizations.
  • New color picker to assist in selecting new chart colors.
  • Global default color scheme can be applied across the entire instance. Learn More.
• Ability to Sort by Series in Visualizations. Sort the row total in the table to see the information in the chart displayed in order of ascending or descending row totals.
• Updated Tooltips for readability.

Dashboards

• Asynchronous Dashboard Loading. Tiles now load as their data returns from the database, instead of 2 at a time, to aid in faster loading of cached dashboards.
• More Informative Error Messaging on Dashboards. Dashboard tiles will now display the error that has prevented them from rendering, instead of merely showing that an error has occurred.
• Removed the ability to change Dashboards back to "Drag" layout. "Newspaper" layout is now the preferred layout for all drag & drop dashboards.

Explore

• More Granular Scheduling Options. Includes multiple hours, different days of the month, and on weekdays only. Learn More.
• Ability to Sort by Row Totals and Table Calculations.
• In-modal Look Editing. Keeps users on the page that they accessed the modals from for increased context in the app.
• Improved Public Link Workflow. It is no longer required to refresh the page to see the associated public links after marking a Look as public.
• Ability to Issue Queries Without ORDER BY Clause. Looker will not generate an Order By clause if the first field in the table is a cancel_grouping_field and there are only dimensions in the query. This can be used to reduce the size and complexity of a query in certain cases.
• Improved Suggestions for Filtering.
  • Suggestions will now properly populate from a view that is defined using the sql_table_name parameter.
  • "Day of Week" and "Day of Week Index" timeframes now suggest days instead of timestamps.
  • See additional changes in the LookML section below, including how to make suggestions work with access filters.
• Updates to Filtering for type: location Fields.
  • Added radius-based filtering.
  • Added support for null, not null and -null in filtering. The location field is considered null if either latitude or longitude (or both) is null.

LookML

• New quarter Timeframe. This timeframe can be created as part of a dimension group or as a standalone dimension. Learn More.
• New quarter_of_year Timeframe. This timeframe returns Q1, Q2, Q3, and Q4 independent of the year and can be created as part of a dimension group or as a standalone dimension. Learn More.
• Suggestions for Access Filters. Suggestions can be enabled when using access filter fields by utilizing the full_suggestions: true parameter. Learn more.
• Configurable Suggestions Caching. Suggestions can now be cached for the time of your choosing. Set these on a per-field basis using suggest_persist_for followed by a timeframe. If no suggest_persist_for is set, the default time remains 6 hours.

Powered By Looker

• PDF Downloading for Embedded Dashboards. Permissions are configured in the same way as for regular Looker Users and Roles.
• All Download Types for Embedded Elements. Permissions are configured in the same way as for regular Looker Users and Roles.
• User Timezones for SSO Embedding. Set the parameter as part of the SSO embed setup process.

Dialects

• Expanded BigQuery Support (additional nuance), including:
  • Query Size Estimator to help manage query usage.
  • Nested and repeated data supported natively in LookML using the fanout_on parameter. Learn More.
  • PDTs to optimize querying.
  • Job Canceling for queries.
  • Generator Improvements, especially for nested and repeated data.
  • .p12 Certificates support arbitrary passphrases and are now uploaded via Looker.
• Microsoft SQL Data Warehouse Improvements:
  • Persistent Derived Tables are now supported.
  • Symmetric Aggregates are now supported.
• Hive & Spark: Fixed an error with week truncation.
• Vertica: Fixed query killing.

Admin

• PDT Panel on the Admin page now reflects shared PDTs.
• Added a URL to the modals in the Query panel, so that you can return to the data about those queries.
• Updates to the i__looker model & Usage panel:
  • Fixes query most recent run at time.
  • Adds most recent run time.
  • Makes user roles into a list.
  • Fixes dashboard scheduled task email list.

General Tweaks & Bug Fixes

• Scheduled Email Attachments for the iPhone iOS Mail Application. Fixed a bug that was preventing this functionality.
• Added Text Editor Modes. Set the mode on a per-account basis . Options are "vim" and "emac".
• Fixed a filtering issue where commas were not properly being escaped.
• Fixed an issue where some LookML errors were not being caught by the validator.
• Fixed a bug in which .iqy files were not carrying value format through to the Excel file.
• Fixed a bug where trying to delete a model with a space in the name caused a 404.
• HTML Sanitization whitelists are no longer configurable. All HTML specified in LookML is stripped of JavaScript tags and attributes, and all other valid HTML tags are allowed.
• Looker now supports using an "external" cipher key that is managed in an external file specified to Looker on the command line.
• Looker 3.34 will also see the introduction of a CDN for our static assets.
• Improved security for JavaScript files via SRI Integrity matching for browsers that support this new security feature.

Behavior Changes

• LookML Dashboard Changes: When you copy the LookML that Looker generates for a visualization, keep in mind ...
  • You cannot set floats or integers to "" without an error.
  • If a Dashboard's LookML has the column_limit set to an empty string (""), the column_limit is converted to nil.
• Liquid Templating Changes for All Customers: JavaScript in Liquid templates will no longer work as of 3.34. Neither