| AP |
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 for users to make data available to downstream/destination systems. |
| 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. |
| Schema |
A schema provides a mechanism to organize objects such as tables and views. |
| 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 as passwords and API tokens. |