Settings

The Settings tab of the SQL Metadata Tool allows you to determine how you want the SQL Metadata Tool to analyze and import 1010data tables and columns.

Derive SQL column names from 1010 column
You have the choice of deriving SQL columns from 1010data column labels or column names. By default, the SQL Metadata Tool derives SQL columns from column names, but you can change it to labels.

See Columns for more information about 1010data column labels and names.

Large table limit (rows)
The SQL Metadata Tool analyzes the table's column data for unique values (cardinality), whether the column is sorted, and whether there are null values. These tasks are time-consuming for very large tables. By default, for tables over 1 billion rows, the SQL Metadata Tool only approximates cardinality and assumes columns are unsorted. You can change the default value here.
Clear cache between columns when analyzing a table
Since the SQL Metadata Tool analyzes each column of data, you may experience memory problems when loading large tables or a large number of tables. Clearing the cache between columns prevents running out of memory, but slows down the process of analyzing tables and columns.