COPY INTO skipRows FORMAT_OPTIONS does not work
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-30-2022 10:26 AM
Based on the COPY INTO documentation, it seems I can use `skipRows` to skip the first `n` rows. I am trying to load a CSV file where I need to skip a few first rows in the file. I have tried various combinations, e.g. setting header parameter on or off, mergeSchema on or off. I think I tried most cases I can think of, and any of these does not skip the first `n` rows. Has anybody experience this issue?
COPY INTO Documentation: https://docs.databricks.com/sql/language-manual/delta-copy-into.html
Labels:
- Labels:
-
Copy
-
Copy into
-
FORMAT OPTIONS