Class ImportContext.CsvImportOptionsData
Options for importing data as CSV.
Inherited Members
Namespace: Google.Apis.SQLAdmin.v1.Data
Assembly: Google.Apis.SQLAdmin.v1.dll
Syntax
public class ImportContext.CsvImportOptionsDataProperties
Columns
The columns to which CSV data is imported. If not specified, all columns of the database table are loaded with CSV data.
Declaration
[JsonProperty("columns")]
public virtual IList<string> Columns { get; set; }Property Value
| Type | Description |
|---|---|
| IList<string> |
EscapeCharacter
Specifies the character that should appear before a data character that needs to be escaped.
Declaration
[JsonProperty("escapeCharacter")]
public virtual string EscapeCharacter { get; set; }Property Value
| Type | Description |
|---|---|
| string |
FieldsTerminatedBy
Specifies the character that separates columns within each row (line) of the file.
Declaration
[JsonProperty("fieldsTerminatedBy")]
public virtual string FieldsTerminatedBy { get; set; }Property Value
| Type | Description |
|---|---|
| string |
LinesTerminatedBy
This is used to separate lines. If a line does not contain all fields, the rest of the columns are set to their default values.
Declaration
[JsonProperty("linesTerminatedBy")]
public virtual string LinesTerminatedBy { get; set; }Property Value
| Type | Description |
|---|---|
| string |
QuoteCharacter
Specifies the quoting character to be used when a data value is quoted.
Declaration
[JsonProperty("quoteCharacter")]
public virtual string QuoteCharacter { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Table
The table to which CSV data is imported.
Declaration
[JsonProperty("table")]
public virtual string Table { get; set; }Property Value
| Type | Description |
|---|---|
| string |