Tells COPY INTO which line of a CSV file to begin loading from. The default is 1; use 2 to skip a header.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains FIRSTROW in context, with comparison tables and the common traps.
Terms in this definition
- COPY INTO
Loads files from a volume or cloud storage into a Delta table that already exists, skipping anything loaded before, so reruns are safe. Good for thousands of files; for millions, Auto Loader scales further.
- Cluster Shared Volumes
Shared failover cluster storage that all nodes write to simultaneously, typically for Scale-Out File Server or Hyper-V. On SAN-backed storage, ReFS-formatted volumes work in redirected mode.