1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Snowflake SQL
Connected

Exercise

JSONified

Semi-structured data can be challenging to query, so let's practice interacting with Yelpto's data once again.

Here, you will filter the contents of a VARIANT column.

Instructions

100 XP
  • Filter where the DogsAllowed key in the attributes column is 'True' (note this is a string, not boolean).
  • Filter where the BusinessAcceptsCreditCards key in the attributes column is 'True' (note this is a string, not boolean).
Powered by Snowflake