📊 Looker Flashcards
🔍 What is Looker?
Looker is a modern business intelligence and data analytics platform by Google Cloud for exploring, analyzing, and sharing data.
📜 What is LookML?
LookML is Looker’s modeling language that defines relationships in your data and powers reports and dashboards.
📈 What is an Explore?
An Explore is a curated data environment where users can interactively build queries and visualizations without writing SQL.
📊 What is a Dashboard?
A dashboard in Looker is a collection of visualizations (tiles) based on saved Looks or direct queries to provide insights.
💡 What is a Look?
A Look is a saved report in Looker, consisting of a specific set of fields, filters, and visualization options.
⚙️ What is a View in LookML?
A View defines a single SQL table or derived table with fields and dimensions that users can explore in Looker.
🔐 What is PDT?
PDT (Persistent Derived Table) is a materialized query result stored in the database, used to speed up performance in Looker.
🔗 What is a Join in LookML?
A Join in LookML defines how different views are related via foreign keys, enabling rich data exploration.
📬 What is a Schedule?
A Schedule in Looker sends reports or dashboards automatically via email, webhook, or other methods at regular intervals.
📁 What is a Model in LookML?
A Model defines the overall data structure, joins, explores, and access permissions for an entire Looker project.
🧪 What is the Development Mode?
Development Mode allows developers to edit LookML code safely without affecting live users until changes are pushed.
📡 What databases does Looker support?
Looker supports a wide range of SQL-compliant databases including BigQuery, Snowflake, Redshift, PostgreSQL, and more.