SQLTeam.com | Weblogs | Forums

Basic query

  1. Query the customDimensions structure:
  2. only include clientId, visitId, customDimensions
  3. Now select one combination of clientId, visitId and create a WHERE filter so that your query only shows one record
  4. Now UNNEST the customDimensions .

Listing the steps in your homework isn't asking a question, it is asking us to do your homework for you, which we won't do and also we can't do because even if we were to want to do it for you, which we don't, you have given no information as to your data. So, it looks like you need to go work on your homework.