Panoply documentation is moving! Click here to view the new site! __________________________________________________________________________________________________________________
Because MongoDB data comes from a database system, Panoply cannot provide a data dictionary. But Panoply does automate the data schema for the collected data. This section includes useful information about the Panoply automations.
A column in a table uses the same data type for all values in that column. Panoply automatically chooses the data type for each column based on the available values. This is important to note for this data source. If even one value in a column has text, then the entire column is considered data type
The following metadata columns are added to the destination table(s):
__databasename- The name of the Data Dictionary database where the data originated.
__collection- The name of the source table in Data Dictionary.
id- If you do not select a primary key, and no
idcolumn exists in the source table, Panoply will insert an
id. Formatted as a GUID, such as
__senttime- Formatted as a datetime, such as
__updatetime- Formatted as a datetime, such as
__state- Reserved for internal Panoply use.