COPY INTO

In the Ultra Transcenders books

DP-750DP-600DP-700

Each book explains COPY INTO in context, with comparison tables and the common traps.

Terms in this definition

• Volume

  Holds non-tabular files sitting in cloud storage under Unity Catalog governance, addressed as /Volumes/<catalog>/<schema>/<volume>. A volume can be external or managed, and WRITE VOLUME or READ VOLUME decide who may use it.

• General-purpose v1

  The older storage account kind (Storage), which lacks access tiers, Archive and premium file shares and retires on 13 October 2026. Converting to ZRS requires first upgrading to GPv2, a one-way change.

• Event

  Table in Log Analytics where entries from Windows event logs are kept.

• Auto Loader

  The cloudFiles Structured Streaming source, which picks up new files from cloud storage or volumes as they arrive. Its checkpoint records progress so each file is processed exactly once, and it can infer and evolve the schema.

Related terms

• ENCODING

  A COPY INTO option for CSV sources that states whether the files use UTF8, the default, or UTF16 character encoding.

• ERRORFILE

  Gives COPY INTO somewhere to put rejects: a folder alongside the source files where Fabric saves failed rows to row.csv and the reasons to error.jsonl. Paired with MAXERRORS, a load still counts as successful while rejections stay below that limit, though Parquet loads ignore the option.

• FIELDQUOTE

  Sets the one character COPY INTO treats as the quote mark in CSV files, a double quote by default. Delimiters found between quotes are then kept as ordinary data.

• FIELDTERMINATOR

  Tells COPY INTO which character divides the columns in a CSV file. If left unset, commas are assumed.

• FIRSTROW

  Tells COPY INTO which line of a CSV file to begin loading from. The default is 1; use 2 to skip a header.

• IX lock

  The table lock that data-changing statements (INSERT, UPDATE, DELETE, MERGE, COPY INTO) acquire in a Fabric warehouse. Reads take a Sch-S lock while DDL takes a Sch-M lock that blocks everything else, and current locks can be viewed in sys.dm_tran_locks.

• READ FILES

  Granted on a storage credential or external location, this Unity Catalog permission lets tools like Auto Loader or COPY INTO pull files directly from cloud storage. WRITE FILES can't be used without it.

• Trickle inserts

  A pattern of frequent, small DELETE, UPDATE or INSERT statements on a Fabric warehouse. Every statement creates new Parquet files, so tables become fragmented until background compaction catches up; it is better to group changes into batches and load big files with COPY INTO.