- Видео 37
- Просмотров 51 569
Spectacles
Добавлен 9 фев 2021
Spectacles is a continuous integration tool for Looker. Spectacles automatically tests your LookML and content, ensuring Looker stays reliable and accurate for your business.
A Quick Guide On Looker White Labelling
Join Simon Clark, a Looker expert who has experience with multiple private label Looker projects, as he walks us through the Looker best practices when using Looker for private/white labelling, including how to model your code, how to manage permissions and the organisational and technical challenges you can face.
This is a great opportunity to learn how Looker can be used in a range of creative ways as the bedrock of first-class public data products.
TIMESTAMPS
0:01 Webinar Preamble
3:50 Overview of Looker white labelling
7:13 Prerequisites for Looker white labelling
9:50 Configuring Looker white labelling
11:33 Re-using an exising LookML model for Looker white labelling
22:07 Re-using internal ...
This is a great opportunity to learn how Looker can be used in a range of creative ways as the bedrock of first-class public data products.
TIMESTAMPS
0:01 Webinar Preamble
3:50 Overview of Looker white labelling
7:13 Prerequisites for Looker white labelling
9:50 Configuring Looker white labelling
11:33 Re-using an exising LookML model for Looker white labelling
22:07 Re-using internal ...
Просмотров: 500
Видео
How To Fix Your Content Lifecycle
Просмотров 21010 месяцев назад
Join Kenny Ning, Looker consultant extraordinaire, as he walks through a common problem: content in Looker has no defined lifecycle (development, staging/review, production). Kenny recommends a thoughtful content lifecycle for Looker that takes advantage of Looker's full feature set, including content access levels, Boards, and even LookML dashboards. TIMESTAMPS 1:17 Start 2:40 Content Outline ...
How to Clean Up Unused Looker Content
Просмотров 74611 месяцев назад
Business intelligence has an addition problem. One more table in the database, one more view in Looker, one more explore for a stakeholder, another 10 dashboards. Initially, this can be amazing with lots of new reports being created around your business. Eventually though, we hit a bloat problem. We don't clean up existing content, people can't find what they are looking for and trust in your B...
A Quick Guide On The Looker Marketplace - Looker Webinars
Просмотров 569Год назад
The Looker Marketplace is packed with useful tools for your organisation. From custom visualisations like heatmaps to applications like the data dictionary, there's inevitably something to super-charge your Looker usage. In this webinar, we'll walk through the different types of content you can download from the Looker Marketplace, show you how to do so, and highlight some of our favourites. TI...
Generating Complete CI Datasets With The New dbt clone Command
Просмотров 957Год назад
When running dbt in CI, there are lots of reasons you might want to generate a complete dataset. Most notably for Spectacles users, complete dbt CI datasets allow you to use Spectacles to test whether your dbt changes are going to break Looker or not. Historically, depending on how you were running dbt, generating these complete datasets could be a pain. You don't want to run a full "dbt run" b...
Implementing Row-Level Data Security in Looker - Looker Webinars
Просмотров 1,7 тыс.Год назад
In this webinar we delve into the intricacies of implementing row-level data security in Looker. We guide you through the process of setting up dynamic, row-level filters for a Looker explore using user attributes and the access_filter parameter. In this webinar, we discuss: -The importance of row-level filtering and its typical use cases. -The step-by-step process of setting up user attributes...
Natural Language Questions In Looker With Delphi - Looker Webinars
Просмотров 891Год назад
Natural Language Questions In Looker With Delphi - Looker Webinars
Home-Grown Cost Savings in Snowflake using dbt & Looker - Looker Webinars
Просмотров 306Год назад
Home-Grown Cost Savings in Snowflake using dbt & Looker - Looker Webinars
Data at Spectacles: Getting Under The Hood - Looker Webinars - Spectacles
Просмотров 165Год назад
Data at Spectacles: Getting Under The Hood - Looker Webinars - Spectacles
Deep Dive Into Your Looker Instance With The System Activity Explores - Looker Webinars - Spectacles
Просмотров 601Год назад
Deep Dive Into Your Looker Instance With The System Activity Explores - Looker Webinars - Spectacles
Exploring The New Google Sheets and Looker Integration - Looker Webinars - Spectacles
Просмотров 832Год назад
Exploring The New Google Sheets and Looker Integration - Looker Webinars - Spectacles
Using A Hub And Spoke Looker Architecture For Scaling Organizations - Looker Webinars - Spectacles
Просмотров 1,1 тыс.Год назад
Using A Hub And Spoke Looker Architecture For Scaling Organizations - Looker Webinars - Spectacles
Leveraging LookML Models in Looker Studio (Google Data Studio) - Looker Webinars
Просмотров 7 тыс.Год назад
Leveraging LookML Models in Looker Studio (Google Data Studio) - Looker Webinars
Robust Access Control And Permission Management - Looker-Focused Webinar - Spectacles
Просмотров 1,7 тыс.Год назад
Robust Access Control And Permission Management - Looker-Focused Webinar - Spectacles
How To Prove The ROI Of Data Quality - Looker-Focused Webinars - Spectacles
Просмотров 170Год назад
How To Prove The ROI Of Data Quality - Looker-Focused Webinars - Spectacles
Scaling Looker Growth And Complexity Over Time - Looker-Focused Webinar - Spectacles
Просмотров 508Год назад
Scaling Looker Growth And Complexity Over Time - Looker-Focused Webinar - Spectacles
Creating Custom Map Visualizations In Looker - Looker-Focused Webinar - Spectacles
Просмотров 5 тыс.Год назад
Creating Custom Map Visualizations In Looker - Looker-Focused Webinar - Spectacles
Spectacles LookML Linter Demo - Introducing The Style Validator
Просмотров 270Год назад
Spectacles LookML Linter Demo - Introducing The Style Validator
Optimising Looker Performance On Snowflake - Spectacles
Просмотров 693Год назад
Optimising Looker Performance On Snowflake - Spectacles
Optimising Cost And Speed Using BigQuery and Looker - Looker-Focused Webinar
Просмотров 1,6 тыс.Год назад
Optimising Cost And Speed Using BigQuery and Looker - Looker-Focused Webinar
An Introduction To The Looker API - Looker-Focused Webinar - Spectacles
Просмотров 9 тыс.Год назад
An Introduction To The Looker API - Looker-Focused Webinar - Spectacles
Linting LookML - Looker-Focused Webinar - Spectacles
Просмотров 497Год назад
Linting LookML - Looker-Focused Webinar - Spectacles
Managing Multi Instance Looker Deployments - Looker-Focused Webinar Series
Просмотров 1,6 тыс.Год назад
Managing Multi Instance Looker Deployments - Looker-Focused Webinar Series
How To Fix Your LookML Project Structure - Looker-Focused Webinar - Spectacles
Просмотров 1,5 тыс.Год назад
How To Fix Your LookML Project Structure - Looker-Focused Webinar - Spectacles
Spectacles Interview at 2021 Looker Product Keynote
Просмотров 1082 года назад
Spectacles Interview at 2021 Looker Product Keynote
facing this issue after integrating it into looker , tho everything is correct Check the LOOKML_MODEL & LOOKML_EXPLORE env variables for your extension. Are they valid (spelling) & exist in your Looker instance? Make sure your user has access to this model and explore. At the very least with see_lookml permissions. Check the Connection environment variables. Do valid BQ connections by those names exist in your Looker instance?
Please make a guided video for step-by-step installation of Explore-assistant on Looker
Dude, spectacles rocks! These guys are serious pros with Looker
great content, thank you.
Viiiioollllllaaaaaaa
Do I need a paid verison of looker in order to access the api explorer?
Can you make a guide video for step by step for doing this
2nd video with audio peaking. You need to invest in a better microphone
Is it possible to get dynamic multiple dimensions in Looker Studio?
So to connect to looker to looker studio we need looker bi subscription? Because looker studio is free as far as I know
My look_id is null when I'm getting dashboard elements... Do you know how I can get data from it without it ?
Thank you ! one question : is there a way to change the google maps locale ? e.g. showing all places in a different language than English
Hi, when I try do add data from looker in looker studio I manage to make connection, i find my models, but the explore I have made are not available... Do you have any idea why?
This is a fabulous content, explained with much clarity. Thanks for all the efforts!! 👍
Hi thanks for the context. but I could not able to enable it. Could you please provide some context related to what all other software needed and procedure. my requirement is: The task involves automating the process of assigning new users to their appropriate groups upon joining and removing users who have resigned from the company. Additionally, the system should send notifications to users who are not using Looker, prompting them to either engage with the platform or have their access removed via the Looker API Instance. The ultimate goal is to establish an ongoing system where the Looker API Instance automatically manages user additions and deletions.
what is the page where they took the client id's and base_url ????????
Thanks for this! Very clear and comprehensive. It's exactly what I needed right now.
Elegant solution. What happens if LookML model contains tables with >20dims? Can this be imported to GDS or GDS Pro?
do you need to have a Developer User/$125 per user per month to use sdk with looker?
Do you know how to embed the LOOKER Dashboard on an already hosted web application basically I want to know about how we can do SSO embedding through looker.
Hi Dino, thanks for the great content! Do you know if its possible for the group creation and users assignment to be dynamic as well? For example if we have thousands of brands, is it possible to read brand/users_assigned from a predefined table in a database instead of creating groups one by one in looker? Thanks
Solved my own question :) we can apply the access_filter based on the system email attribute. access_filter: { field: products.brand_manager #should match the user login email user_attribute: email }
Can we please share the slack channel link here in the comment section or description section.
I don't understand the purpose of using a logical layer (explore file) to define a custom view. How is it different from creating a derived table in a view file and then creating an explore for this view? Thank you.
🍀 "Promosm"
I am very confused by their API. Can I not use it as a normal user? Do I have to pay for pro or something? I have worked with so many API's and this is soooo convoluted. I have a dashboard I made, and I just want to automate connecting data sources. why is this so difficult?
ikr, it's stressing to get simple info too
Can we integrate looker with Qlik sense using Looker api?
Hi Team,
Hi Team, how to integrate lookml and Qliksense using Looker API?
Hi Team, your looker stuff is really good, plz answer my question.. How to Integrate LookML to Qliksense using Looker API ,
Are you able to layer two datasets on one map? I have a bubble map and a filled region map and I want to put the bubble map over the region on, however I can't find anything that suggests it is able to do that.
You guys at Spectacles rock, errbody knows it, but hitting us with these colors while speaking about Looker brings about an irresistible nostalgia 🤩 It's simply comforting having you guys around in this new era for Looker.
Thankyou team !! I request you to make video on SSO Embedding in Looker Using Oauth.
Really really helpful! Thanks mate
Thank you Team Spectacles!
Hi Team Spectacles.. I have one question like is it possible to fetch the all Table Name , Column Name with Data Type which used in looker dashboard So I just want to ask suppose I have dashboard named ABC and I want to find the table name , column name with data type from ABC Dashboard how can I fetch that details. I request you please elaborate on that.
The System Activity > History Explore exposes the SQL query string as well as the dashboard ID/name, so you could theoretically use that to parse out the tables and columns being used. Otherwise you would need to work backwards from the various Explores used in the dashboard, which would be harder.
Thank you team for reply I will try this method.
@@spectacles2071 Under System Activity there no such options History Explorer User activity Content Activity Database Performance Instance performance Performance recommendation Eorrr and broken content Only these options are there
@@techknowledgehub6950 Those are the System Activity dashboards. You will need the System Activity explores: cloud.google.com/looker/docs/usage-reports-with-system-activity-explores#history
Great video! I can't seem to find the Looker internal database instance name for the billing dashboard 'from-clause' (= looker_data in the video).. Where did you extract it from if I may ask?
Glad you liked it! You'll need to create that table yourself as an export from the System Activity > History Explore.
I've been having issues installing the Looker API explorer, do you think you can make a video on that?
We'll consider it! What kind of issues have you been encountering?
Can we get Drilldown queries or results from Looker API?