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

Exercise

Data type conversion

When working with databases, there are times when you need to change the data type of a column to better suit your operations or analyses.

Continuing your Data Engineer role at Pissa, you will practice converting data between types.

Instructions 1/2

undefined XP
  • 1
    • Select and convert the order_id column from the orders table to VARCHAR using CAST(), aliasing it to order_id_string.
  • 2
    • Select the price column from the pizzas table, converting it (using the double colon operators) to NUMBER data type and aliasing as price_dollars.