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

Query for kind of pivot of two date column in sql and its count

I have two columns, ticket_created_date and ticket_resolved_date, I want to somehow pivot( if I may call it) them by an SQL query and get something like below image, the first column is the bucket of the days, i.e, 0 if the difference in 2 dates is…
Kush K
  • 3
  • 2
0
votes
0 answers

Converting a looker view file to csv

I am trying to convert a looker view file to csv/xls file, with all the keys as the column header and the corresponding value as each row. The end goal here is to dynamically identify the keys and have them as column header. VIEW FILE view:…
Ritesh
  • 85
  • 8
0
votes
1 answer

Unable to authenticate Looker API in Databricks using Python

I want to access some charts -which I have saved in Looker- within Databricks. Part of this process is the authentication. I have one Looker auth-script which works but only pulls the tabular results into Databricks which corresponds to a…
LaLaTi
  • 1,455
  • 3
  • 18
  • 31
0
votes
0 answers

How to extract all values from Json using SQL regardless of the different keys (wildcard with multiple pairs)?

Thank you first! Basically, I have the following: SELECT parse_json(collection."Name".values) FROM some_table_name This will return me: { "en": "Jack", "fr": "Jack", "ch": "杰克" } And I can access ONE of the values as: SELECT …
Samuel Fu
  • 1
  • 1
0
votes
1 answer

Convert SQL query to LookML

Need to transform this query to LookML SELECT Accounts_Unlock_Price, Accounts_Upfront_Price, Portfolio_Derived_Previous_Cumulative_Paid, Portfolio_Derived_Previous_Cumulative_Paid/(Accounts_Unlock_Price -…
WNT01
  • 3
  • 3
0
votes
3 answers

Create true/false column out of fuzzy matching between two columns in SQL

First of all and before detailing the problem I'm dealing with let me tell you that I'm currently an SQL-newbie so whenever it's possible I'll appreciate plain explanations and simple solutions. Here's what I have: Given this query: SELECT …
teogj
  • 289
  • 1
  • 11
0
votes
3 answers

How to extract regex query until a specific word?

I'm trying to extract certain data from LookML, a specific markup language. If this is example code: explore: explore_name {} explore: explore_name1 { label: "name" join: view_name { relationship: many_to_one type: inner …
Aman Jha
  • 138
  • 10
0
votes
2 answers

ERROR: more than one row returned by a subquery used as an expression. POSTGRESQL / LOOKER

I am trying to do a subquery in Looker that returns the assignee name from the person table where the person ID equals the assignedtoperson ID I have tried to do a limit 1, but that just returns the first value for person in every row SELECT …
Andrew
  • 1
0
votes
1 answer

How to calculate %of first row value in Looker calculated fields?

I cannot find any documentation to calculate the %of first value in a column. For example, the first value in a column is 13, the next one is 2, then it should calculate 2/13. If the third value is 1, then it should calculate 1/13 etc. So, all…
LaLaTi
  • 1,455
  • 3
  • 18
  • 31
0
votes
1 answer

Is it possible to create a new measure with existing measure?

I have two existing measures: measure: measure_1{ type:count sql:${TABLE}.example1;; } measure: measure_2{ type:count sql:${TABLE}.example2;; } I am trying to divide measure one with measure two like so: measure:…
RustyShackleford
  • 3,462
  • 9
  • 40
  • 81
0
votes
1 answer

Combining Table and Views to Create Reports - Impala SQL

I have a scenario for which i need some guidance. There is a report being created in Looker tool by utilizing 3 separate tables. Looker uses an Impala connection. Now we have a client who do not have their data on these tables but would like to have…
sudeep
  • 79
  • 1
  • 8
0
votes
1 answer

Bigquery fails to return proper data from table when queried using wildcard query

we are using Looker (dashboard/reporting solution) to create persistent derived tables in BigQuery. These are normal tables as far as bigquery is concerned, but the naming is as per looker standard (it creates a hash based on DB + SQL etc.) and…
Pruthviraj Shivanna
  • 165
  • 2
  • 6
0
votes
1 answer

How do I connect a BigQuery database based on a Google Sheet to Looker?

I'm attempting to connect BigQuery to Looker. I am pulling sample data from a Google Sheets document to a BigQuery dataset; this part is working fine, as my internal BigQuery queries are running just fine for this dataset. Using this documentation…
Amy Ho
  • 1
  • 4
0
votes
2 answers

Do SQL targeted BI solutions like Looker and Chart.io use OLAPs?

I know that OLAP is used in Power Pivot, as far as I know, to speed up interacting with data. But I know that big data databases like Google BigQuery and Amazon RedShift have appeared in the last few years. Do SQL targeted BI solutions like Looker…
user1283776
  • 19,640
  • 49
  • 136
  • 276
-1
votes
0 answers

Filtering comma-separated strings problem

i'm having problems filtering strings in this pattern: Data1, Data2, Data3. They come from google forms multiple choice questions, which end up being grouped in cells. I want to count 'em separately, but when i Select this cloumn as dimension,…
Guilherme Stiehler
  • 1
1 2 3
…
13
14