Filtre a lista de recursos para saber mais.
Siga esta página para receber atualizações por e-mail quando novas notas da versão forem publicadas
[
Versão do Illuminate de setembro de 2024
Entrega contínua | Versão para produção em 5 de setembro de 2024
Desenvolvedor, segurança
Restrição do endereço IP habilitada para as contas de serviço do Snowflake
Cobertura: Módulo de relatórios incluído e aprimorado do Illuminate
Usuários afetados: Usuários com função de desenvolvedor no Illuminate e BBDATA_USER_ROLE no Snowflake
Tópicos relacionados: Restrição de endereço IP para as contas de serviço do Snowflake
Estamos comprometidos com a segurança de dados para todos os nossos clientes. Agora, as instituições podem conceder e restringir o acesso às contas de serviço do Snowflake para endereços IP específicos. O objetivo é reduzir o risco do acesso não autorizado aos dados confidenciais.
Com um endereço IP restrito, os usuários não poderão acessar uma conta de serviço do Snowflake nem alterar a senha de uma conta do Snowflake.
Contas de serviço são aquelas que fazem login no Snowflake com um nome de usuário e senha.
Imagem 1. Conta de serviço na página de login do Snowflake.
Você pode permitir e restringir um endereço IP específico ou um intervalo de endereços IP
A consulta do exemplo permite um endereço IP específico (1.1.1.1) e restringe um intervalo (de 192.168.1.0 a 192.168.1.255) para uma conta de serviço chamada SVC_BLACKBOARD_DATA.
USE ROLE BBDATA_USER_ROLE;
ALTER NETWORK POLICY NP_SVC_BLACKBOARD_DATA set ALLOWED_IP_LIST = ('1.1.1.1');
ALTER NETWORK POLICY NP_SVC_BLACKBOARD_DATA set BLOCKED_IP_LIST = ('192.168.1.0/24');
Imagem 2: consulta no Snowflake para permitir um endereço IP específico e restringir um intervalo de endereços IP.
Você pode encontrar mais exemplos da restrição do endereço IP na respectiva página de ajuda.
Illuminate Developer Canonical Data Model changes
Continuous Delivery | Release to Production 24 July 2024
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2024-06-21 | Added | CDM_CRM | Anthology Reach | A new canonical sub-model for CRM data, to be populated with data from Anthology Reach CRM in a later release. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 24 July 2024
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2024-06-21 | Added | CDM_CRM | Anthology Reach | A new canonical sub-model for CRM data, to be populated with data from Anthology Reach CRM in a later release. |
Illuminate Developer Canonical Data Model changes
Continuous Delivery | Release to Production 30 April 2024
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2024-04-17 | Added | CDM_LMS-COURSE_ITEM-AI_STATUS | LEARN. AI_STATE | A new column in the CDM_LMS-COURSE_ITEM table with an indicator that defines the AI Design Assistant use. The PERSON_ID field needs to be populated with the ID of the user who accepted the AI-generated content |
Illuminate Developer Canonical Data Model changes
Continuous Delivery | Release to Production 26 March 2024
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2024-02-27 | Changed | CDM_LMS.GRADE | LEARN.GRADE | The logic was updated, ensuring that all calculated grades are now available in the Canonical Data Model. |
Illuminate Developer Canonical Data Model changes
Continuous Delivery | Release to Production 24 January 2024
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2024-01-19 | Added | CDM_LMS-PERSON-JOB_TITLE | LEARN.USERS.JOB_TITLE | A new column in the CDM_LMS_PERSON table with the job of the person was added. |
| 2024-01-19 | Added | CDM_LMS-PERSON-DEPARTMENT | LEARN.USERS.DEPARTMENT | A new column in the CDM_LMS_PERSON table with the department the person is part of was added. |
| 2024-01-19 | Added | CDM_LMS-PERSON-COMPANY | LEARN.USERS.COMPANY | A new column in the CDM_LMS_PERSON table with the company the person is part of was added. |
| 2023-12-21 | Added | DATA_SRC_BATCHUID | DATA_SOURCE | A new element to the stage attribute of the PERSON and COURSE tables was added to include the BATCH_UID from the DATA_SOURCE table. |
Illuminate Developer Canonical Data Model changes
Continuous Delivery | Release to Production 15 November 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
|
2023-10-25 |
Added | CDM_LMS.ATTEMPT |
LEARN.ATTEMPT |
A new table that displays information about attempts on course items, such as assignments, blogs, or wikis. |
|
2023-10-25 |
Changed |
LEARN.ATTEMPT |
Updated with calculations from LEARN.ATTEMPT table. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 6 June 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
|
2023-06-07 |
Added | CDM_SIS |
Anthology Student |
A new canonical sub-model for SIS data, to be populated with data from Anthology Student SIS. |
|
2023-06-07 |
Changed |
Anthology Student, |
Additional tables and columns in the CDM_MAP schema to map people and course sections between Learn and Anthology Student. |
|
|
2023-06-07 |
Added |
LEARN.COURSE_CONTENTS_REVIEWED |
A new table that displays students’ progress against course content items where progress tracking is enabled in Ultra courses. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 24 May 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
|
2023-05-17 |
Changed | COURSE START DATE |
LEARN.COURSE_MAIN.START_DATE |
Modify the DYNAMIC_DATE calculated field to reflect the real course start date when filtering by Course Start Date. The Course Start Date column was added to the datasets where it was missing. |
|
2023-03-08 |
Changed |
|
|
Add the following logic to the filtering views and tables:
|
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 08 March 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
|
2023-03-08 |
Added | Institution Hierarchy Permission CDM_LMS. INSTITUTION_HIERARCHY_PERMISSION |
LEARN.DOMAIN_ADMIN |
A new table that maps users in the PERSON table to Institution Hierarchy nodes based on a “node admin” relationship. This will be used in Reporting for future “Role Based Access” functionality. |
|
2023-03-08 |
Changed |
Stage |
LEARN. LEARN.BLTI_DOMAIN_CONFIG.NAME |
Adding an attribute to the STAGE column to indicate the specific LTI tool used for a Basic LTI Link item, where this tool is identified in the BLTI_DOMAIN_CONFIG table. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 31 January 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
|
2023-01-31 |
Added | Copy From Courses CDM_LMS.COURSE.COPY_FROM_COURSES |
LEARN.COURSE_MAIN.COPY_FROM_UUIDS |
Identifies from which course(s) content has been copied into the course. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 17 January 2023
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2023-01-17 | Added | Parent Course Item Id CDM_LMS.COURSE_ITEM.PARENT_COURSE_ITEM_ID |
LEARN.COURSE_CONTENTS.PARENT_PK1 |
Foreign key that references itself in this table to identify the parent item that the current item sits within. |
| 2023-01-17 | Added | Content Position CDM_LMS.COURSE_ITEM.CONTENT_POSITIO |
LEARN.COURSE_CONTENTS.POSITION |
The position of a content item on the page or within its parent item, with 0 being the highest. |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 01 December 2022
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2022-12-01 | Added | Grades Released Ind CDM_ LMS. GRADEBOOK. VISIBLE_ IND |
LEARN. GRADEBOOK_ MAIN. GRADES_ RELEASED |
Indicates if a grade was released from a LTI item to the gradebook. If TRUE then grades are available, but VISIBLE_IND defines whether the grades are visible to students. |
| 2022-12-01 | Changed | Visible Ind CDM_ LMS. GRADEBOOK. VISIBLE_ IND |
LEARN. GRADEBOOK_ MAIN. VISIBLE_ IND LEARN. GRADEBOOK_ MAIN. VISIBLE_ IN_ BOOK_ IND |
This indicator will now consider the VISIBLE_IN_BOOK_IND column to truly represent the visibility of grades to students. Indicates whether the gradable item is released and visible or not for students and instructors in the Gradebook. If the value is FALSE, the column is hidden from students and may also be hidden from instructors. (Original Course View only) |
Blackboard Data Developer Canonical Data Model changes
Continuous Delivery | Release to Production 14 September 2022
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2022-09-14 | Added | Primary Instructor Ind CDM_LMS.PERSON_COURSE.PRIMARY_INSTRUCTOR_IND |
LEARN.COURSE_USERS.DISPLAY_ORDER |
If TRUE then this user is the main instructor for the course. If FALSE then this user is not the primary instructor for the course. |
Blackboard Data Developer July 2022 Canonical Data Model changes
Continuous Delivery | Release to Production 27 July 2022
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2022-07-27 | Added | End Time CDM_LMS.COURSE.END_TIME |
LEARN.COURSE_MAIN.END_DATE |
The date and time a course stops being available for students in the LMS. |
| 2022-07-27 | Added | End Time CDM_LMS.TERM.END_TIME |
LEARN.TERM.END_DATE |
The date and time a term ends in the LMS. |
| 2022-07-27 | Added | Start Time CDM_LMS.COURSE.START_TIME |
LEARN.COURSE_MAIN.START_DATE |
The date and time a course starts to be available for students in the LMS. |
| 2022-07-27 | Added | Start Time CDM_LMS.TERM.START_TIME |
LEARN.TERM.START_DATE |
The date and time a term begins in the LMS. |
Blackboard Data Developer May 2022 Canonical Data Model changes
Continuous Delivery | Release to Production 31 May 2022
Developer, CDM Changes, Data Dictionary
| Date (YYYY-MM-DD) | Status | Entry | Source | Description |
|---|---|---|---|---|
| 2022-05-31 | Added | Due Date Exception CDM_LMS.PERSON_COURSE.DUE_DATE_EXCEPTION |
LEARN.COURSE_USERS.DUE_DATE_EXCEPTION |
Blackboard Learn Ultra user due date exception. Null: no due date exception, <=0: unlimited due date exception, >0: limited due date exception with a specified duration in seconds. |
| 2022-05-31 | Added | Enrollment Time CDM_LMS.PERSON_COURSE.ENROLLMENT_TIME |
LEARN.COURSE_USERS.ENROLLMENT_DATE |
Date and time of course enrollment. |
| 2022-05-31 | Added | Time Limit Exception CDM_LMS.PERSON_COURSE.TIME_LIMIT_EXCEPTION |
LEARN.COURSE_USERS.TIME_LIMIT_EXCEPTION |
Blackboard Learn Ultra user time limit exception. NULL: no set time limit exception, 0: time limit exception set to unlimited time limit, 150: time limit exception set to 1.5 times time limit, 200: time limit exception set to 2 times time limit. |
Blackboard Data March 2022 Release
Continuous Delivery | Release to Production 15 March 2022
Blackboard Data, Reporting, Developer, Updated Features, New Features
- The Blackboard Data user interface found at data.blackboard.com has been updated to provide a better experience for first-time users, including introductory information about Blackboard Data and an explanation of the new reports now available.
- A new Blackboard Data Developer area contains the existing Settings page for management of the Service account, as well as a convenient link to your Snowflake instance.
