.
).
) contained in the column name will be replaced with underscores (_
). This is due to a dot being a reserved character used by Fully Qualified Column Namesusage.csv
will have an alias of usage
.<basedir>\collected
. The sub-directories are named according to the data source and datadate associated with that data. The naming convention is as follows:<data_source>
is a descriptive name for the external source from which the data was collected<yyyy>
is the year of the datadate as a 4-digit number<MM>
is the month of the datadate as a 2 digit number<dd>
is the day of the month of the datadate as a 2 digit numberimport usage from Azure
<basedir>\collected\Azure\2016\08\01_usage.csv
, and assign it a Source tag of Azure.import my_custom_data\mycosts.csv source costs
<basedir>\my_custom_data\mycosts.csv
and assign it a Source tag of costs. Checks are done during the import process to ensure that every imported Dataset has a unique source.alias
combination.Azure.usage.MeterName
explicitly refers to the column called MeterName in the DSET Azure.usage.