Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-25-2024 03:13 PM
@yubin-apollo: Hello, there. I was testing the copy into command with the skipRows option and it doesn't seem to work. Were you able to figure out the right way or is it a bug? Thanks.
Here is the query for reference
COPY INTO dummynamespace.dummytable
FROM
'azure blob xxx'
WITH ( CREDENTIAL (AZURE_SAS_TOKEN = 'zzz') )
FILEFORMAT = CSV
PATTERN = 'Employees_*.csv'
FORMAT_OPTIONS ('mergeSchema' = 'true',
'delimiter' = ',',
'header'='true'
)
COPY_OPTIONS ('mergeSchema' = 'true',
'skipRows' = '3')