SQL windowing functions in looker

  • 22 April 2021
  • 0 replies

Userlevel 1

I’m sure this question has been asked more than once in the past - but is there any plans to incorporate windowing functions, without using a derived table. They are incredibly useful (I’m using SQL Server), so a big restriction.

With a derived table, you will often want to pass the runtime filters on the explore to it (and there could be many dimensions, with new ones added at any time). A native derived table with the SQL windowing function in a derived column and bind_all_filters get’s around this. But it cannot of course be a PDT so performance will take a big hit.

0 replies

Be the first to reply!