gcloud beta sql import csv

NAME
gcloud beta sql import csv - imports data into a Cloud SQL instance from a CSV file
SYNOPSIS
gcloud beta sql import csvINSTANCEURI--database=DATABASE,-dDATABASE--table=TABLE[--async][--columns=COLUMNS,[COLUMNS,…]][--escape=ESCAPE][--fields-terminated-by=FIELDS_TERMINATED_BY][--lines-terminated-by=LINES_TERMINATED_BY][--quote=QUOTE][--user=USER][GCLOUD_WIDE_FLAG …]
DESCRIPTION
(BETA) Imports data into a Cloud SQL instance from a plain textfile in a Google Cloud Storage bucket with one line per row and comma-separatedfields.
POSITIONAL ARGUMENTS
INSTANCE
Cloud SQL instance ID.
URI
Path to the CSV file in Google Cloud Storage from which the import is made. TheURI is in the formgs://bucketName/fileName. Compressed gzip files(.gz) are also supported.
REQUIRED FLAGS
--database=DATABASE,-dDATABASE
The database (for example, guestbook) to which the import is made.
--table=TABLE
The database table to import csv file into.
OPTIONAL FLAGS
--async
Return immediately, without waiting for the operation in progress to complete.
--columns=COLUMNS,[COLUMNS,…]
The columns to import from csv file. These correspond to actual database columnsto import. If not set, all columns from csv file are imported to correspondingdatabase columns.
--escape=ESCAPE
Specifies the character that should appear before a data character that needs tobe escaped. The value of this argument has to be a character in Hex ASCII Code.For example, "22" represents double quotes. This flag is only available forMySQL and Postgres. If this flag is not provided, double quotes character willbe used as the default value.
--fields-terminated-by=FIELDS_TERMINATED_BY
Specifies the character that splits column values. The value of this argumenthas to be a character in Hex ASCII Code. For example, "2C" represents a comma.This flag is only available for MySQL and Postgres. If this flag is notprovided, a comma character will be used as the default value.
--lines-terminated-by=LINES_TERMINATED_BY
Specifies the character that split line records. The value of this argument hasto be a character in Hex ASCII Code. For example, "0A" represents a new line.This flag is only available for MySQL. If this flag is not provided, a new linecharacter will be used as the default value.
--quote=QUOTE
Specifies the character that encloses values from columns that have string datatype. The value of this argument has to be a character in Hex ASCII Code. Forexample, "22" represents double quotes. This flag is only available for MySQLand Postgres. If this flag is not provided, double quotes character will be usedas the default value.
--user=USER
PostgreSQL user for this import operation.
GCLOUD WIDE FLAGS
These flags are available to all commands:--access-token-file,--account,--billing-project,--configuration,--flags-file,--flatten,--format,--help,--impersonate-service-account,--log-http,--project,--quiet,--trace-token,--user-output-enabled,--verbosity.

Run$gcloud help for details.

NOTES
This command is currently in beta and might change without notice. Thesevariants are also available:
gcloudsqlimportcsv
gcloudalphasqlimportcsv

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-05-07 UTC.