1. Học hỏi
    2. /
  2. Khoa Học
    3. /
  3. Data Types and Functions in Snowflake
Connected

Bài tập

Transforming text data

If you take a look, all user_id's in the members table start with user_ followed by a string of numbers. You're interested in providing members with their unique user ID, minus the user_ prefix. This will allow them to quickly sign in to their app and the gym itself. In this exercise, you'll practice using two different tools to do this.

Hướng dẫn 1/3

undefined XP
    1
    2
    3
  • Using the SPLIT function on user_id, return only the text after the _; you can assume there is only one underscore in each user_id.