kitta65 / lkmlfmt Goto Github PK

Hey - I love the project, thank you for sharing it.

We found a little bug when formatting this:

sql: ${recurring_referral_value}/IFNULL(${exchange_rates_first_month.rate},1) ;; #  + ${overage_value}/IFNULL(${exchange_rates_first_month.rate},1) ;;

It became:

sql: #  + ${overage_value}/IFNULL(${exchange_rates_first_month.rate},1) ;;
      ${recurring_referral_value}
      / ifnull(${exchange_rates_first_month.rate}, 1)
    ;;

Which strangely, Looker was happy with.

I'm not sure what it should be instead - perhaps removing the comment is the most correct thing here?

We changed it manually and removed the comment and it reformatted to :

    sql:
      ${recurring_referral_value}
      / ifnull(${exchange_rates_first_month.rate}, 1)
    ;;

Looker (original) only changes

Breaking

API 3.0 and API 3.1 have been removed in Looker 23.18.

Breaking

Clustrix database support has been removed. Any existing connections to a Clustrix database will fail to run in Looker 23.18.

Changed

Performance improvements have been made to query preparation time by front-loading LookML model compilation during production deployments.

Changed

To prevent confusion with SSO authentication, the SSO embed feature has been renamed Signed embed.

Feature

The Get embed URL option from a dashboard, a Look, or an Explore can now generate a
signed embed URL.

Feature

Embedded Looks now support themes, so the Get embed URL dialog now shows a theme selector for Looks.

Feature

The manage_project_connections_restricted permission lets users edit a subset of settings for new and existing connections.

Feature

The New Schedules Page Labs feature updates the interface of the Admin settings - Schedules page.

Fixed

An issue with drilling for transposed tables has been fixed. Drilling for transposed tables now performs as expected.

Fixed

The Box Shadow theme now performs as expected for static and tile LookML dashboards.

Fixed

Fixed date field values were not being displayed correctly when referenced by Liquid in the label or html LookML parameter. This feature now performs as expected.

Fixed

Unreferenced custom fields from drill URL have been removed.

Looker (Google Cloud core) and Looker (original) changes

Announcement

Looker 23.18 includes the following changes, features, and fixes.

Expected Looker (original) deployment start: Monday, October 16, 2023

Expected Looker (original) final deployment and download available: Thursday, October 26, 2023

Expected Looker (Google Cloud core) deployment start: Monday, October 23, 2023

Expected Looker (Google Cloud core) final deployment: Friday, November 3, 2023

Feature

Public preview of the SQL Interface, which uses JDBC to access LookML models in third-party applications such as Tableau, is now available. For Looker (original) instances, you must enable the SQL Interface Experimental Labs feature on the Looker instance. (Only Looker-hosted instances support this Labs feature.) For Looker (Google Cloud core) instances, you must fill out the Looker SQL Interface Pre-GA Agreement interest form. The Google team will enable your instance for the SQL Interface feature.

Looker (Google Cloud core) only changes

Announcement

IAM permissions have been clarified and made more visible in the Looker (Google Cloud core) documentation.

Changed

The in-app support in the Help menu has been updated to integrate with the Google Cloud console. You will see in-app support only if you have purchased at least a Standard Support service with Google Cloud Customer care.

https://cloud.google.com/looker/docs/release-notes#October_11_2023

33b1ca6

Looker (Google Cloud core) and Looker (original) changes

Announcement

Looker 24.2 includes the following changes, features, and fixes.

Expected Looker (original) deployment start: Tuesday, February 20, 2024

Expected Looker (original) final deployment and download available: Thursday, February 29, 2024

Expected Looker (Google Cloud core) deployment start: Tuesday, February 20, 2024

Expected Looker (Google Cloud core) final deployment: Tuesday, March 5, 2024

Breaking

Duplicate join names will throw a new model-level LookML error during validation.

Breaking

A new LookML warning has been added for having convert_tz in a date_raw field, since convert_tz has no effect on this type of date field.

Feature

Theming and external_group_id support has been added for Signed URL Builder.

Feature

The following permissions are now generally available to use in permission sets: manage_groups, manage_roles, manage_user_attributes, manage_embed_settings, manage_themes, manage_privatelabel.

Feature

A new Dashboard Diagnostics System Activity dashboard is available for troubleshooting the performance of individual dashboards.

Feature

The looker_internal_email_domain_allowlist user attribute is now generally available. This lets admins configure the Email Domain Allowlist for Scheduled Content feature on a per-group basis.

Feature

The Chart Config Editor now supports customizing tooltip content and styles.

Fixed

Filters on yesno fields will no longer show the "is not" option.

Fixed

An XSS security issue in Grid code has been fixed.

Fixed

Size-by field rendering for scatter charts has been fixed. This feature now performs as expected.

Fixed

An issue where download and Explore options were showing up on drill modals for merged queries when the user did not have permission has been resolved. This feature now performs as expected.

Fixed

Previously, text truncation wasn't working properly on headers on small tiles. This feature now performs as expected.

Fixed

Waterfall charts now render all available columns as expected.

Fixed

BigQuery: Previously, if OAuth tokens were passed through as query parameters rather than in the authentication header, Looker would return the following error: "OAuth token was passed in the query parameter. Please send it in Authorization header instead."

The BigQuery driver has been updated, so this error will no longer appear.

Changed

The minimum Git command line version has been increased to 2.36.0+.

Changed

The user interface of the Admin Settings - Schedules page has been updated.

Looker (original) only changes

Changed

For instances with offline licenses: When an offline license expiration date is less than 14 days away, Looker admins will see a license expiration banner on all Looker pages.

https://cloud.google.com/looker/docs/release-notes#February_14_2024

Looker (Google Cloud core) and Looker (original) changes

Announcement

Looker 23.20 includes the following changes, features, and fixes.

Expected Looker (original) deployment start: Monday, November 13, 2023

Expected Looker (original) final deployment and download available: Thursday, November 30, 2023

Expected Looker (Google Cloud core) deployment start: Monday, November 13, 2023

Expected Looker (Google Cloud core) final deployment: Tuesday, December 05, 2023

Breaking

Drilling on a scatterplot with quadrants and a size-by field shows all data points.

Changed

References to history_id are being replaced with a slug for query event tracking.

Changed

The Data history playback feature requires users to have the explore role permission in order to use it.

Changed

Upgraded Chronicle F1 JDBC to 0.0.5.

Changed

Upgraded org.json:json version to 20231013.

Feature

Admins can now restrict non-admins from accessing the dashboard auto-refresh option.

Feature

A feature has been added that lets users move dashboard tiles to the left or right side.

Feature

A menu option to resize dashboard tiles to standard sizes has been added.

Feature

Added Quick Layout for dashboard editors behind the dashboard_layout_accelerator feature flag, which is set to ON by default for all customers besides core instances.

Fixed

Previously, malformed type declarations in a dimension_group would crash the LookML validator. This issue has been fixed.

Fixed

A broken "Go to LookML" link on the Explore page has been fixed.

Fixed

An issue with bind_all_filters not pushing custom filter expressions down into NDT queries has been fixed.

Fixed

Number filter of type "between" reverted to type "is" when the first number was entered. This issue has been fixed.

Fixed

The Databricks JDBC driver has been updated from 2.6.27 to 2.6.32.

Fixed

Previously, resizing Google Maps immediately after loading could produce an error. This issue has been fixed.

Fixed

An issue with configuring an SMTP server has been fixed, and the fields (Mail Server, From, User Name, Password, Port) have been made mandatory on the UI.

Fixed

Custom value formats are no longer double escaped in table chart and table legacy.

Fixed

Previously, conditional formats such as "[>=1000] $#0.00,k; $#0.00" did not properly format negative numbers in Tables and Legacy Tables. This issue has been fixed.

Fixed

Explore AND/OR Filters "is" (relative interval) option for date filters.

Fixed

AND/OR filters no longer highlight required filters in red.

Fixed

AND/OR filters now improve browser performance by delaying fetching suggestions until the user interacts with the filter.

Looker (original) only changes

Breaking

The Performant Field Picker Labs feature now defaults to a new "Any" search option that searches for matches across views, groups, and fields for Explores with fewer than 5,000 fields.

https://cloud.google.com/looker/docs/release-notes#November_08_2023

Looker (Google Cloud core) only changes

Announcement

Looker (Google Cloud core) instances will be receiving Looker 23.12 and Looker 23.14 changes simultaneously, during the Looker 23.14 release. See the Looker (Google Cloud core) and Looker (original) changes section of the 23.14 release notes for deployment dates.

https://cloud.google.com/looker/docs/release-notes#August_18_2023

https://cloud.google.com/looker/docs/reference/param-manifest-constant

Looker (Google Cloud core) only changes

Feature

Looker (Google Cloud core) now supports the following regions:

• asia-southeast1 (Singapore)
• australia-southeast1 (Sydney)
• europe-west2 (London)
• europe-west3 (Frankfurt)
• me-west1 (Tel Aviv)
• us-east4 (Northern Virginia)

https://cloud.google.com/looker/docs/release-notes#September_06_2023

Looker (Google Cloud core) only changes

Changed

Looker (Google Cloud core) now supports multiple private IP instances in a single Virtual Private Cloud (VPC) network.

https://cloud.google.com/looker/docs/release-notes#August_22_2023

Looker (Google Cloud core) and Looker (original) changes

Announcement

Looker 23.16 includes the following changes, features, and fixes.

Expected Looker (original) deployment start: Monday, September 18, 2023

Expected Looker (original) final deployment and download available: Thursday, September 28, 2023

Expected Looker (Google Cloud core) deployment start: Monday, October 2, 2023

Expected Looker (Google Cloud core) final deployment: Thursday, October 12, 2023

Changed

The API call to create signed embed URL endpoints has been updated to remove the majority of embed administration configuration changes that need to be made when a signed embed URL is requested using the endpoint. The description of the endpoint is also changed to use a signed embed URL instead of an SSO embed URL to reduce the confusion with standard SSO authentication.

Changed

update_embed_config events are now reflected in the System Activity Event Explore.

Changed

When a dashboard or an element refresh interval is entered that is higher than the supported maximum value (24.8 days), Looker now returns a validation message.

Changed

Personal folders for users who have never logged in will no longer appear in embedded content navigation.

Changed

Auto-updates for Looker and third-party applications now display a list of entitlements that may be applied when a Marketplace listing is automatically updated.

Changed

The look and feel of the Get LookML dialog on Explore pages has been updated.

Feature

The Sisu integration is now generally available. This feature lets you open a key driver analysis in Sisu from a Looker dashboard tile or Explore.

Feature

The create_dashboard_render_task now takes in an optional theme property to specify the theme to apply to the rendered dashboard.

Feature

For SFTP and S3 destinations, the timestamp in the filename of the scheduled delivery will respect the Delivery time zone.

Fixed

Updates that are sent from inside custom visualizations now perform as expected.

Fixed

A previous issue would cause Marketplace updates to fail when a user had not entered dev mode since the last update. This issue has been fixed.

Fixed

A previous issue would cause Session Duration to be wrongly defaulted on the UI when the Inactivity Logout was enabled. This issue has been fixed.

Fixed

For cell visualizations in columns with large positive and negative values, the negative value text will now appear on a single line instead of wrapping to fit the cell space.

Fixed

For bar and column charts that use stacked series positioning and stack sorting with a combination of negative and positive values, the values are now rendered and sorted on the correct side of 0.

Fixed

LookML dashboard descriptions are now correctly localized in folders.

Fixed

A previous issue would cause scheduled plans for System Activity to fail with an undefined method 'path' for nil:NilClass error. This issue has been fixed.

Fixed

A previous issue would cause suggestions to not work for fields in views with inter-view references in their sql_table_name parameter. This issue has been fixed.

Fixed

Intermittent code: 1002 errors returned from Clickhouse connections have been fixed.

Fixed

The average_distinct field type now supports symmetric aggregates.

Fixed

A warning message will be returned when a user tries to use a subtotal with a sql_always_having parameter.

Fixed

yesno filters on filtered measures when BI Engine is enabled now perform as expected.

Looker (original) only changes

Breaking

The following SQL dialects are no longer supported by Looker, and queries against existing connections will return errors: Apache Hive 2, Apache Spark 1.5+, Apache Spark 2.0, and Quobole Presto.

Breaking

Looker no longer supports connections to the Impala dialect called Cloudera Impala (with no version number and without a native driver). Queries on connections to this release of Cloudera Impala will return an error. Looker is continuing to support Cloudera Impala 3.1+, Cloudera Impala 3.1+ with Native Driver, and Cloudera Impala with Native Driver.

Changed

The New LookML Runtime feature now allows a wider variety of strings for Liquid date parsing. Date string formats that were previously accepted in the Legacy LookML Runtime legacy feature but not in the New LookML Runtime feature should now format properly.

Changed

The Teradata JDBC driver has been updated to 16.20.00.13.

Feature

When the Email Allowlist for Scheduled Content Labs feature is enabled, admin users can use the email_domain_allowlist user attribute to define email allowlist domains at a group level.

Feature

When the Advanced Granular Permissions Labs feature is enabled, admin users can use six new permissions to delegate management of user attributes, groups, roles, private labels, themes, and embed settings to non-admin users.

Feature

When you set up SAML authentication, merging users from OIDC into SAML is now supported.

Fixed

The Table (Legacy) visualization hide_totals option now performs as expected.

Fixed

Liquid Ruby dependency has been updated to 5.0.0. You can now make a Liquid reference that results in a non-string value in the link parameter using the Legacy LookML Runtime legacy feature by using the {{ value }} Liquid reference syntax.

Looker (Google Cloud core) only changes

Announcement

A new Looker (Google Cloud core) codelab has been published. The Connect Looker Cloud over hybrid networking codelab provides a walkthrough of deploying a public and private IP Looker (Google Cloud core) instance and connecting it to an on-premises database.

https://cloud.google.com/looker/docs/release-notes#September_13_2023

Looker (Google Cloud core) and Looker (original) changes

Announcement

Looker 24.0 includes the following changes, features, and fixes.

Expected Looker (original) deployment start: Tuesday, January 16, 2024

Expected Looker (original) final deployment and download available: Thursday, January 25, 2024

Expected Looker (Google Cloud core) deployment start: Tuesday, January 16, 2024

Expected Looker (Google Cloud core) final deployment: Monday, January 29, 2024

Breaking

Raw SQL will now be included in the json_bi format.

Breaking

stream_to_cache time has been reduced for New LookML Runtime queries with Liquid in their result set. This does not include downloads.

Breaking

The run_inline_query endpoint now applies the same query validations as the create_query endpoint. Existing calls to the run_inline endpoint that do not match the API spec now return an error message that explains the issue.

Feature

New quick resize and tile repositioning features are available for editing dashboard layouts.

Feature

AND/OR filtering is now generally available when creating filters in Explores.

Feature

The Chart Config Editor is now generally available. You can use the Chart Config Editor to customize formatting options on Looker visualizations that use the HighCharts API.

Feature

The custom URLs for alert and schedule emails feature is now generally available.

Changed

The Open SQL Interface now supports Looker-specific metadata to indicate if a field is configured as a hidden parameter in LookML.

Changed

The Admin settings - Schedule page interface has been updated.

Changed

The default values have changed for the Persistent Sessions and Inactivity Logout settings. Persistent Sessions is now disabled by default, while Inactivity Logout is now enabled by default. You can change these values on the Admin Sessions page. The behavior of these settings will not change for users who have modified the session defaults.

Changed

The Presto JDBC driver version has been updated to 0.284.

Fixed

The custom filter editor is now persisted when users toggle AND/OR filters, even if the editor is empty.

Fixed

When used with the OR operator in AND/OR filters, filter-only fields will show a "not supported" warning.

Fixed

Username and password are no longer required fields in the SMTP settings user interface.

Fixed

Previously, drill modals on measures would be cut off in the data pane for Looks. This feature now performs as expected.

Fixed

Previously, "Fiscal years from now" could not be selected with AND/OR filters. This feature now performs as expected.

Fixed

Previously, users who did not have the explore permission could not view /embed/query pages. This feature now performs as expected.

Fixed

Previously, filters could not be localized correctly in dashboards. This feature now performs as expected.

Fixed

Previously, Google Maps visualizations on tiles in the lower section of a dashboard were blank in PDF downloads. This feature now performs as expected.

Fixed

Previously, Looks that were saved with the Legacy map type broke when the legacy feature was turned off. These Looks should now use Google Maps instead and perform correctly.

Fixed

Previously, a performance regression in the New LookML Runtime caused slow validation in models that included many dashboards. This feature now performs as expected.

Fixed

Previously, there were performance issues with large pivot tables that involved filled-in date values. The performance issues have been resolved, and this feature now performs as expected.

Fixed

If an aggregate table references a base view, joined in dimensions, and a measure that will cause fanout, then any query that references only the base dimensions will not optimize with the aggregate table. The aggregate table will continue to optimize with exact query matches.

Looker (original) only changes

Feature

The Lightweight Drill Links Labs feature is now available. Enable this Labs feature for potential improvements in browser and query performance times for queries that contain drill fields.

Feature

An optional parameter has been added to the LookML Model Explore parameter endpoint, which defaults to false. If the parameter is true and the user has see_lookml permission, then the endpoint returns drill_fields and link entities defined for that field in LookML. The response for each field will also contain a Boolean, has_drills_metadata, to signify that either drill_fields or link was defined, regardless of whether the user has see_lookml permission. drill_fields in the response will correspond directly with those defined under the field in LookML or on the view level for measure-type fields.

Feature

Extensions can now be developed to run in a tile on dashboards. Extensions that support being run as a tile or visualization can be added while the dashboard is in edit mode or saved to a dashboard as a visualization from an Explore. Extensions can also be configured as tiles in LookML dashboards.

Looker (Google Cloud core) only changes

Feature

Looker (Google Cloud core) now supports the SAML and OpenID Connect authentication methods.

Feature

The Looker Admin role can now be granted within a Looker (Google Cloud core) instance. You are no longer required to have a Looker Admin IAM role to be an admin within the instance.

https://cloud.google.com/looker/docs/release-notes#January_10_2024

Looker (Google Cloud core) only changes

Changed

Looker (Google Cloud core) now supports the following regions:

• asia-east2 - Hong Kong
• asia-northeast2 - Osaka
• asia-northeast3 - Seoul
• europe-southwest1 - Madrid
• europe-west6 - Zurich
• europe-west8 - Milan
• europe-west9 - Paris
• northamerica-northeast2 - Toronto
• southamerica-east1 - São Paulo
• us-west2 - Los Angeles

https://cloud.google.com/looker/docs/release-notes#November_09_2023