The table has 2 results, both unique, but at scale there might be duplicates their might be unique values.
SELECT DISTINCT * FROM customer_records
Execution ID:: bc4bdcb6-9e32-4ed9-9d7d-8330ada7f030
Returns 0 rows of data
SELECT DISTINCT "First Name" FROM customer_records
Execution ID: bd1d29b6-6fd7-4a3b-89ab-62895d884cd1
Returns 0 rows of data
(Example of all data: SELECT * FROM customer_records : Execution ID:
466123f4-a04a-4197-a937-76bfb23d0506 )
Is Select Distinct supported for datastore or is there another way to get unique values in the same query?
I'll use a workaround of putting the data into the Query JSON WA and then using Distinct, but wanted to check if I could do it in the initial query
@Product
