Stack Overflow
Stack Overflow

Questions tagged [looker]

Use this tag for questions concerning use of the Looker platform or its modeling language, LookML.

The Looker data platform is a web-based service for data exploration, analysis, and reporting with built-in version control and security features. Google announced in June 2019 that it would acquire Looker Data Sciences.

LookML is a declarative data modeling language somewhat similar to YAML or JSON that defines relationships in relational databases so that users of the Looker platform can explore data without writing SQL.

Components of LookML and their related SQL concepts:

  • dimension (column)
  • measure (aggregation)
  • view (table)
  • explore (join)
  • model (database)

Data types peculiar to LookML include:

  • duration
  • yesno (equivalent to boolean)
  • location
209 questions
1
vote
2 answers

Looker Visualization Issue

I have a Looker visualization that shows 'No Results'. It's a count of measure with date. I need to show the visualization with dates even if there are 'No Results' (as a visualization missing the line since we dont have data, but dates still…
Aqib Shah
  • 11
  • 1
1
vote
1 answer

Looker Filter that can evaluate to more than one condition

I'm trying to create a filter for my dashboard. I need the filter to be able to evaluate to more than one condition. For example, my logic can look like the following: case when account_age < 1 then 'populate new accounts' when account_health < red…
mikelowry
  • 1,307
  • 4
  • 21
  • 43
1
vote
2 answers

How do I find the explore(s) using a specific view in Looker?

I have this view file in front of me and I want to query a couple of dimensions and measures from it. How do I find the explore(s) that contain this view?
Pandafreak
  • 109
  • 1
  • 12
1
vote
1 answer

How do I join a measure field from a different view in Google Looker?

Google Looker dev question: How do I join a measure like sum_order_value from another view B to an existing view A? I added it as a measure at the bottom of the view file: measure: sum_order_value { type: number description:…
Pandafreak
  • 109
  • 1
  • 12
1
vote
1 answer

Github dev/stg/prod workflow: Which branch should I create feature branch from?

I'm creating a CI workflow for a 50+ Looker developer team. I have read all models in this page but none really fits my requirements. The current flow I have in mind is: The github repo has three branches: dev, stg and prod. We also have three…
Marcus Anthony
  • 71
  • 6
1
vote
2 answers

Force looker to filter between the 1st of the year and today dynamically?

In looker I can set exact date filters or I can set rough filters. I want to be able to define a range dynamically. For example the start of the year up to today would be the goal. If I select this year I get a bunch of zeros for the months that…
Mike - SMT
  • 14,784
  • 4
  • 35
  • 79
1
vote
0 answers

How to open port to access API on nodejs

I am trying to access the Looker API of a self-hosted instance. I am very new to nodejs and not sure how to go about this. THis is the error I am getting: node:_http_outgoing:742 throw new ERR_INVALID_ARG_TYPE( ^ TypeError…
nb_nb_nb
  • 1,243
  • 11
  • 36
1
vote
1 answer

Can we connect Looker to Google Sheets Directly

I want to know if there is any update in latest looker version about connecting looker to google sheet directly? if yes then can someone please help me with the steps to do the same.
gayatri kulkarni
  • 11
  • 1
1
vote
1 answer

Exasol SQL Fuzzy Matching function

Good day, all you SQL geniuses out there. I'm running into a bit of an issue. The firm I work at uses EXASOL SQL and I'm trying to get find a function that I can use in order to fuzzy match two strings. For example, Let's say we have these two…
A_Pirates_Favorite_Letter
  • 141
  • 1
  • 12
1
vote
1 answer

Returning Sum of all rows that fit date criteria

I've really searched but couldn't find an answer to this one, I have a simple table in my postgres DB; start_date | end_date | amount Because the dates aren't continuous and because of the nature of needing a "snapshot date" I'm using a…
shredsies
  • 11
  • 1
1
vote
1 answer

Can't import Looker API anymore

When trying to import looker_sdk in my code, I get a lot of error messages, and can't use the API anymore... I was able to use this 3 weeks ago, and haven't change my code at all. I went on 2 weeks vacation and it didn't work anymore. Here's the…
Einar
  • 1,001
  • 3
  • 11
  • 28
1
vote
1 answer

Get data as dataframe from Look through API sdk package in python

I have the following code to get a look from Looker through an API. I stored the api in a .ini. All of that works, but now I want to get the data from this look as Dataframe in python, so that I can use the data for further analysis. How can i do…
Ja123
  • 73
  • 6
1
vote
0 answers

How do we use BigQuery HLL (HyperLogLog) functions in Looker

I have a quick question on how we can use the BigQuery HLL functions in Looker. For example, there is a BigQuery table with the following structure Sample BigQuery Table In looker do I need to define this field respondents_hll as a dimension or…
iPrithvi
  • 11
  • 1
1
vote
0 answers

How to return value from the Looker Golang sdk

I'm attempting to perform the run inline query api endpoint using the Looker Golang SDK.…
hselbie
  • 1,749
  • 9
  • 24
  • 40
1
vote
1 answer

What is the public endpoint for BigQuery?

To allow JDBC connections out of a secured network to BigQuery via Looker I need to know the domain name for BigQuery so that we can whitelist it in our proxy access list. We are planning to set our proxy as the rootURL JDBC parameter. But the…
Willi Müller
  • 631
  • 1
  • 5
  • 13
1 2
3
…
13 14