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

SQL Bigquery - Create a data set from 3 tables with master records and no duplicates with ARRAY_AGG(Struct)

I am trying to query 3 tables to create one data set with master item data, transaction data and then serial numbers/locations. My left table is a unique key for each item mentioned once, then the transaction data and serial data has the key…
Greg Brown
  • 1
0
votes
1 answer

Modify attributes in 'Additional Params' for a Looker DB connection

I'm trying to pass groups information to a mysql database using connection attributes with Looker. Looker support passing additional parameters and use liquid format for inserting user attributes,…
daljian
  • 102
  • 1
  • 11
0
votes
1 answer

Specific date in a case statement in Looker

Writing a case statement in Looker and trying to put a specific date in the else portion. Is there a specific syntax I should be using? In the else portion I am trying to use a specific instead of the ${Today}, I would like to use…
Mark
  • 1
0
votes
1 answer

Looker: Create an explore minus required date fields

I'm fairly new to looker. There's this explore I'd like to use to build a table. It has all the view files I need joined to it, mainly one view file named insights.view. However, insights.view is currently used with dates and I'd like to create a…
Pandafreak
  • 109
  • 1
  • 12
0
votes
1 answer

Adding a button inside a measure in Looker

I’m trying to add a button in Looker inside a measure. I’m doing it by editing the HTML part. I’m trying to move the button to be below the "single_value_title" as it defined in the .dashboard file. I tried to change it by using the style “position”…
shr7
  • 163
  • 1
  • 2
  • 6
0
votes
0 answers

Looker Case Study

I have a google survey with multiple answers that resulted in data on a google sheet to have columns with comma-separated values col1 A A,B A,C B,C C,D I want one chart on google looker studio that turns counts of A, count of B count of C and count…
Dg_391870
  • 1
0
votes
1 answer

How to convert Cognos query to SQL query

I was working on Looker and I have to copy this Cognos query to Looker but apparently the SQL parameter on Looker did not work. I am not familiar with Cognos so I don't know how to solve this problem.enter image description here I tried PARTITION…
Nhật Phi Trần
  • 1
0
votes
0 answers

Looker Bigquery External Table Partition Pruning date filter using PDT and Dynamic SQL

Problem and solution We have case were bigquery external table need to be used and we use GS as storage and have access data through Bigquery external mentioning those partitions , we use looker for dashboard on this which needs to be fast and…
raigon.jolly
  • 1
  • 2
0
votes
0 answers

How to draw polygon data in looker from json column

I have a BigQuery table with polygons data: | id (int) | polygon_shape (string) | +-----------+----------------------------+ | 1 | {"type": "Polygon", "coordinates": [[[-11.6422, 36.6872], [-11.642038, 36.68726], [-11.64215117,…
Nina
  • 89
  • 1
  • 7
0
votes
1 answer

Looker date pivot is not working as expected

I am having an issue with pivots by date. When I try to add a pivot by date it ends up stacking month over month. All the percentages are correct for each month showing and they line up with the correct names but for some reason its stacking. I did…
Mike - SMT
  • 14,784
  • 4
  • 35
  • 79
0
votes
0 answers

Adding looker extension ID to hyperlinks in Extension Framework applications when opening as new tab

I am making an web application on the Looker Extension Framework. It contains several links (routes) for different components to be rendered. Since those are links, they could be opened as a new tab or window when the mouse is right clicked on it.…
Gini
  • 43
  • 7
0
votes
0 answers

How to reach better performance in Looker?

I'm currently on a Looker project, in the model in one of the explorers there are many joins that pull a lot of information, but as the customer says, this is just the beginning. I don't understand how to unload it, persist doesn't help, I tried to…
Пётр
  • 9
  • 5
0
votes
1 answer

Looker - Remove default copy from schedule emails

Can anyone advise on how to remove the default copy, "Results are attached" that resides in scheduled emails sent from Looker?
user2715877
  • 543
  • 1
  • 11
  • 22
0
votes
1 answer

Fetching Data from super data type in looker

I have a table which have a super datatype column. I want to fetch one column from data. I was able to fetch it out in redshift using select metadata."oldEmailVerificationSent" from users_dev; I want to do the same thing but in looker
ishita aggarwal
  • 17
  • 3
0
votes
0 answers

How Do I Create An API Data Test File In Looker?

My team is experimenting with Looker as a possible solution to a project we're working on. My issue is testing. We're not querying a DB, but using our API's for the testing. I've looked at the page…
Jack Parker
  • 547
  • 2
  • 9
  • 32
1 2 3
…
13 14