MetaMiner Database Structure¶
MetaMiner Tableau Edition stores most of its data within MetaMiner Database (MMDB) in PostgreSQL RDBMS. This includes but not limited to the following data:
- BI/Analytic platform metadata (SAP BO and/or Tableau Software, depending on your configuration)
- Database systems (PostgreSQL)
- Performance metrics from application servers
Usually, MMTE writes source data extracted from your BI landscape into MMDB. Then MMTE uses it for data visualization in MMC and also allows you to compose and execute SQL queries on it in Meta Query for further processing. That is why its structure is so important.
The default name for MetaMiner Database is metaminer.
Schemas¶
MetaMiner Database includes the following schemas:
| Schema Name | Description |
|---|---|
| metrics | Data for metrics in Pulse/Grafana for Tableau environments. (Metric data for SAP BO environments is stored in InfluxDB) You can also use this data in your alerts. See below for details. |
| mms | Technical data of pull engine and other MMS activities. See below for details. |
| tableau | BI data from Tableau environments. See below for details. |
| public |
|
| information_schema | Standard PostgreSQL schema that contains general information about this database. |
| pg_catalog | Standard PostgreSQL system catalog schema. It includes information about tables and columns in this database. |
| pg_toast* | PostgreSQL schemas for TOAST tables. |
| pg_temp* | PostgreSQL schemas for session temporary tables. |
Metrics Schema¶
The list of tables in the metrics schema of MMDB:
| Table Name | Description |
|---|---|
| metrics_schema_versions | Migrations that have been run on this schema. |
| server_metrics_numeric | Numeric values of metrics. |
| server_metrics_numeric_pack | Non-numeric values of metrics. |
| tab_machines | Tableau Servers added to your configuration. |
| tab_machines_attributes | Hardware parameters of Tableau Servers. |
| tab_nodes | Tableau nodes stats. |
| tab_nodes_pack | Tableau nodes stats. |
| tab_processes | Processes running on Tableau Servers. |
| tab_processes_pack | Processes running on Tableau Servers. |
| tab_service_availability | Results of Tableau service availability checks. |
| tab_service_statuses | List of possible Tableau service statuses. |
| tab_service_types | List of possible Tableau Server types. |
| webi_activities | WebIntelligence metrics, not applicable to Tableau Edition. |
| webi_activities_ext | WebIntelligence metrics, not applicable to Tableau Edition. |
MMS Schema¶
The list of tables in the mms schema of MMDB:
| Table Name | Description |
|---|---|
| mms_schema_versions | Migrations that have been run on this schema. |
| pg_nbr_sessions | Database sessions. |
| pg_stat_activity_history | Historical events log. |
| pull_history | Reserved. |
| tab_deep_process_statistic | Reserved. |
Tableau Schema¶
The list of tables in the tableau schema of MMDB:
Note
Table and column names in Meta Query and this article are shown in UPPER CASE. Real table and column names (available in psql and other database tools) are in lower case.
| Table Name | System Object |
|---|---|
| BACKGROUND_JOBS | Job |
| CAPABILITIES | Capability |
| CAPABILITY_ROLES | Capability-role relation |
| COLUMN_ASSETS | Asset |
| COMMENTS | Comment |
| CUSTOMIZED_VIEWS | View |
| DATA_ALERTS | Alert |
| DATA_ALERTS_RECIPIENTS | User |
| DATA_CONNECTION_XML_RELATIONS | Data source-connection relation |
| DATA_CONNECTION_XML_TABLES | Data source-table relation |
| DATA_CONNECTIONS | Connection |
| DATA_ROLES | Role |
| DATABASE_ASSETS | Database |
| DATASOURCE_XML_FIELDS | Data source field (column) |
| DATASOURCES | Data source |
| DATASOURCES_IA | Data source (Impact Analysis) |
| DOMAINS | DNS domain |
| ENVIRONMENTS | Environment |
| FLOW_EVENTS | Event |
| FLOW_INPUT_STEPS | Flow input step |
| FLOW_MODELS | Flow model |
| FLOW_OUTPUT_STEP_RUNS | Flow output run |
| FLOW_RUN_ERRORS | Error |
| FLOW_RUN_SPEC_OUTPUT_STEPS | Flow output step |
| FLOW_RUN_SPECS | Flow run config |
| FLOW_RUNS | Flow run |
| FLOW_VERSIONS | Version |
| FLOWS | Flow |
| GROUP_USERS | User |
| GROUPS | Group |
| HIST_CAPABILITIES | Capability |
| HIST_COLUMN_ASSETS | Column |
| HIST_COMMENTS | Comment |
| HIST_CONFIGS | Config |
| HIST_DATA_CONNECTIONS | Connection |
| HIST_DATA_ROLES | Role |
| HIST_DATABASE_ASSETS | Database |
| HIST_DATASOURCES | Data source |
| HIST_FLOWS | Flow |
| HIST_GROUPS | Group |
| HIST_LICENSING_ROLES | Role |
| HIST_METRICS | Metric |
| HIST_PROJECTS | Project |
| HIST_REMOTE_AGENTS | Remote agent |
| HIST_SCHEDULES | Schedule |
| HIST_SITES | Site |
| HIST_TABLE_ASSETS | Table |
| HIST_TAGS | Tag |
| HIST_TASKS | Task |
| HIST_USERS | User |
| HIST_VIEWS | View |
| HIST_WORKBOOKS | Workbook |
| HISTORICAL_EVENT_TYPES | Event type |
| HISTORICAL_EVENTS | Event |
| HISTORICAL_EVENT_AGG1 | Event |
| HTTP_REQUESTS | HTTP request |
| HTTP_REQUESTS_AGG1 | HTTP request |
| IDENTITY_BASED_ACTIVATION_REPORTING | Login-based license |
| IDENTITY_BASED_ACTIVATION_USER_ROLE_CHANGE | Login-based license |
| LICENSING_ROLES | Role |
| MMDB_VERSIONS | Migration history of MMDB |
| MOST_RECENT_SUBSCRIPTION_RUNS | Subscription run |
| NEXT_GEN_PERMISSIONS | Permission |
| PERMISSIONS_TEMPLATES | Permission template |
| PROJECTS | Project |
| REAL_CONNECTIONS | Connection |
| REAL_CONNECTIONS_DATA_CONNECTIONS | Connection relation |
| REAL_CONNECTIONS_DATASOURCES | Data source relation |
| REAL_CONNECTIONS_WORKBOOKS | Workbook relation |
| REAL_CONNECTIONS_WORKSHEETS_XML | Sheet relation |
| REAL_FIELDS | Field |
| REAL_FIELDS_DATASOURCE_XML_FIELDS | Field relation |
| REAL_FIELDS_DATASOURCES | Data source relation |
| REAL_FIELDS_WORKBOOKS | Workbook relation |
| REAL_FIELDS_WORKSHEETS_XML | Sheet relation |
| REAL_TABLES | Table |
| REAL_TABLES_DATASOURCES | Data source relation |
| REAL_TABLES_WORKBOOKS | Workbook relation |
| REAL_TABLES_WORKSHEETS_XML | Sheet relation |
| REMOTE_AGENTS | Remote agent |
| ROLES | Role |
| SCHEDULES | Schedule |
| SERIAL_COLLECTIONS | Job |
| SERVER_PROC_DICT | Tableau process type |
| SERVER_PROCESSES | Tableau process |
| SESSIONS | Browser session |
| SITE_ROLES | Role |
| SITES | Site |
| SUBSCRIPTION_MESSAGES | Message text |
| SUBSCRIPTIONS | Subscription |
| SUBSCRIPTIONS_CUSTOMIZED_VIEWS | View relation |
| SUBSCRIPTIONS_VIEWS | View relation |
| SUBSCRIPTIONS_WORKBOOKS | Workbook relation |
| SYSTEM_USERS | User |
| TABLE_ASSETS | Table |
| TAGGINGS | Tag relation |
| TAGS | Tag |
| TASKS | Task |
| USERS | User |
| VIEWS | View |
| VIEWS_STATS | View |
| WORKBOOKS | Workbook |
| WORKBOOKS_IA | Workbook (Impact Analysis) |
| WORKERS | Worker |
| WORKSHEET_XML_FIELDS | Field relation |
| WORKSHEETS_XML | Sheet |
| XML_VIEW_RELATIONS | View relation |
| XML_VIEWS | View |