Nsadmin Messages Fact Table

This fact table captures all communications sent to customers. It lets you access both, transaction and campaign messages together.

Databricks Table Name: nsadmin_messages

Nsadmin Messages - Entity Relationship Diagram (ERD)

Zoom in the table for more clarity. Click the table title to view its details.

Nsadmin Messagesauto_update_time_nsadmin: bigintclient_context_id: bigintclient_id: bigintdim_account_id: bigintdim_campaign_id: bigintdim_communication_channel_id: bigintdim_communication_client_id: bigintdim_delivery_status_id: bigintdim_event_date_id: bigintdim_event_time_id: bigintdim_event_user_id: bigintdim_latest_updated_date_id: bigintdim_latest_updated_time_id: bigintdim_nsadmin_priority_id: bigintmessage: stringmessage_count: bigintPKnsadmin_id: bigintyear: intGatewayshort_name: stringauto_update_gateways: bigintLKid: bigintfull_name: stringhost_name: stringNsadmin PriorityLKid: intpriority: stringCommunication ClientLKid: intname: stringdescription: stringNsadmin MessagesGatewayNsadmin PriorityCommunication ClientCommunication ChannelLKid: integerchannel: stringactivity_name: stringCommunication ChanneldateLKdate_id: intday_of_month: intweek_of_year: int