Skip to main content

Snowflake_Connection.copy_into_table

copy_into_tabletable_namestagefile_nameformatmatch_names_insensitivelytruncate_first

Documentation​

Copies data from a staged file into a table. The table must already exist.

Arguments​

  • table_name: The name of the table to copy data into.
  • stage: The name (and optionally schema) of the stage where the file is located.
  • file_name: The full name of the file to copy.
  • format: The file format to use when loading the data.
  • match_names_insensitively: If set to True, column names from the file will be matched to the table columns in a case-insensitive manner. Defaults to True.
  • truncate_first: If set to True, the target table will be truncated before loading data into it. Defaults to False.