CREATE TABLE myspecies

A BULK INSERT statement will read data from a CSV file then insert to myspecies table.

The STRINGSET data type allows a comma-separated array of data to be inserted in a single table record.

Before you begin

• Learn about data modeling low-cardinality data
• STRINGSET data type

CREATE TABLE statement

CREATE TABLE myspecies
  (
    _id string,
    species stringset
  );

Next step

• Create a CSV data source then run BULK INSERT