To work with this repository, run the following command in your terminal to clone: git clone https://github.com/lth-devs-mpz/lth-dms-data-model.git

📘 LTH DMS Data Model

• A structured, source-controlled SQL Server data model for the LTH Daily Management System (DMS).
• This repository contains the full schema, database project with supporting documentation.

🌐 Overview

This project provides:

• A SQL Server Database Project representing the DMS schema
• Automatically generated schema objects (Tables, Views, Functions, Stored Procedures).
• This repo is intended for developers, analysts, DBAs, and integration teams working with the LTH DMS platform.

📂 Repository Structure

DatabaseModels

• DataHub/1- SnowFlake to Local DataHub Server - Objects pulled from DataHub snowflake instance downstream to a local SQL Instance - datatypes defined to allow quicker data transfer from Snowflake to SQL database.
• DataHub/2- Local DataHub to BI SQL for DMS - local database and views developed from snowflake data.

✔️ Prerequisites & Access Requirements

Before working with the LTH DMS Data Model, ensure you have the following:

🔐 Snowflake Access

Access is managed through the Rostering Team and Allocate/DataHub.

• An active Snowflake account with the correct role permissions to query and manage DMS-related DataHub objects.
• Snowflake ODBC Driver installed for SQL connectivity.

Note: Download: Snowflake ODBC Driver documentation https://docs.snowflake.com/en/developer-guide/odbc/odbc-download

Note: Before proceeding, ensure your SQL Server instance is configured with valid Snowflake credentials.

Objects in SnowFlake:

1. DATA_SHARE_DB/OPTIMA_ADVANCED – Advanced views
2. DATA_SHARE_DB/OPTIMA_MANAGED – Managed views

🛠 Tools & Skills Needed

Skills

• Knowledge of Transact-SQL (T-SQL)

Tools

• SQL Server Management Studio (SSMS) for deployment and management.

DATA_SHARE_DB Setup Script

This SQL script creates and configures the DATA_SHARE_DB database in Microsoft SQL Server. Replicating the SnowFlake instance setup.

Features

• Creates the DATA_SHARE_DB database with specified file paths and sizes.
• Enables Full-Text Search (if installed).
• Configures essential database options for performance and reliability.
• Enables and configures Query Store for query performance tracking.

How to Use

1. Open SQL Server Management Studio (SSMS).
2. Connect to your SQL Server instance.
3. Run the script: DatabaseModels/DataHub/create_data_share_db.sql;

Feedback or Questions (Only for DataHub Set Up and Technical Questions relating to contents of this repo)

📄 License

• This project is licensed under the MIT License. See the LICENSE file for details.