Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Got a question?

Ask your big data questions here.

  • 120 Topics
  • 203 Replies

120 Topics

moremi
moremiNew Member
asked in Got a question?

Big Query Error Message

Hello! I’m trying to submit the query below in BigQuery SELECTuser_id,advertiser_id,lineitem_id,creative_id,country_iso_codeFROM `insights.impressions_base_2020*`Where advertiser_id = 6812212  AND  _TABLE_SUFFIX BETWEEN '0101' AND '0331'  AND lineitem_id NOT IN ( '5602769671', '5580417306', '5581512841', '5581512886', '5581512871', '5571436761', '5571436743', '5572721429', '5581578220', '5581804250', '5581803806', '5581578193', '5600524932', '5601820042', '5602048460', '5619485410', '5619471991', '5576901524', '5576901506', '5576704690', '5576901530', '5581751483', '5576789161', '5576787793', '5575665759', '5577634784', '5577634796', '5577634937', '5577436762', '5571658214', '5571540670', '5571540661', '5571540643', '5571743231', '5571743270', '5571743255', '5571743213', '5576884225', '5576884246', '5576884234', '5577085868', '5574799170', '5575617522', '5581785830', '5587322866', '5587322851', '5587323007', '5587335040', '5587335013', '5587335025', '5575597089', '5576923199', '5576923

1
IanT
1 year ago
S
sunnygudNew Member
asked in Got a question?

Reduce Filter Queries

I am trying to understanding the differences of the versions released, anyone who can understand this particular feature please give me an example to understand. (preferably request you if you can add a screenshot in your explanation.) Labs experimental features Looker 7.18 Looker 7.20 Looker 21.0 Looker 21.4 Looker 21.6 Notes Reduce Filter Queries – – Supported Supported Supported  

0
S
1 year ago
joe_c
joe_cNew Member
posted in Got a question?

Filtering dates 'in the past [X]' - Looker inserts empty string into CURRENT_DATE('')

Hey all,I’m trying to figure out this weird error I’m getting. When I filter my dates with ‘is in the past 5 months’, I get the error `Query execution failed: - Invalid empty time zone`, but when I use a date range for the filter, there is no issue.I looked into the SQL code behind the scenes, and it seems like Looker is using CURRENT_DATE(‘’) with an empty string for the ‘is in the past [x]’ filter. Has anyone experienced this? Any suggestions to still use the ‘is in the past [x]’ filter without having this issue.Thanks!Joe

5
joe_c
1 year ago
Asami Muramatsu
Asami Muramatsu
asked in Got a question?

How to try out Looker.

I am interested in Looker and would like to try it out.I signed up for the Looker Free Trial by following the steps below.1. I accessed the Google Cloud service2. I clicked on the "Looker" link3. I clicked on the "Request Free Trial" link.4. I filled out the form "Free 14-day trial".5. received an automated email a day ago. Details are below.------------------ I received this email.Thanks for requesting a free 14-day trial of Looker! We’re so glad you’re interested in seeing Looker in action.Our team will be following up with you shortly, in the meantime check out this ebook and learn how Looker helps companies create a seamless experience with data.Best The Looker Team After receiving the email, I did not receive any access information for the free trial. How can I try Looker? I’m glad to teach me this answer. 

0
Asami Muramatsu
1 year ago
D
Daniel1984New Member
asked in Got a question?

Year-on-Year, Point in Time Comparison

Hi all, I am relatively new to Looker but not to SQL and hoping someone can help me with an issue I'm having. I am trying to create a graph that will compare number of nights booked vs lead time (how far out people book). I want to compare 2021 so far, to the same time period in 2019. I can't see a way to filter for this specifically, does anybody know of a work around for this?

1
cranium025
1 year ago
benchmarking
benchmarkingNew Member
asked in Got a question?

Filtering with AND condition

Hi,Let’s have a look at this table:  In the explore we have:Dimension: ProductMeasure: Number Of Customers (count distinct customer ID)Measure: Number Of Orders (count disitinct order ID) The question I want to find an answer is:How many customers ordered both Guitar and Ocarina across all orders? Answer is 1 (customer A)What would be the best way to model it? I understand that in this explore it is not possible to do that, or am I wrong?

1
cranium025
1 year ago
humbletyler
humbletylerMember
asked in Got a question?

Dimension using other view that is joined many times

I have got a database with a very strange order architecture in which any order might have a parent. Sometimes, we need information from the parent or even the grandparent order. Because of this, I have created the following…view: orders { sql_table_name: ... ;; dimension: key { ... } dimension: product_key { ... } dimension: parent_key { ... } dimension: grandparent_key { ... }}view: products { sql_table_name: ... ;; dimension: key { ... } dimension_group: start { type: time timeframes: [...] sql: ${TABLE}.start ;; } ... other stuff like product price and name ...}explore: order { from: orders join: parent_order { from: orders sql_on: ${order.parent_key} = ${parent_order.key} ;; } join: grandparent_order { from: orders sql_on: ${order.parent_key} = ${grandparent_order.key} ;; } join: order_product { from: products sql_on: ${order.product_key} = ${order_product.key} ;; } join: parent_order_product { from: products sql_on: ${parent_or

1
humbletyler
1 year ago
amit.saxena0782
amit.saxena0782New Member
asked in Got a question?

Google looker compatibility with TERADATA database

Hi ,can somebody share me looker latest version download.     

0
amit.saxena0782
1 year ago
D
Daniel1984New Member
asked in Got a question?

Booking Curve with Optimal Accuracy

Hi All, I am have currently been tasked with creating a booking curve dashboard, the filters will be the resort and month and the graph will show lead time (days between the booking being made and the date of arrival) and the number of nights booked. A simple task on the surface but the challenge I am facing is trying to account for the fact that the lead time may vary vastly within a month. For example school holidays will have longer lead times as people book these further in advance, the same with public holidays. Any suggestions here of a function that could help with this would be appreciated, at the moment the only one I have come across is the rolling average using mean/offset list.

0
D
1 year ago
humbletyler
humbletylerMember
asked in Got a question?

Can Looker solve my Hogwarts example?

This is somewhat a duplicate of my other question, but I think it’s a better way to articulate it.  If I get an answer I’ll make sure to update the other question as well.  Sorry for the dupe, I can’t edit :( Hogwarts’ magical points system is broken, so I need to build a Looker dashboard to replace it.Imagine the raw data to be something like: timestamp, house, points, student, reason.  (Points can of course be negative.) I need to build a Line Chart that shows each House as a separate Series, and displays their running point totals over time.  Clicking on the line chart should preferably be able to show me the entries that occurred on that day. Is this possible?  Can anyone help?  Thanks in advance and sorry for spam!

1
humbletyler
1 year ago
humbletyler
humbletylerMember
asked in Got a question?

How can I replicate a Sum with an Over clause?

I have some raw wishlist data in a simple form (timestamp, user_id, item_id, added) where the final item there is just a +1 or -1.The data isn’t that clean, of course, but that’s effectively what I have :)I want to be able to visualize both the day-to-day changes and the running totals on a line chart.Having the running total is a bit complicated, and I can’t figure out the best way to do it in Looker.In SQL, I would do something like:SUM(added) OVER(PARTITION BY item_id ORDER BY timestamp ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)And that would give me the running total; by selecting/grouping the days, I’d get 1x row per day/item combo and the useful data rows would be delta to tell me what the total change would be and running_total to tell me what the running total would be.Can someone help me figure out how to accomplish this in Looker?

5
humbletyler
1 year ago
J
JustinLanham
asked in Got a question?

Most Recent Date

I am working with a report that has a date field to X.This date fields can have multiple values, and created multiple lines for X.My goal is to have a filter put in place to pull the most recent date for the date field, resulting in only one line for X.For example; say X has date values for 3/1/21, 3/4/21, & 3/7/21, in my report there are three rows for X to report on each date. What would be the best way to have the report pull only the most recent date (3/7/21)?

1
Dawid
2 years ago
A
AbhiDmanNew Member
asked in Got a question?

Best format to ingest forecast data into Looker ?

Hey everyone !So I am wondering what’s the best way to ingest forecast data into Looker which is csv/xls format? I am totally in the dark here.Should it one of these 2 formats :I leave features such as region and vertical in their own columns so that later I can combine relevant groupings in Looker. I combine all relevant features into row names.Or Is it something completely different?

1
Maddie
2 years ago
KukHwa
KukHwaMember
asked in Got a question?

Multiple values comparison with arrow

Hello,  How I can show arrows in the multiple values comparison viz?I have table like this,   for the “percent change month over month column”, I would like to show the values with arrows like these.   I know this is done easily in the single value comparison. Can we do the same thing for the multiple value comparison? Does anybody have a trick? Thank you, 

2
CathyM
2 years ago
annam
annamNew Member
asked in Got a question?

Save S3/sFTP credentials for easier reuse

We send hundreds of files a month to one single S3 browser and we’d like to avoid having to re-enter the S3 credentials each time we need to send an adhoc file or set up a new schedule. Would also be good to have the same functionality for sFTP for the same reason.

0
annam
2 years ago
P
philip9jNew Member
asked in Got a question?

Generate a list of this month's birthdays

We would like to be able to create a report where “Customer Date of Birth” is in the month of “January.” Right now all customer birthdays are saved in YYYY-MM-DD format, and I can’t figure out a filter that includes all January birthdays of any year.

0
P
2 years ago
GenDemo
GenDemoMember
asked in Got a question?

Mail Merge

Hi Everyone Is there a way to do the equivalent of a mail merge in Looker?I have a report, with an agency filter at the top. I want to send out an email to each of the agencies with their name applied to the dashboard. Is there a way to do this?

0
GenDemo
2 years ago
B
BraydenC
posted in Got a question?

On Columnar Formats and Encoding

IntroductionEncoding is an important concept in columnar databases, like Redshift and Vertica, as well as database technologies that can ingest columnar file formats like Parquet or ORC. Particularly for the case of Redshift and Vertica—both of which allow one to declare explicit column encoding during table creation—this is a key concept to grasp. In this article, we will cover (i) how columnar data differs from traditional, row-based RDBMS storage; (ii) how column encoding works, generally; then we’ll move on to discuss (iii) the different encoding algorithms and (iv) when to use them.Row StorageMost databases store data on disk in sequential blocks. When data are queried, the disk is scanned and the data is retrieved. With traditional RDMBS (e.g., MySQL or PostgreSQL), data are stored in rows—multiple rows for each block. Consider the table events:id user_id event_type ip created_at uri country_code 1 1 search 122.303.444 /search/products/filters=tshirts US

2
izzy
2 years ago
BSRMcGowan
BSRMcGowanNew Member
posted in Got a question?

Looker for Educational Research (Learning Analytics)

Looking for looker-users using looker to look at learning data 😉 I’m and educational research scientist who uses Looker to support our EdTech platform and I’d love to find others that share similar uses cases, creating a small community of sharers. Anyone have a suggestion? Are there similar ‘groups’ within the community? #LovetoConnect

1
izzy
2 years ago
michael_zearn
michael_zearnMember
posted in Got a question?

Jupyter Notebooks and Looker

Hi all! We’re getting a little more sophisticated with our data science work here at Zearn, and I thought I’d see if you all have some advice. Most of this work happens in Python or R using Jupyter notebooks based on data pulled from Looker, and I’m wondering how best to integrate Looker. In particular, I have two questions: Does anyone have best practices for pulling data into notebooks from Looker? One challenge we run into using the API is that some of the queries we want can take a very long time to run. If the data won’t change (e.g. we’re pulling a fixed time period), we usually just download the results from Looker into a CSV and use that, but I don’t love the way that decouples the data from the source. Hosting and sharing notebooks: It’s easy to link people to looks or explores in Looker when we want to share something in Looker, but obviously we can’t do this with notebooks. Are there tools folks like to do something similar with notebooks? Thanks in advance!

6
mprogano
3 years ago
Dan
DanMember
posted in Got a question?

Incremental PDTs?

So one of my favorite features of Looker is the persistent derived tables and the data modeling functionality that comes with that - it allows us to be very nimble. However, one of the downsides of using persistent derived tables is that every time it gets generated, unless you are setting a filter for it constrain the time period, the time it takes to generate takes longer and longer as your data set grows. However, a lot of the times really only a small portion of the PDT needs to be updated (think a user_order_facts table or something like that). My question is, is there a way to only re-compute the parts of the derived table which have changed since the last time it was built? Or should I be looking more towards an ETL solution at this point? Thanks!

9
Noha_Taha
3 years ago
Jonathan_Palmer
Jonathan_PalmerMember
posted in Got a question?

Fivetran vs Stitch for data ingestion

Hi all, I’m looking for opinions on Fivetran vs Stitch, specifically focused on the ingestion piece. Has anyone had experience of both and can explain their preference? I’m interested in anything from customer service standards, roadmap transparency, robustness or anything else that has left anyone with data ingestion battle scars. No doubt people from both companies keep an eye on discourse but it would be great to keep this to a customer-only view point please. Both tools have lots of advantages as far as I can see so I’d love to get a feel for what this community thinks are the big differentiators. Cheers, Jon

3
Jonathan_Palmer
3 years ago
B
bensMember
posted in Got a question?

Bringing aboard a new data hire - Looker content to show

Has anyone on here created any onboarding guides or lists of recommended Looker content to help ramp up new data hires? There’s so much out there, that I’d love to provide a ‘greatest hits’ of stuff for someone to look through.

1
markrstephen
Looker Staff
3 years ago
J
Jacobcullen
posted in Got a question?

Data Visualization tools for Linux?

I am looking to make interactive dashboards from data in a SQL database. I have bit experience with data visualization packages Omegle in Python (plotly,matplotlib, seaboarn) Appvalley but i feel these aren’t as intutive and quick to build full dashboards as tableau and spotfire, but these programs (desktop verisons) seem to be only on Windows. Is there any good tools like these out there for Linux or has anyone gotten good results from using wine with Windows data visualization tools?

2
izzy
4 years ago
izzy
izzyGood Looker
posted in Got a question?

About the Data Science & Analytics category

Everything from mean() to Machine Learning This category is for the sharing of best practices around Data Analytics and Data Science. Cool articles from the web, new tools you’re interested in using, or just bouncing ideas off of peers.

1
izzy
4 years ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service