- 34
- 45 714
Spectacles
Registrace 9. 02. 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.
Video
Demystifying LLM training and optimisation for analytics
Před 2 dny
Harnessing the power of LLMs for analytics can be transformative, but understanding best practices is key. With Looker, tools like the Explore Assistant have shown the potential of LLMs, but custom solutions using tools like Gemini and Vertex can elevate your analytics further. The Bytecode team has been developing GenAI solutions for analytics using Looker. In this webinar, they will share bes...
Centralized Alerting for Data Incidents in Looker
zhlédnutí 61Před 7 dny
Data integrity is crucial for business intelligence, and alerting users to data issues efficiently is a significant challenge. Join us for a webinar featuring Michael Letheby and Jonny Rogers from Canva, where they will showcase an alerting system developed to add alert banners to dashboards during data incidents. Canva’s alerting system addresses the lack of a centralized notification method, ...
Complete CI for dbt + Looker with the new Paradime Spectacles integration
Před 9 dny
Ensuring comprehensive test coverage is essential for maintaining the integrity of your data pipeline. When multiple tools are involved, like dbt and Looker, this gets all the more complicated. Luckily, Paradime and Spectacles have got you covered! Paradime’s new Looker Spectacles integration provides end-to-end test coverage for dbt and Looker, addressing the need for robust testing and valida...
Set up your own Looker dashboard summariser on GCP using Vertex AI
zhlédnutí 128Před 21 dnem
As part of the recent Looker Hackathon [Vertex AI Edition], the Spectacles team won the Best Hack award! They developed tl;dd (too long; didn't dashboard), a Looker extension that replaces scheduled dashboard emails with AI-generated summaries. We all know the feeling of being overwhelmed by scheduled reports and wondering if anything has actually changed since the last one. With tl;dd, instead...
A guide to building a conversational AI agent with Looker
zhlédnutí 163Před měsícem
Implementing LLMs to “chat with your data” is powerful but challenging. Perfecting prompts, training models, and building UIs require diverse expertise. Join our webinar with Erik Kuld, CEO of Inventive, who will share their experience developing AI agents for Looker models. Inventive aids enterprise teams overwhelmed by custom data requests, providing a conversational AI Analyst that integrate...
Delivering the third wave of BI in the AI era with Looker
zhlédnutí 233Před měsícem
AI is revolutionising business intelligence. In the case of Looker, this couldn't be more clear with the upcoming addition of a plethora of new tools, including the Explore Assistant, Conversational Analytics, LookML Assistant, and much more. We are joined this week by Sean Zinsmeister, Director of Outbound Product Management, Data & Analytics at Google. In this webinar, Sean will outline the i...
Preparing Your LookML For GenAI And Conversational Analytics
zhlédnutí 354Před 2 měsíci
AI is coming to Looker. With LLMs and all of Google Cloud's new GenAI capabilities, you can now ask questions of your Looker data in brand new ways. What does this mean for your LookML? Well, we now need to consider much more carefully how the quality of our LookML will impact what comes out of these new systems. Field descriptions, unused LookML, and sensible explore design is now of the utmos...
Testing Looker's New AI Explore Assistant
zhlédnutí 1,4KPřed 2 měsíci
At Google Cloud Next 2024, there was a clear and obvious focus on generative AI, which included exciting new extensions for Looker. One of those extensions was a the Looker Explore Assistant, an extension or API plugin for Looker that allows you to ask natural language questions and get data returned back to you, using your LookML semantic layer. Join us for this webinar as we walk through how ...
A Quick Guide On Looker White Labelling
zhlédnutí 419Před 8 měsíci
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 creativ...
How To Fix Your Content Lifecycle
zhlédnutí 190Před 8 měsíci
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
zhlédnutí 646Před 9 měsíci
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
zhlédnutí 503Před 10 měsíci
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
zhlédnutí 883Před 11 měsíci
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
zhlédnutí 1,4KPřed 11 měsíci
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
zhlédnutí 807Před rokem
LLMs are all anyone is talking about recently. ChatGPT has become a verb at a record speed. Now, using Delphi's new Looker integration, you can ask Looker questions the same way you'd ask anyone a question. What is our revenue so far this year? How does that compare to last year? Are specific products responsible for the increase? Join us as the Delphi team talk us through how their Looker inte...
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.
Can we download all of the dashboard data through an API call?
You can, but not in a single API call. You'll need to get the dashboard elements (the response contains the query), then run those queries, applying any filters, with the Run Query endpoint. Alternatively, if you have a schedule set up already, you can use the Run Scheduled Plan Once endpoint to send your schedule on demand. It's a bit easier for Looks, there's a Run Look endpoint you can use directly.
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?