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.

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