- 4118 Views
- 4 replies
- 0 kudos
Resolved! Reference file name when using COPY INTO?
When using the COPY INTO statement is it possible to reference the current file name in the select staement? A generic example is shown below, hoping I can log the file name in the target table.COPY INTO my_table FROM (SELECT key, index, textData, ...
- 4118 Views
- 4 replies
- 0 kudos
- 0 kudos
In sql, with a subselect works just fine %sql COPY INTO tabele_copy_into_test from ( SELECT user_id, email, _metadata.file_name AS source_filefrom "/Volumes/dbacademy_ecommerce/v01/raw/users-historical/")FILEFORMAT = PARQUETCOPY_OPTIONS ('m...
- 0 kudos
- 1075 Views
- 0 replies
- 0 kudos
How to customize the result of COPY INTO command?
COPY INTO statement produces results in following format, which is more similar to INSERT INTO statement results; also it's a summary of all the files loaded. Is there a way to customize in way that it produces the detailed results at file level?
- 1075 Views
- 0 replies
- 0 kudos