ETL Bitrix24 data to Snowflake

Represents individual people stored in the Bitrix24 CRM. Contains personal and business attributes such as name, phone numbers, email addresses, assigned user, source, and custom fields used for segmentation and relationship management.

Represents organizations and business accounts in the CRM. Includes company profile data such as name, industry, revenue, contact details, assigned owner, and linked CRM entities like contacts, deals, and activities.

Represents unqualified sales prospects captured from forms, calls, ads, or manual entry. Stores source information, contact details, status, responsible user, and qualification data before conversion into contacts, companies, or deals.

Represents sales opportunities moving through the pipeline. Contains commercial data such as stage, amount, currency, probability, expected close date, assigned user, and links to related contacts, companies, and activities.

Represents interactions and tasks associated with CRM records, such as calls, emails, meetings, and follow-ups. Includes activity type, subject, status, deadlines, responsible user, and references to related leads, contacts, companies, or deals.

Represents Bitrix24 portal users, including employees and system participants. Contains profile and organizational data such as name, email, department, active status, position, and identifiers used for ownership and attribution across CRM records.

Represents work items managed in the Bitrix24 task module. Includes task title, description, status, priority, deadlines, creator, assignees, and collaboration metadata useful for operational and productivity reporting.

Represents billing documents and payment-related CRM records. Contains invoice amounts, currency, status, product rows, client references, and dates needed for revenue tracking, financial reconciliation, and sales performance analysis.