Exit LOOKML-DEVELOPER Looker LookML Developer
Question 4 of 5
0% complete
Q4 Single choice

A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.

How can the developer use SQL Runner to troubleshoot quickly?

  • A

    Create a query that selects all the fields from the table, and sort by primary key.

  • B

    Create a query that selects the primary key from the base view, and look for duplicates.

  • C

    Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.

  • D

    Create a query that concatenates two columns to create a compound primary key.

Previous Next