Blackboard's Data Dictionary presents table and column definitions in an easy to read format. Use this resource to create reports. Learn about the source, usage, and relationships of the entities available.

Here are a few things you should know about Blackboard's Data Dictionary:

  • Entries document tables and columns.
  • Submodels group related entries.
  • Blackboard Data uses the Snowflake data warehouse.

Visit the Snowflake documentation website for tutorials and help with all supported SQL commands, functions, and operators.

Entry

Entries document tables and columns. Select an entry to see the definition, technical specifications, and entity relationships for the entry.

  • Verified checkmark icon
    : See at a glance if an entry is mapped and validated as recommended.
  • Entry Definition: Describes the table or column in an easy to read format
  • Source System: Identifies where the information is coming from. For example, Blackboard Learn.
  • Source Objects: Identifies the schema, table, and column the information is coming from.
  • Context: Identifies where entries apply. For example, in a course or a user session.
  • Column Is Nullable: Tells you if the column data can be Null.
  • Column Is Identity: Tells you if the column is an identity column.
  • Column Data Type: The type of data in the column.

    More on Snowflake's supported data types

  • Entity Relationships: The Entity Relationship Diagrams (ERD) show you the relationship and flow of data in the database. Blackboard Data's ERD uses crow's foot notation to show you the relationships.

 

You can use the language selector to choose your preferred language. There are terms that are not currently localized and will remain in English after you’ve selected another language. The localized version of these terms will be delivered in a progressive manner throughout 2021 and 2022. 

Entity Relationship Diagram

Entity Relationship Diagrams (ERD) show you the relationship and flow of data.

The ERD is interactive.

  • Select a table or column to highlight the relationships.
  • Select the link
    beside a table or column name to see that entry definition.
  • Select Full screen
    , if you want a bigger view.
  • Move your pointer over the information icon
    to see a legend of ERD icons.
  • Use the Search tool to find a table in the ERD.
  • Use two fingers or your scroll wheel to zoom the ERD in or out.
  • Press Ctrl and select the ERD to move it. On a Mac press Command and select the ERD.

The ERD uses crow's foot notation to show relationships.

Crow’s Foot Notation quick reference cheat sheet

Localization

You can use the language selector to choose your preferred language. Nevertheless, there are terms that aren't currently localized and will remain in English after you’ve selected another language. The localized version of these terms will be delivered in a progressive manner throughout 2021 and 2022, except for the Data Dictionary terms related to these fields, which will remain in English:  

  • Entry description

  • Column is Nullable 

  • Column is Identity  

  • Column Data Type 

 

Data dictionary Entry with unlocalized terms highlighted with a purple rectangle