| AP |
BAO Analytics Platform (AP) is a software platform for data integration and advanced analytics. |
| Apache Superset |
Apache Superset is an open-source data exploration and visualization platform designed to be intuitive and highly accessible for business intelligence purposes. |
| BI |
Business Intelligence (BI) refers to the technologies, applications and practices used to collect, analyze, integrate, and present business information. |
| Data pipeline |
A series of processing steps to move data from a source system into the AP. The AP implements “ELT” (extract, load, and transform) pipelines. |
| Data catalog |
An inventory of the data warehouse’s datasets (tables) as well as a dataset’s metadata such as table name, description, data types. |
| Destination |
Allows users to make data available to downstream/destination systems. |
| Data quality check |
A SQL-based rule used to identify data records that violate an expected condition. |
| Data source schema |
A schema whose tables are created and managed by a specific data pipeline. |
| Logical view |
A SQL query which provides the instructions for creating a virtual table, where the table is not stored in the database. |
| Materialized view |
A SQL view that is stored in the database as a table. |
| RBAC |
Role-based access control. |
| Schema |
A mechanism for organizing database objects such as tables and views. |
| Script |
Python or R code used to transform data or perform analytics in AP. |
| SQL |
Structured Query Language, a standardized programming language that is used to manage relational databases and perform various operations on the data in them. |
| Variable |
Text-based placeholders that are proxies for secrets, such as passwords and API tokens. |