DataModel Parameter (Connect-Avro Cmdlet)
Specifies the data model to use when parsing Avro documents and generating the database metadata.
Syntax
Connect-Avro -DataModel string
Possible Values
None, Document, FlattenedDocuments, RelationalData Type
cstr
Default Value
"Document"
Remarks
The 本製品 splits documents into rows based on the objects nested in arrays. Select a DataModel configuration to configure how the 本製品 models nested object arrays into tables.
Selecting a Data Modeling Strategy
The following DataModel configurations are available.
-
Document
Returns a single table representing a row for each top-level object. In this data model, any nested object arrays will not be flattened and will be returned as aggregates.
-
FlattenedDocuments
Returns a single table representing a SQL CROSS JOIN of the available documents in the file.
-
Relational
Returns multiple tables, one for each nested object array. In this data model, any nested documents (object arrays) will be returned as relational tables that contain a primary key and a foreign key that links to the parent table.
See Also
- FlattenArrays and FlattenObjects: Customize the columns that will be identified for each of these data models.
- 階層データの解析: Compare the schemas resulting from different DataModel settings, with example queries.