Athena Naming Conventions

Databases

All the databases should be the same name as the source system, all the names should be in lowercase and separated by underscore.

Tables

All the tables should be the same name as the source module and be under the database which corresponds to your system, all the names should be in lowercase and separated by underscore.

Tables that tagged with a "_s" contains sensitive information hided.

Views

All the views should follow the template below:

Red = all views should contain the prefix "vw"; Orange = indicates the the periodicity of the table (d = daily, w = weekly, m = monthly, y = yearly); Purple = indicates the owner of this view, the owner should be identified by his initials (limited to 2 letters); Green = subject of the view, and should indicate with kind of data we can find in this view.