1. Home
  2. CLI
  3. Commands
  4. remote
  5. table
  6. import

Table Import

Import data to a table from a Storage file.

kbc remote table import [table] [file] [flags]

Options

-H, --storage-api-host <string>
Keboola instance URL, e.g., connection.keboola.com
--columns <string>
Comma-separated list of column names. If present, the first row in the CSV file is not treated as a header.
--incremental-load <bool>
Data are either added to existing data in the table or replace the existing data.
--file-delimiter <string>
Delimiter of the CSV file. Default is ,.
--file-enclosure <string>
Enclosure of the CSV file. Default is ".
--file-escaped-by <string>
Escape character of the CSV file. By default, no escaping is used. (Note: You can specify either the enclosure or escapedBy parameter, but not both.)
--file-without-headers
States if the CSV file contains headers on the first row or not.

Global Options

Examples

Preview a table in the terminal:

➜ $ cat my.csv | kbc remote table import in.c-main.products 1234567
File with id "1234567" imported to table "in.c-main.products"

➜ kbc remote table import
? Table: <selection prompt>
? File: <selection prompt>

File with id "1234567" imported to table "in.c-main.products"

Next Steps