1. Granularity

The d_client_instances dbt table has information about a client on an instance level. This means that there is 1 row for 1 instance.

You will be able to find the following data for each client:

• instance_id
• instance_name
• instance_description
• instance_status
• dal_link
• instance_created_datetime
• instance_updated_datetime
• is_recurring
• recurring_parent_instance_id
• client_name → (company name)
• client_id
• is_client_external
• is_client_offboarded
• is_client_deleted
• client_user_id → instances.clientid
• client_user → contact name associated with "clientid" on an instance
• client_subscription_start_cohort_month