 |
Consumption Analytics Documentation |
|
Consumption Analytics Documentation |
This article specifies the format of a CSV file that is required to import schemas with ccimport and written by ccexport.
The first line of the file is a header row that defines the format of the subsequent rows. The following table describes the valid field names for the header row, some of which also have short names that you can use instead. In the full field names, you can substitute dots (.) for underscores (_).
CSV rows beginning with a pound sign (#) are treated as comments and ignored by the importer.
| Field Name | Short Name | Description | Required |
|---|---|---|---|
|
|
| Schema name | Yes |
|
|
| Schema description | No |
account_required |
| Whether an account is required: 1/0 or true/false | Yes |
|
|
| Is passthrough? | Yes |
|
|
| Valid values: D(dimension),M(measure) | Yes |
|
|
| Field name | Yes |
|
|
| Field description | No |
|
|
| Is field required? | Yes |
|
|
| Whether dimension is a key? | No |
|
|
| Measure units description | No |
|
|
| If measure is allocated? | No |
|
|
| Unit conversion operator. Valid values: Default value: | No |
|
|
| Unit conversion factor or divisor | No |
The following is a sample CSV file. Quotes are required only for fields that contain a comma in their value.
schema_name,schema_desc,account_required,passthrough,field_type,field_name,field_desc,field_required,dimension_is_key,measure_units,measure_allocation Network,Network infrastructure,1,1,d,Name,Name of network,1,1,, Network,Network infrastructure,1,1,m,Bytes In,Network bytes in,1,,bytes,0 Network,Network infrastructure,1,1,m,Bytes Out,Network bytes out,1,,bytes,0 Network,Network infrastructure,1,1,m,IP Address,IP address,1,,bytes,1 Storage,Storage,1,1,d,Name,Name of storage instance (i.e. volume name),1,0,, Storage,Storage,1,1,d,Storage Type,Type of storage,1,0,, Storage,Storage,1,1,d,User,Owner of storage,1,0,, Storage,Storage,1,1,m,Disk Allocated,Storage disk allocated,1,,GB,1 Storage,Storage,1,1,m,Disk Used,Storage disk used,1,,GB,0 Virtual Machine,Virtual Machines,1,1,d,Host Name,Host name of the virtual machine,0,0,, Virtual Machine,Virtual Machines,1,1,d,Image Name,Name of the image used to create the virtual machine,0,0,, Virtual Machine,Virtual Machines,1,1,d,State,Operational state of the virtual machine,0,0,, Virtual Machine,Virtual Machines,1,1,d,Type,Type of the virtual machine,0,0,, Virtual Machine,Virtual Machines,1,1,d,User,Owner of the virtual machine,1,1,, Virtual Machine,Virtual Machines,1,1,d,VM Name,Name of the virtual machine,1,1,, Virtual Machine,Virtual Machines,1,1,m,bytesIn,Network bytes in,1,,bytes,0 Virtual Machine,Virtual Machines,1,1,m,bytesOut,Network bytes out,1,,bytes,0 Virtual Machine,Virtual Machines,1,1,m,vCPU,Number of CPUs allocated,1,,cpu,1 Virtual Machine,Virtual Machines,1,1,m,vDisk,Disk storage allocated,1,,GB,1 Virtual Machine,Virtual Machines,1,1,m,vMemory,Memory allocated,1,,GB,1