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
5
votes
1 answer

How do I move looks and dashboards between Looker instances?

We have Looker production and Looker staging instances. We need a way to move looks and dashboards between them.
Sami Yabroudi
  • 247
  • 3
  • 6
4
votes
1 answer

Failed to establish communication with Looker host

This will be very basic, I do not know how to connect to looker with my client ID and client secret for the Looker Extension SDK. This is a hello world app but the documentation is very lacking on the basics. import React, { useContext, useEffect,…
Josh Hendrix
  • 41
  • 3
4
votes
1 answer

Refused to display '' in a frame because it set 'X-Frame-Options' to 'sameorigin' with Looker

I'm trying to display a iFrame with Looker SSO, I used looker_sso_tool to generate the Embed URL, and it shows the dashboard I want, however when I try to use the url with a localhost application it shows the error: Refused to display…
Felipe Augusto
  • 7,733
  • 10
  • 39
  • 73
3
votes
2 answers

Looker Custom Visualization

I want to make a custom visualization which will add the values of two measure from the first row and display the value .For this I have been using the HelloWorld code provided by looker itself by making just few changes(text in Red).But I am not…
Rasika Kerkar
  • 31
  • 3
3
votes
1 answer

Shared aurora writer for analytics causing lock wait timeouts on production

Before I moved to aurora, I had a standard master->slave configuration that isolated Looker, my analytics platform. On the slave I had the tx_isolation db parameter set to READ-COMMITTED to solve lock wait issues. Now that I've moved everything over…
wonton
  • 7,568
  • 9
  • 56
  • 93
3
votes
1 answer

DATE_PART and Postgresql

I have a problem when I subtract two date in a function DATE_PART in this query. SELECT TO_CHAR(date_trunc('month',sql_activity_days.created_month),'YYYY-MM') AS "sql_activity_days.created_month", coalesce(SUM( CASE …
Julie Levesque
  • 115
  • 3
  • 3
  • 11
3
votes
1 answer

SQL to querying a table with a dollar sign

I'm using the Looker Dashboarding software (see: looker.com). It creates temporary tables in your database's looker_scratch schema with long names, each containing a dollar symbol. These are straightforward to query using the "SQL Runner" in Looker…
LittleBobbyTables
  • 4,361
  • 9
  • 38
  • 67
2
votes
1 answer

REGEXP Function Help - Looker Studio (Google Data Studio)

I hope everyone is doing well! I am trying to extract/clean data from a column. Below is an example of a cell row: "Mother Day Pack - 200ml / 10 Cans 1 glass & 1 crisp" What I need to do is to Separate the text data before the hyphen (-) and extract…
Jayx
  • 21
  • 1
2
votes
2 answers

Unable to pull or push code on Looker UI using git actions

I am developing the views and models in my personal branch. After that I am trying to pull the code from production and merge it. But I am not able to merge it, it says : Someone else has made changes to this branch. 35 commits to be pulled or pull…
Megha Agarwal
  • 31
  • 3
2
votes
0 answers

Can't track events of Looker Embedded Dashborard (SSO embedded) in Nest.JS application

I have next.js project, on server side I generate Looker-sso url and on client side I use this url for embedded dashboard. Here is how I generate SSO url at Next.js server side function getLookerSsoUrl(embeddedUserParams: UserInfo, dashboardId:…
Anton Kuzmich
  • 21
  • 1
2
votes
1 answer

How to change filter in date parameter to range in Looker

I am trying to see if there is a way to have the filter on a date parameter be a date range instead of a single date value. Does anyone have any creative ideas on how to do this.
Chadc
  • 53
  • 4
2
votes
1 answer

Looker will not accept double single quotes for passed condition

When passing a filter from an Explore like in the below example for whatever reason we cannot get it to provide double single quotes in the query condition. In the query inside the view has the condition that pulls the submitted value: As you can…
Mike - SMT
  • 14,784
  • 4
  • 35
  • 79
2
votes
0 answers

Google Looker - Alert Queries

I am currently setting up alerts for our looker dashboard to email my team when a metric hits a certain trigger. I set up the alerts to query every 15 minutes, however, one issue I am facing is that regardless if a dashboard is refreshed, the alert…
KMatton
  • 45
  • 4
2
votes
1 answer

How to learn to develop Looker custom visualization efficiently?

I have been working with Looker for a while and one thing that bothers me the most is the multiple limits to its native-visualization (clustered stacked bar chart unavailable, sunburst chart with limited editing options...). So, I figured that it is…
Hung Ho Phan
  • 86
  • 7
2
votes
0 answers

Can liquid slow down Looker dashboards performance?

I'm trying to replace certain CASE WHEN in SQL by multiple {% if %} parameters where applicable in LookML in order to improve query speed. How can I be sure that this will improve or slow down the over all performance of an explore or dashboard ?
Hung Ho Phan
  • 86
  • 7
1
2 3
…
13 14