SQL code to list DM objects

This is useful if you want some docs on your objects. .

-- list_dm_elements.sql
-- works with SQL Server repository

SELECT [component_type]
     
,CASE
   WHEN component_type = 'J' THEN 'Jobstream'
   WHEN component_type = 'B' THEN 'Fact Build'
   WHEN component_type = 'S' THEN 'Dim Build'
   WHEN component_type = 'D' THEN 'Dimension'
   WHEN component_type = 'H' THEN 'Dim Hierarchy'
   WHEN component_type = 'L' THEN 'Dim Lookup'
   WHEN component_type = 'T' THEN 'Template'
   WHEN component_type = 'A' THEN 'Data Source'
   WHEN component_type = 'F' THEN 'Function'
   WHEN component_type = 'K' THEN 'Metadata Dim'
   WHEN component_type = 'J' THEN 'Metatdata Collection'
   WHEN component_type = 'N' THEN 'Name of Environment'
   WHEN component_type = 'P' THEN 'Preferences'
   WHEN component_type = 'R' THEN 'Folder'
   ELSE '???????????'
END AS component_description
,[component_name]
FROM [dmcatalog].[dmcuser].[dsb_component]
ORDER BY component_type, component_name

DM uses a database as a repository. It seems to be a quite simple representation in Sequel of what might have been source code at some point.

dsb_component_line will contain the source code of each object which you can also view in datamanager.