LoslegenKostenlos starten

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?

Diese Übung ist Teil des Kurses

<Kurs>Intro to Snowflake for Devs, Data Scientists, Data Engineers</Kurs>
Kurs ansehen

Interaktive praktische Übung

Verwandle Theorie mit einer unserer interaktiven Übungen in die Praxis

Übung starten