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

Unable to pull Looker chart (view) into Databricks using Looker API

My goal is to access views or charts I have stored in my Looker folder and add those automatically to power point slides. The tutorial I am following is this one:…
LaLaTi
  • 1,455
  • 3
  • 18
  • 31
1
vote
1 answer

Looker Map / Store Points and Sales Heat Map in one dashboard

I have a straightforward question, how to show in a SINGLE map: Store locations (I have Lat/Long) As dots on the map Sales (I have Lat/Long) - As HeatMap
Oksana Ok
  • 515
  • 3
  • 7
  • 19
1
vote
1 answer

How to shift week start date without altering other looker models

I am trying to shift the start date of the transactional (don't know if thats a word) week from sunday (index 0) to friday (index 6). This is the only view in any of our data models that would use this transnational week. I am creating a 2 new…
samdaily34
  • 67
  • 7
1
vote
1 answer

Connecting Looker to SAS

Does anyone know if you can connect Looker directly to a SAS table/server? or would you use a work-around to upload the SAS data to a SQL server, then connect Looker to that?
GenDemo
  • 749
  • 1
  • 7
  • 24
1
vote
1 answer

Remove aliases from SQL query in Python with regex?

I'm trying to extract table names from a SQL query and running into some difficulty using Python SQL parsers such as sqlparse. The issue is with aliases - the parser will confuse the real table name with its alias and solely return the alias. My…
Aman Jha
  • 138
  • 10
1
vote
3 answers

Cannot get the same Min(date) for all rows for the same user_id in SQL

I have 4 columns which are: user_id, job_date, min(job_date), rank. The column that does not show what I want is the min(job_date) column. In that column, I am basically trying to paste the smallest date for a given user_id. I.e. If my first…
LaLaTi
  • 1,455
  • 3
  • 18
  • 31
1
vote
1 answer

How to get a sum of a dimension?

I have a custom dimension called “Day” and I want to create a table where I list each day in the first row (i.e. Mon, Tue, Wed, Thu, Fri, Sat, Sun) and in the second column, I want to count how many times each day occurred. So, the output is like…
LaLaTi
  • 1,455
  • 3
  • 18
  • 31
1
vote
1 answer

Looker : Liquid filters on tags, ABS filter

Assign an absolute value in Looker with Liquid. dimension: my_dim { sql: -10.12 ;; html: {% assign abs_val = my_dim._value | abs %} {{ abs_val }} ;; } Problem: the minus value is printed out. The absolute value is wanted. Documentation link:…
Paul Velthuis
  • 325
  • 4
  • 15
1
vote
1 answer

Redshift: replace FULL OUTER for a CROSS JOIN

I would like to perform a full outer join using multiple OR values but i've read that PostgreSQL can only do a full outer join in a situation where the join conditions are distinct on each side of the = sign. In my scenario, I have 2 tables: ticket…
user866364
1
vote
1 answer

How to reference the latest table from a manually partitioned BigQuery table

We have a manually partitioned "video metadata" table being fed fresh data each day. In our system, old data is only kept for historical reasons since the latest data is the most up to date. What we cant figure out is how to reference only the…
Sam Rockett
  • 3,145
  • 2
  • 19
  • 33
1
vote
1 answer

Is there any equivalent function for an sql query: from_unixtime(unix_timestamp(${TABLE}.dt,"yyyyMMdd") in aws athena)

I changed Looker database connection from fast access to Athena. However the fast access is using spark SQL, which is no longer work in Athena. The sql: from_unixtime(unix_timestamp(${TABLE}.dt,"yyyyMMdd")) works with fast access but not in Athena.…
Qian
  • 13
  • 3
1
vote
2 answers

Using WHERE, CASE, AND, LIKE together in the same SQL query

I'm having trouble coming up with the right query that does the following: Let's say we somehow take input from user for the value of two columns, datestamp and brand (what happens is a Looker UI feeds this to the query). For simplicity let's say…
Tapal Goosal
  • 361
  • 4
  • 13
1
vote
0 answers

Receiving JSON from Looker - in PHP

I'm creating a web hook to receive a JSON POST from the tool Looker (http://looker.com). My problem is that I receive no data although I know for sure that Looker sends data (has been tested with https://requestb.in). The data is sent as an attached…
EchoGecko
  • 13
  • 4
1
vote
2 answers

Connect Tableau to Looker database

I use Looker to manage my data stored in Amazon RedShift database. Though Looker has dash-boarding capabilities, I would like to use Tableau for better visualization. Is there a way I can connect Tableau to Looker database. (P.S: I don't wish to…
Nandini Chakladar
  • 23
  • 1
  • 5
1
vote
1 answer

Testing server queries/data bases

I have a application in node.js and swagger which queries looker for the data,I am able to run the basic unit test cases. When I need to test the queries which hit looker(which is running in other server) I have to start my node service and then…
user3649361
  • 944
  • 4
  • 20
  • 40
1 2 3
…
13 14