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
0 answers

Postgres SQL, Can filter on results less than 20 days but not results over 20 days

I have a dimension which I have declared called mystay_days_before_stay and I have created a tier to group this information. When I query for results over 19 days then the query crashes. dimension: mystay_days_before_stay { label: "Days before…
George123
  • 57
  • 3
  • 11
1
vote
1 answer

Unable to authenticate with Looker API on subsequent requests

I am having an issue in that I am able to authenticate into my instance's Looker API endpoint (:19999), but on subsequent requests to pull data I get failed auth message. How does Looker know then that I am authenticated if I'm not passing the…
David
  • 11
  • 4
0
votes
1 answer

Looker User Access disable or delete in bulk

I have a bunch of orphaned users I want to delete from looker. Is there way to input a list for that deletion process? Currently I only see deletion or disabling users one at time from admin section. Looker User Access disable or delete in bulk.
HVJ
  • 1
0
votes
0 answers

Strategies for Efficiently Refactoring Parts of a DAG in DBT

When working with a Directed Acyclic Graph (DAG) in dbt (Data Build Tool), there are instances when you might want to refactor a part of it. For example, consider tables A and B, where table B references table A. If you decide to change a column…
naoki
  • 1
0
votes
0 answers

Looker problem Pull Production Failed Pull Incomplete

I'm new in a company and I'm working with Looker. When they first created my personal branch in Looker, it gave me a problem: I didn't have any files; I reverted to production and all the files appeared, but when I tried to pull from primary branch…
Sara G
  • 1
0
votes
0 answers

Looker parameter/filter workaround

My data is as below- enter image description here country flag enable not India N E NA UK Y E NA US Y E NA AUS N Not Yes NZ null null null Poland N E NA UAE Y E NA SA N Not Yes China null null null I have 3 columns which…
Reshma RS
  • 1
  • 1
0
votes
0 answers

Map canada 6 digit zip codes on Looker

Trying to visualize 6 digit zip codes of Canada on a map chart. But Looker is only supporting 3 digit zip codes to be mapped on the map. How to map a zip code like P0W 1L0 on Looker maps? Looker is supporting only P0W to be mapped on the map. Looker…
Teja Goud Kandula
  • 1,462
  • 13
  • 26
0
votes
1 answer

Highchart - Add a scroll bar on a column range Chart

I'm trying to add a vertical scroll bar on a column range chart but when i move up or down X-axis and legend overlap the points. How Can I fix the X-axis and legend? The chart was imported in the Looker Platform but I can change the .js code See…
Ilario
  • 1
  • 1
0
votes
1 answer

Users and Sessions by Page Path in GA4 aggregated in special way

I have the following sample table in Looker using a GA4 data source (page title omitted for privacy): The total sessions aggregation shows a number around 0.5 Million. However when exported to excel and summed the actual sum is slightly over 1…
在去中国
  • 78
  • 8
0
votes
0 answers

How do I setup Oauth to get started with Looker on GCP?

I am trying to start up Looker on GCP (the 30 day trial). I was hoping to launch an instance and get started but I have gotten stuck on the Oauth. When I click the url of my instance https://.looker.app/ logged in with my Google account (which has…
Christoffer
  • 2,271
  • 3
  • 26
  • 57
0
votes
1 answer

how can i set a constant in lookml (model + a few views) via git's ci/cd (or any other solution for dev/prod stuff)

I've got two databases in google bigquery: company.prod.db and company.stg.db I want to have a dashboard that my stakeholders can see the prod data, while I edit stuff in the dev side. So my lookml dashboards can pull data, and I can even update the…
Mohammad Athar
  • 1,953
  • 1
  • 15
  • 31
0
votes
0 answers

Prepopulate linked filter LookerML

I have an issue, tried to solve myself or find on the web -> unfortunately without a result. Here is the problem: I have 2 tables, see template below: Citizen (Id) - Associated Zip code ; Zip code - City; On the looker dashboard i link those 2…
Sergey
  • 1
  • 3
0
votes
1 answer

Looker measure to average over last 3 years

I am trying to create a measure (LookML) that gives the average of funding over a three year window. A sample of my data looks like…
dalek_fred
  • 153
  • 10
0
votes
0 answers

Using a UDF in a predicate filter on a partition column

I have some data in BigQuery in a table which is partitioned based on a DATE column. Please consider the following simplified example for demonstration: | product_id | performance_date | computed_at | clicks | | ----------- |…
Mousa
  • 2,926
  • 1
  • 27
  • 35
0
votes
1 answer

Error switching into Development Mode in looker

I am failing to switch to developer mode in looker. My user has the developer access. When I am trying to use the toggle I receive this error: Error switching into Development Mode I could not find any documentation for it, just other people…
Tom Carmi
  • 385
  • 1
  • 5
  • 18
1 2 3
…
13 14