QuestionQ3Verified/Ingest and Process DataCopy linkReport a problemAsk AstroTutorSave questionWhich command successfully loads data into the table named finance_dept_location?Acopy into finance_dept_location(city, zip, sale_date, price)from (select t.$1, t.$2, t.$3, t.$4 from @finstage/finance.csv.gz t) file_format = (format_name = fincsvformat);Bcopy into finance_dept_location(city, zip, sale_date, price)from (select t.$1, t.$2, t.$3, t.$4 from @finstage/finance.csv.gz t) file_format = (format_name = fincsvformat) validation_mode=return_all_errors;Ccopy into finance_dept_location(city, zip, sale_date, price)from (select t.$1, t.$2, t.$3, t.$4 from @finstage/finance.csv.gz t limit 100) file_format = (format_name = fincsvformat);Dcopy into finance_dept_location(city, zip, sale_date, price)from (select t.$1, t.$2, t.$3, t.$4 from @finstage/finance.csv.gz t where t.$1 like '%austin%') file_format = (format_name = fincsvformat);Show AnswerAnswerExplanationSnowflake supports loading selected staged-file columns through a COPY INTO ... FROM (SELECT ...) transformation. A transformation cannot use WHERE or LIMIT, and VALIDATION_MODE is unsupported for transformed COPY loads and performs validation rather than loading data.Learn moreTransform data during a load | Snowflake DocumentationCOPY INTO <table> | Snowflake DocumentationShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion