QuestionQ34Verified/Official exam objectives/topicsCopy linkReport a problemAsk AstroTutorSave questionWhich command loads all data successfully into the table named finance_dept_location?ABCDShow AnswerAnswerExplanationA COPY INTO <table> statement can load staged-file columns through a SELECT transformation. Selecting $1 through $4 without a LIMIT or WHERE clause passes every row from the staged file to the four specified target columns. VALIDATION_MODE validates instead of loading data and does not support COPY statements that transform data during loading.Learn moreSnowflake Documentation: COPY INTO <table>Show comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion