Snowflake

Access

The share name will be in the e-mail verification sent after creating the registration.
To access the share which contains the tables in the registration, please refer to https://other-docs.snowflake.com/en/collaboration/consumer-listings-access
Customers can interact with their registration as they would per file-based delivery type (eg STP, S3) via the Monitoring APIs for cloud platforms.

The following tables will be available in the cloud platform upon creating registration:

Notification Table

If seed was selected on create registration, this table will contain a baseline extract of the data requested. The “Type” column will be populated with SEED.
Update notifications are appended to the notification table at the frequency requested on creation of registration. The “Type” columns will be populated with UPDATE.
Each record is in JSON Format and contains one line per DUNS number included in the monitoring registration. For details on the JSON structure, please see the applicable data product's API Response documentation.
Once the seed data is available, the registration must be unsuppressed to receive notifications. This can be done with the Monitoring API. (See the Monitoring, Suppress or Unsuppress API page.)

Schema naming convention

S<SUBSCRIBER>_<REFERENCE>

Table naming convention

T<SUBSCRIBER>_<REFERENCE>_NOTIFICATION

Table contents

Column	Data Type	Description
Subject	VARCHAR	The D-U-N-S Number is an identification number assigned by Dun & Bradstreet that uniquely identifies the entity in accordance with the Data Universal Numbering System (DUNS).
Date	VARCHAR	The date and time, in ISO 8601 UTC Z standards, when this element was updated by the application.
Path	VARCHAR	JSON Path of the element
Curr	VARCHAR	Current value is stored as VARCHAR. Please refer data dictionary using JSON Path of the element to get correct data type and transform if needed.
Prev	VARCHAR	Previous value is stored as VARCHAR. Please refer data dictionary using JSON Path of the element to get correct data type and transform if needed.
Type	VARCHAR	The type of notification eg UPDATE.

Exception Table

This table is populated with status changes for D-U-N-S Numbers. For details on status types, see D-U-N-S Number Status Types.

Table naming convention

T<SUBSCRIBER>_<REFERENCE>_EXCEPTION

Table contents

Column	Data Type	Description
Transaction ID	VARCHAR	A value assigned by the Dun & Bradstreet application to uniquely identify this request.
Date	VARCHAR	The date and time, in ISO 8601 UTC Z standards, when this element was updated by the application.
Subject	VARCHAR	The D-U-N-S Number is an identification number assigned by Dun & Bradstreet that uniquely identifies the entity in accordance with the Data Universal Numbering System (DUNS).
Code	VARCHAR	A value assigned by Dun & Bradstreet that uniquely identifies the reason for this exception. One of the following: 10001: The D-U-N-S Number not found 10003: The D-U-N-S Number is not valid. Must be 9-characters containing only digits 0-9. 10004: The D-U-N-S Number is not available for the requested product. 10200: The D-U-N-S Number cannot be returned for the requested product. 21012: The D-U-N-S Number already exists in the Registration. 40001: The D-U-N-S Number is UNDER_REVIEW these D-U-N-S Numbers are part of the Registration; however, the D-U-N-S Number will not be included in the seed file. If the D-U-N-S Number status changes to REVIEWED, a SEED record will be included in the next notification delivery. 40002: The requested D-U-N-S Number has been deleted. 40003: The requested D-U-N-S Number has been transferred; please see D-U-N-S Number transfer details. 40105: The requested D-U-N-S Number does not contain sufficient data.
Information	VARCHAR	If Code = 40003 (D-U-N-S Number was transferred), this field will contain the D-U-N-S Number to which it was transferred. Please note that transferred TO D-U-N-S Number is not part of the Registration; to add it, use the Add DUNS to Registration API. (See the Monitoring, Add DUNS to existing Registrations API page.)

DUNS Table

This table will be empty on creating the registration.
It is populated with all the subject IDs that are currently part of the registration, once the user calls Export List of Subjects from a Registration API.

Table naming convention

T<SUBSCRIBER>_<REFERENCE>_DUNS

Table contents

Column	Data Type	Description
Transaction ID	VARCHAR	A value assigned by the Dun & Bradstreet application to uniquely identify this request.
Subject	VARCHAR	The D-U-N-S Number is an identification number assigned by Dun & Bradstreet that uniquely identifies the entity in accordance with the Data Universal Numbering System (DUNS).
timestamp	Timestamp_NTZ	The date and time, in ISO 8601 UTC Z standards, when this element was updated by the application.