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?
Create a query that selects all the fields from the table, and sort by primary key.
Create a query that selects the primary key from the base view, and look forduplicates.
Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.
Create a query that concatenates two columns to create a compound primary key.
Submit