Stages and Basic Ingestion — Question 2
Run the following code: -- truck table build CREATE OR REPLACE TABLE test_ingestion.public.truck ( truck_id NUMBER(38,0), menu_type_id NUMBER(38,0), primary_city VARCHAR(16777216), region VARCHAR(16777216), iso_region VARCHAR(16777216), country VARCHAR(16777216), iso_country_code VARCHAR(16777216), franchise_flag NUMBER(38,0), year NUMBER(38,0), make VARCHAR(16777216), model VARCHAR(16777216), ev_flag NUMBER(38,0), franchise_id NUMBER(38,0), truck_opening_date DATE ); Then use the COPY INTO command to copy into the test_ingestion.public.truck table from the test_ingestion.public.test_stage stage. What number do you see in the rows_parsed column?
This exercise is part of the course
Intro to Snowflake for Devs, Data Scientists, Data Engineers
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise