Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-23-2025 09:02 AM
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_file
from "/Volumes/dbacademy_ecommerce/v01/raw/users-historical/")
FILEFORMAT = PARQUET
COPY_OPTIONS ('mergeSchema' = 'true');
