Skip to main content

Data & Intelligence

Iterative BI Tips – The Project Directory

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

My project teams designate a project root via environment variable and then build a defined directory structure beneath.  This allows each developer to build their environments wherever it suits their needs and desires while providing a consistent path for project paths:

 

C:\
Users
chris.grenz
projects <- The projects root defined in PROJECTS_ROOT
BI
TEST_123 <- An individual environment named TEST_123
build <- All things build related. For us, build.gradle scripts.
db
MDR
data <- Static data to be loaded when the database is built.
ddl <- DDL scripts to create the structure of the database.
sp <- Procedural SQL for stored procs and UDFs.
EDW
ODS
etl <- ETL packages, scripts, and resources.
test <- All things testing. This is NOT included in the production build.
wiki <- When we use DBFit, this is the root of the wiki.
tools <- The binaries (and source) of the utilities the environment depends on (excluding large shared tools like SQL Server).
gradle
dbfit

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Chris Grenz

More from this Author

Follow Us