Creating a Columnar View of Array Elements
Note:
- This feature is not supported for Couchbase and DocumentDB.
- The Schema Editor supports columnar views for all forms of array data structures. For example, in addition to creating columnar views of arrays from MongoDB, you can also create columnar views of lists, maps, and sets from DynamoDB.
To support arrays, the Schema Editor creates virtual tables. Each virtual table is a child object of the table that contains the array, and each row in a virtual table contains an array element. As an alternative, you can create a columnar view of the array elements in the parent table. For an example of how a virtual table representation of an array compares to a columnar view, see Example of Virtual Tables vs. Columnar Views.
To create a columnar view of array elements:
- In the Design View, in the left pane, select the virtual table containing the array elements for which you want to create a columnar view.
- In the main pane, select the virtual table column that contains the array elements.
- Click Move to Parent.
- When prompted, in the Number of Array Elements to Show in Parent field, type the number of array elements for which you want to create a columnar view, and then click OK.
In the parent table, the Schema Editor creates columns that contain the array elements.