QuestionQ85Verified/Data Loading, Unloading & ConnectivityCopy linkReport a problemAsk AstroTutorSave questionWhich option defines the column type when data is unloaded into Parquet-formatted files?ABINARY_AS_TEXT = TRUEBEMPTY_FIELD_AS_NULL = FALSECCAST or : : in the COPY INTO statementDSINGLE = TRUEShow AnswerAnswerExplanationUse CAST or the :: cast operator in the COPY INTO <location> query to convert a table column to an explicit data type, thereby selecting its Parquet column type. Options such as BINARY_AS_TEXT, EMPTY_FIELD_AS_NULL, and SINGLE do not define Parquet column data types.Learn moreSnowflake Documentation — Data unloading considerationsShow comments0Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion