External Partner Program Table

Databricks Table Name: external_partner_programs

Column NameData TypeDescriptionLinked Table
auto_update_timebigintIndicates the date and time when the record in the source program table was last updated. It is in the Unix timestamp format.time
descriptionstringDefines the description of the partner program.partner_programs
partner_program_namestringIndicates the designated name of the partner program.partner_programs
is_tier_basedbooleanIndicates whether the partner program is tier-based program.partner_programs
points_exchange_ratiodecimalIndicates the conversion ratio used for exchanging points between the main loyalty program and the partner program.partner_programs
external_partner_program_idstringA unique identifier for the partner program, typically provided by the external brand or partner.partner_programs
partner_program_typestringIndicates the classification or type of the partner program.partner_programs
loyalty_program_idintegerThe unique identifier for the primary loyalty program to which the partner program is linked.program
partner_program_identifierstringA unique identifier for the partner program, typically assigned by the brand.partner_programs
is_activebooleanIndicates whether the partner program is currently active.partner_programs