LookML/Explore → SQL Generator

About this tool

Generate SQL drafts from supported LookML patterns or Explore metadata. Select dimensions, measures, filters and joins, then review the output against your actual model and database.

Features:

LookML parsing — extract supported dimensions and measures
Explore metadata — generate SQL from Explore structure
Visual builder — create queries using form controls
Join support — generate table JOIN clauses
Filters and conditions - WHERE, HAVING, ORDER BY
Aggregations — COUNT, SUM, AVG, MIN and MAX with grouping

Use cases:

Draft queries from LookML, explore model definitions and prepare SQL for reporting outside Looker. Complex LookML may require manual conversion.

LookML code

Generated SQL

Explore metadata

Generated SQL

Query builder

Base table

Dimensions

Measures

Filters (WHERE)

Sorting (ORDER BY)

Generated SQL

LookML examples

view: orders { sql_table_name: public.orders ;; dimension: order_id { type: number sql: ${TABLE}.order_id ;; } dimension: order_date { type: time sql: ${TABLE}.order_date ;; } dimension: customer_name { type: string sql: ${TABLE}.customer_name ;; } measure: total_orders { type: count sql: ${order_id} ;; } measure: total_revenue { type: sum sql: ${TABLE}.revenue ;; } }

view: orders { sql_table_name: public.orders ;; dimension: order_id { type: number sql: ${TABLE}.order_id ;; } dimension: customer_name { type: string sql: ${customers.name} ;; } measure: total_orders { type: count sql: ${order_id} ;; } } view: customers { sql_table_name: public.customers ;; dimension: id { type: number sql: ${TABLE}.id ;; } dimension: name { type: string sql: ${TABLE}.name ;; } } explore: orders_explore { join: customers { sql_on: ${orders.customer_id} = ${customers.id} ;; relationship: many_to_one } }

view: sales { sql_table_name: public.sales ;; dimension: sale_id { type: number sql: ${TABLE}.sale_id ;; } dimension: sale_date { type: time sql: ${TABLE}.sale_date ;; } dimension: product_category { type: string sql: ${products.category} ;; } dimension: region { type: string sql: ${customers.region} ;; } measure: total_sales { type: sum sql: ${TABLE}.amount ;; } measure: avg_sale { type: average sql: ${TABLE}.amount ;; } measure: unique_customers { type: count_distinct sql: ${TABLE}.customer_id ;; } }

LookML → SQL: Looker Explore Query Generator

About this tool

Features:

Use cases:

LookML code

Generated SQL

Explore metadata

Generated SQL

Query builder

Base table

Dimensions

Measures

Filters (WHERE)

Sorting (ORDER BY)

Generated SQL

LookML examples

More tools