The purpose of this Data Catalog is to help you understand and make use of the data that is available in our Snowflake Data Warehouse for reporting and analysis. Snowflake contains Data Sources extracted from Tech Stack Applications, then transformed and integrated into the Trusted Data Model for simple and easy reporting and analysis. Trusted Data Models are expressed using standard dimensional modeling. Reporting and analysis is performed using either SQL run versus Snowflake (UI or Command Line), or using the Sisense BI Tool that connects to Snowflake.
We follow an ELT approach, not an ETL approach because the ELT approach gives us more flexibility in storing historical data and transforming it all within Snowflake. Data is stored in different schemas and databases in Snowflake as it progresses through Loading and Transformation Stages. For Data Access and Security reasons, only data surfaced in the PROD database is accessible to Sisense. Learn more about our Snowflake Data Storage process design in the Data Storage guide
Extraction and Loading: We use a variety of tools to extract data from Tech Stack applications and follow the Extraction Solution decision tree to ultimately decide which is the best tool to use for a given data source. The Pipelines guide contains more information about our Extraction processes.
Transformation: dbt is used for all in transformations. See our dbt guide for more details on why and how we use this tool. All dbt code is stored in our Analytics Project.
Sisense is our enterprise standard BI tool. See how Sisense is being used with the Sisense Usage Overview dashboard.
Under Construction📊 indicates that the solution is operational and is embedded in the handbook.
🚧 indicates that the solution is in a Work In Progress and is actively being developed. When using this indicator, an issue should also be linked from this page.
🐔 indicates that the solution is unlikely to be operationalized in the near term.