Insights
Practical knowledge in data, cloud, AI and software development
Articles, technical guides, how-tos, and talks from our team and community. Filter by topic or content type.
Latest insights
-
Looker 101 · Chapter 5
Join tables in Looker
Join four related views under one Looker Explore: set left_outer joins, one_to_many relationships and sql_on conditions, count distinct ponies across joined tables, check fanout, and relabel or hide Explores. Examples…
-
Looker 101 · Chapter 4
How to manually add measures and make your own SQL queries in Looker
Add simple aggregate measures as custom fields, write string, sum and ratio measures in LookML, then use SQL Runner to build a ranked derived table and add it to a…
-
Looker 101 · Chapter 3
Dashboards and Visualizations
Build a Looker dashboard from the eCommerce sample Explores: add visualization and Markdown tiles, format chart axes, add dashboard filters and set automatic refresh. This chapter uses the classic dashboard…
-
Looker 101 · Chapter 2
Creating a project and getting to know LookML
Create a Looker model and LookML project from an existing BigQuery connection, then read the generated view file: sql_table_name, dimensions, dimension groups and measures, using the original test_table example.
-
Looker 101 · Chapter 1
How to connect BigQuery to Looker
Connect BigQuery to Looker by creating a service account, granting it access to your data, uploading its JSON key in Looker’s connection settings and testing the connection. This chapter covers…
-
Airflow XCom Explained: Push, Pull, Default Keys and Practical Examples
The default key for Airflow xcom_pull() is return_value. How push and pull work with PythonOperator, custom keys and TaskFlow, and why xcom_pull() can return None.
