Can I generate a uuid4 column when I do a COPY INTO command?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-01-2024 07:40 PM
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. Now I want to save the records to a table, and run a COPY INTO command every day to ingest new records. 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. Is this possible?