Display all users who created an account
2. Open a new tab by clicking on the
+
sign: Query Editor
3. In order to see who created an account, we’ll use the
CustomerInformation
collection. Action Item: In the new empty editor, paste this code.
SQL code
Major SQL code highlights:
- We added lines 1-6 we are selecting all the information and ordering it by
_event_time
in descending order.
4. Go ahead and run the query:
Query editor
NOTE: You can find us on the Rockset Community if you have questions or comments about the workshop.
Last modified 1yr ago