https://community.databricks.com/t5/data-engineering/can-i-generate-a-uuid4-column-when-i-do-a-copy-into-command/m-p/62467#M31977 <P>I have raw call log data and the logs don't have a unique id number so I generate a uuid4 number when i load them using spark.&nbsp; Now I want to save the records to a table, and run a COPY INTO command every day to ingest new records.&nbsp; I am only appending new records, never updating, and I want to generate the uuid column on the COPY INTO command the same way I do when i read the files into the dataframe.&nbsp; Is this possible?</P> Sat, 02 Mar 2024 03:40:08 GMT chrisf_sts 2024-03-02T03:40:08Z https://community.databricks.com/t5/data-engineering/can-i-generate-a-uuid4-column-when-i-do-a-copy-into-command/m-p/62467#M31977 <P>I have raw call log data and the logs don't have a unique id number so I generate a uuid4 number when i load them using spark.&nbsp; Now I want to save the records to a table, and run a COPY INTO command every day to ingest new records.&nbsp; I am only appending new records, never updating, and I want to generate the uuid column on the COPY INTO command the same way I do when i read the files into the dataframe.&nbsp; Is this possible?</P> Sat, 02 Mar 2024 03:40:08 GMT https://community.databricks.com/t5/data-engineering/can-i-generate-a-uuid4-column-when-i-do-a-copy-into-command/m-p/62467#M31977 chrisf_sts 2024-03-02T03:40:08Z