|Using TenUp ||
TenUp provides numerous options for specifying the metadata of a table after it is uploaded to 1010data. This section details how to specify metadata for columns and tables in both flat files and ODBC-compliant data.
You can provide metadata for your uploaded table directly on the command line. However, if you're making a larger adjustment to your uploaded table, providing all the specifications on the command line could become cumbersome. This is where the table tree and spec tree come in. These external files contain information about the table and columns. The table tree specifies information about the target table in the 1010data Insights Platform, and it can be used with either a flat file upload or an ODBC-compliant database. The spec tree can specify information about the source data and some basic information about the target table, and it can be used for flat file uploads only.
You may specify multiple sources of metadata for the uploaded table. For flat file uploads, you can specify metadata in the command line, table tree, and/or spec tree. For ODBC-compliant data, you can specify metadata in the command line and/or table tree. However, TenUp can use only one source of metadata per option. If multiple sources of metadata are provided for a single option, such as column names, TenUp uses the one with the highest priority. The command line argument for an option always takes precedence, followed by the table tree, and finally (for flat files) the spec tree.
For more information on the 1010data table tree, see Table tree in this guide or the more detailed Table Tree in the 1010data API Reference Manual. For more information on the spec tree, see Spec tree in this guide.
In addition, the Option analog table provides a key to the equivalent types of metadata available in the TenUp command line, table tree, and spec tree.