view: track_artist { derived_table: { sql: select * from art_relations.track_artist ;; } measure: count { type: count drill_fields: [detail*] } dimension: id { type: string sql: ${TABLE}.id ;; } dimension: track_id { type: string sql: ${TABLE}.track_id ;; } dimension: type { type: string sql: ${TABLE}.type ;; } dimension: name { type: string sql: ${TABLE}.name ;; } set: detail { fields: [id, track_id, type, name] } }