Skip to main content
In this step, the target table’s structure can be specified, if the table does not exist. Not specifying any structure will cause the import process to infer the table’s structure from the source data. To specify a table structure, click + Add Column once for each field in the source data, then enter the specification for each column, including:
  • Name - name of the column, which must meet the standard naming criteria
  • Type - type of the column, and sub-type, if applicable
  • Nullable - check the box if the column should allow null values
  • Properties - check any properties that should apply to this column:
    • Primary Key - make this column the primary key or part of a composite primary key
    • Shard Key - make this column the shard key or part of a composite shard key
    • Dict. Encoded - apply dictionary encoding to the column’s values, reducing storage used for columns with more often repeated data
    • Init. with Now - replace empty or invalid values inserted into this column with the current date/time
    • Init. with UUID - replace empty values inserted into this column with a universally unique identifier (UUID)
    • Text Search - make this column full-text searchable, using FILTER_BY_STRING in search mode
To remove a column from the proposed target table, click the trash can icon at the far right of the column’s definition. Once the table configuration has been established, click Next to proceed to the Summary page.