1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Introduction to Snowflake SQL
Connected

Bài tập

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.

Hướng dẫn

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