About kuopaz

kuopaz · 03-14-2023

I believe hitting the Commit button commits your code to your personal branch.But you go around hitting the Save button all the time as you make code changes. Where is this saving to, as you do see the results when running Looker in Dev mode, and can...

kuopaz · 02-10-2023

I quite often find that I don’t want to ‘extend’ an existing explore, rather I want to ‘use’ an existing explore in a new explore. I don’t see how the LookML extends: [ ] can do this, which would be true code reuse.

kuopaz · 01-04-2023

Just found this and thought I would put it up here as a brilliant solution that I’d never considered. I have been using windowing functions in a SQL derived table.Finds the last row in a group (usually by date) and - crucially - makes the other value...

kuopaz · 12-20-2022

Perhaps I’m the only person, but I always think the field header sort arrows are the wrong way around…(Yes, I know it’s not important!)

kuopaz · 11-30-2022

In explore this_viewjoin: created_by_user {from :userssql_on: ${this_view.created_by_id} = ${created_by_user.user_id} ;;}join: updated_by_user {from :userssql_on: ${this_view.updated_by_id} = ${updated_by_user.user_id} ;;}In view usersdimension: user...

kuopaz · 03-01-2023

Any thoughts on this, would be interested too.

kuopaz · 03-01-2023

Thanks. Yes, believe native derived tables can provide ‘real’ code re-use. But ideally it would be possible without introducing native DTs - and having to learn something else...

kuopaz · 02-11-2023

Thanks for the confirmation. Perhaps I’m really asking for an ‘explore to explore join’ that is currently done by merge in Looker - but cannot be done in LookML.extends is a specific form of code reuse.

kuopaz · 02-11-2023

I want to be able to do something like the following:explore: a {join…join...}explore: b {join...join: a}

kuopaz · 02-11-2023

If I create a VIEW in SQL that joins a number of tables, I can use that view as a virtual table *anywhere* in a future query and it’s joins. Can I use extends on explores to do the same?

My Stats

kuopaz's Bio

Badges kuopaz Earned

Recent Activity

Difference between Save and Commit

Is extends really code reuse

Retrieving values from the last row

Results table sort arrows

Change dimension label depending on join

Re: one fact table with multiple dates

Re: Is extends really code reuse

Re: Is extends really code reuse

Re: Is extends really code reuse

Re: Is extends really code reuse