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

Looker custom visualization API - Visualization config options

I'm currently utilizing the looker API to create custom visualization. I'm using https://github.com/looker-open-source/custom_visualizations_v2/blob/master/docs/api_reference.md as a reference for the visualization API. I suppose the documentation…
Aleksandre Berishvili
  • 1
  • 1
0
votes
1 answer

How can I use LookerSDK 4.0 to download a tile from a dashboard with filters applied in Python?

I need to download some specific elements(charts and tables) from a looker dashboard programmatically in python. I am currently exploring the LookerSDK 4.0 to achieve my use case. I followed these examples to download a dashboard with filters…
sakshi
  • 1
  • 2
0
votes
0 answers

Is nested time-series in BigQuery a good idea?

I have multiple time-series, for example, for different categories and products. So my data have the following columns: time, category, product, sales. Should I just create a normal table with time partition and category+product clustering, or…
Khanetor
  • 11,595
  • 8
  • 40
  • 76
0
votes
0 answers

How to run a Data Looker Report with dynamic bigquery table names as data sources?

I have a data looker report that runs on a specific table schema. However those tables are generated automatically and I want to run the same report over different tables that are generated automatically. (over 1000) How can I achieve that? Tried…
Alexandru R
  • 8,560
  • 16
  • 64
  • 98
0
votes
0 answers

Explore - Nested Data in BigQuery

Dear Stackoverflow Community, I stuck with a problem and need your help. I have an explore (“client_info”), which keeps all information about clients. As main, i take “client” view and add all additional information to it from other views. I want to…
Sergey
  • 1
  • 3
0
votes
0 answers

Looker Categorical Statistics

I have to generate a report of invoices in Looker. Each invoice belongs to a category field. I am tasked with computing statistics of that category, and comparing each individual invoice against that statistic. Here is an example. Suppose invoice 0…
Theodore Ho
  • 1
0
votes
1 answer

Looker Studio quota issue with Bigquery and Sheets

I have a dashboard on Looker Studio free. My data source is BigQuery and Google Sheets. I receive an error on a chart that says "Error of quota. This dataset has been accessed too many times". I'm not using Google Analytics as a data source. Any…
jweckl
  • 11
  • 2
0
votes
0 answers

Window Functions in Looker Studio

Does the LIMIT function combined with OFFSET not work in Looker? I used the line LIMIT 1000 OFFSET 10 in BigQuery and it worked normally. But in Looker Studio it doesn't produce any result.
Maurício Barros
  • 11
0
votes
0 answers

My Looker Dashboard is displaying "No Results" - BigQuery source

Data is housed in BigQuery and is queried by Looker to display our clients data. We use a lookup sheet to match each data to its respective account/client. This lookup sheet is created in Google Sheets and is also pushed to BigQuery. The other day,…
Daniel Katowitz
  • 1
0
votes
0 answers

How can I aggregate a value to a level of detail different to that of a table/view?

I have a view in Looker that is on an order level. It has customer_id and the service fee the customer paid for each order (Could be 0, could be a positive value). I want to calculate, on a customer and month level, the % orders on which a service…
Adwaith Kuttikkatt
  • 13
  • 1
0
votes
0 answers

Fetch Google Drive from a Particular folder in the Drive through SQL or Looker

I want to know if there's any way to fetch google drive links through SQL and/or Looker from Google Drive from a particular folder and show them in Google Drive. For example: if there's a folder Named 'User' ---> and in it, there are many folders…
Raman Singh
  • 73
  • 5
0
votes
1 answer

How do I capture the Looker User's Groups as an Additional Param (in JDBC/Snowflake Connection)

I am trying to pass the Looker User's Groups as an Additional Param in my Looker Snowflake Connection. This will help me to differentiate between customers and use cases for a shared user/role/connection to Snowflake. I can't find any method of…
Johnny Stevens
  • 1
0
votes
0 answers

Looker Explore - display only latest day, unless date dimension is added

In a Looker Explore, we want to display only the data from the latest date for each ID. For example: ID Probability 1 0% 2 50% When we add in the date dimension, then we want to break it down by date: Date ID Probability Feb 5,…
Milka
  • 297
  • 2
  • 11
0
votes
0 answers

is it possible to embed looker show or any visulazation on thec ustomer in-app? how can we restrict it to the customer data only?

We have some mobile app, and we want to give the customers some nice graphs & visualizations about their status. I would like to to build some dashboard in looker and embed it on the mobile, while each user can only see his owd query result. is it…
RELW
  • 189
  • 1
  • 14
0
votes
1 answer

Looker Studio: Upgrading Date Compatibility to Date clears out graphs or results in Failed to get data

I have a dashboard in Looker Studio that is suddenly showing inaccurate data (it worked fine the day before). I had added a column to a data source. When I reconnected the data source, I can see that the date format is showing the old date format,…
Farah
  • 1
  • 1
1 2 3
…
13 14