CommencerCommencez gratuitement

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?

Cet exercice fait partie du cours

<cours>Intro to Snowflake for Devs, Data Scientists, Data Engineers</cours>
Voir le cours

Exercice interactif pratique

Transformez la théorie en action avec l’un de nos exercices interactifs

Commencer l’exercice