-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:08.612575+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."DEAL_PIPELINE"

version: 2
models:
- name: stg_DEAL_PIPELINE
  description: DEAL_PIPELINE tracks sales processes. TICKET_PIPELINE likely manages
    customer support workflows. Both partitions store pipeline information. They include
    IDs, labels, and timestamps. The partitions represent different aspects of customer
    interaction.
  columns:
  - name: PIPELINE_ID
    description: Unique identifier for the pipeline
    tests:
    - not_null
  - name: LABEL
    description: Name or description of the pipeline
    tests:
    - not_null
  - name: DISPLAY_ORDER
    description: Numeric order for displaying pipelines
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp when the pipeline was created
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp of the last update to the pipeline
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record was deleted
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of the last data synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:38:50.034572+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."ASSOCIATION_TYPE"

version: 2
models:
- name: stg_ASSOCIATION_TYPE
  description: The table is about association types in a CRM system. It defines relationships
    between different object types like quotes, deals, tasks, companies, etc. Each
    row represents a specific association type with a unique ID, name, and the object
    types it connects. The table includes system-defined (HUBSPOT_DEFINED) associations.
    It also tracks deletion status and synchronization timestamps for each association
    type.
  columns:
  - name: CATEGORY
    description: Indicates the origin or type of the association
    tests:
    - not_null
  - name: ID
    description: Unique identifier for the association type
    tests:
    - not_null
  - name: NAME
    description: Descriptive name of the association type
    tests:
    - not_null
  - name: LABEL
    description: Additional label for the association (currently empty)
    cocoon_meta:
      missing_reason: Optional descriptive label for relationship, can be left blank.
  - name: FROM_OBJECT_TYPE
    description: The source object type in the association
    tests:
    - not_null
  - name: TO_OBJECT_TYPE
    description: The target object type in the association
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Indicates if the record has been deleted
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of the last synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:10.584461+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."ENGAGEMENT"

version: 2
models:
- name: stg_ENGAGEMENT
  description: The table is about engagement activities. It contains details of different
    types of engagements, such as tasks. Each engagement has a unique ID and is associated
    with a specific portal. The table also includes a timestamp for when the record
    was last synced in the database system.
  columns:
  - name: ID
    description: Unique identifier for the engagement activity
    tests:
    - not_null
  - name: TYPE
    description: Category of the engagement activity
    tests:
    - not_null
  - name: PORTAL_ID
    description: Identifier of the associated portal
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last database synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:15.913592+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."TICKET_PIPELINE"

version: 2
models:
- name: stg_TICKET_PIPELINE
  description: DEAL_PIPELINE tracks sales processes. TICKET_PIPELINE likely manages
    customer support workflows. Both partitions store pipeline information. They include
    IDs, labels, and timestamps. The partitions represent different aspects of customer
    interaction.
  columns:
  - name: PIPELINE_ID
    description: Unique identifier for the pipeline
    tests:
    - not_null
  - name: LABEL
    description: Name or description of the pipeline
    tests:
    - not_null
  - name: DISPLAY_ORDER
    description: Numeric order for displaying pipelines
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp when the pipeline was created
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp of the last update to the pipeline
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record was deleted
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of the last data synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:38:58.153640+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."COMPANY"

version: 2
models:
- name: stg_COMPANY
  description: The table is about companies with online stores. It contains detailed
    information about each company, including their Shopify store URL, product details,
    estimated sales, web technologies used, social media accounts, and various other
    business metrics. The data appears to be collected for lead generation or market
    analysis purposes, with fields like "PROPERTY_LIFECYCLESTAGE" and "PROPERTY_HS_TARGET_ACCOUNT_PROBABILITY"
    suggesting it's used in a CRM or sales pipeline system.
  columns:
  - name: ID
    description: Unique identifier for each company record
    tests:
    - not_null
  - name: PORTAL_ID
    description: Identifier for the portal or system
    tests:
    - not_null
  - name: IS_DELETED
    description: Indicates if the record is deleted
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Fivetran-specific deletion flag
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last Fivetran sync
    tests:
    - not_null
  - name: PROPERTY_SL_MOST_RECENTLY_PUBLISHED_PRODUCT_IMAGE_URL
    description: URL of the most recent product image
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PIC_90
    description: Unknown metric, possibly related to percentile
    tests:
    - not_null
  - name: PROPERTY_SL_ESTIMATED_PAGEVIEWS
    description: Estimated number of pageviews
    tests:
    - not_null
  - name: PROPERTY_SL_EMPLOYEES
    description: Number of employees
    tests:
    - not_null
  - name: PROPERTY_SL_MERCHANT_NAME
    description: Name of the merchant or company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_DOMAIN
    description: Domain of the company's website
    tests:
    - not_null
  - name: PROPERTY_NUM_ASSOCIATED_CONTACTS
    description: Number of associated contacts
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_CONTACTS_WITH_BUYING_ROLES
    description: Number of contacts with buying roles
    tests:
    - not_null
  - name: PROPERTY_HS_TIME_IN_LEAD
    description: Time spent as a lead
    tests:
    - not_null
  - name: PROPERTY_NAME
    description: Name of the company
    tests:
    - not_null
  - name: PROPERTY_SL_MONTHLY_APP_SPEND
    description: Monthly spending on apps
    tests:
    - not_null
  - name: PROPERTY_HS_LASTMODIFIEDDATE
    description: Date of last modification
    tests:
    - not_null
  - name: PROPERTY_SL_PRODUCT_COUNT
    description: Number of products
    tests:
    - not_null
  - name: PROPERTY_SL_PLATFORM_DOMAIN
    description: Domain of the e-commerce platform
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_PIPELINE
    description: Sales pipeline stage
    tests:
    - not_null
  - name: PROPERTY_SL_PLATFORM_RANK_PERCENTILE
    description: Percentile rank on the platform
    tests:
    - not_null
  - name: PROPERTY_SL_MOST_RECENTLY_PUBLISHED_PRODUCT_NAME
    description: Name of most recently published product
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PLATFORM
    description: E-commerce platform used
    tests:
    - not_null
  - name: PROPERTY_SL_PHONE_COUNTRY_CODES
    description: Country codes of phone numbers
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_OBJECT_SOURCE
    description: Source of the company data
    tests:
    - not_null
  - name: PROPERTY_SL_MIN_PRODUCT_GRAMS
    description: Minimum product weight in grams
    tests:
    - not_null
  - name: PROPERTY_SL_PC_90
    description: Unknown metric, possibly related to percentile
    tests:
    - not_null
  - name: PROPERTY_SL_RANK
    description: Rank of the company
    tests:
    - not_null
  - name: PROPERTY_SL_TECHNOLOGIES
    description: Technologies used by the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_NUM_DECISION_MAKERS
    description: Number of decision makers
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_OPEN_DEALS
    description: Number of open deals for the company
    tests:
    - not_null
  - name: PROPERTY_SL_SHOPIFY_APPS
    description: List of Shopify apps used by the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_NUM_CHILD_COMPANIES
    description: Number of child companies
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_BLOCKERS
    description: Number of blockers or obstacles
    tests:
    - not_null
  - name: PROPERTY_WEBSITE
    description: Main website URL of the company
    tests:
    - not_null
  - name: PROPERTY_SL_ALIASES
    description: Alternate domain names for the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_THEME_VENDOR
    description: Vendor of the Shopify theme used
    tests:
    - not_null
  - name: PROPERTY_SL_DESCRIPTION
    description: Brief description of the company or store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_AVERAGE_PRODUCT_PRICE
    description: Average price of products in the store
    tests:
    - not_null
  - name: PROPERTY_SL_EMAIL_ADDRESSES
    description: Email addresses associated with the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PIC_365
    description: Unknown metric, possibly related to sales
    tests:
    - not_null
  - name: PROPERTY_SL_MAX_PRODUCT_GRAMS
    description: Maximum weight of products in grams
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_LABEL
    description: Source of the company data
    tests:
    - not_null
  - name: PROPERTY_HS_TARGET_ACCOUNT_PROBABILITY
    description: Probability score for target account
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_EMAIL_ADDRESS_FIRST
    description: Primary email address for the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_MOST_RECENTLY_PUBLISHED_PRODUCT_URL
    description: URL of the most recently published product
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_USER_IDS_OF_ALL_OWNERS
    description: User IDs of all account owners
    tests:
    - not_null
  - name: PROPERTY_SL_MOST_RECENTLY_PUBLISHED_PRODUCT_PUBLISHED_AT
    description: Timestamp of most recently published product
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_STATE
    description: State where the company is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PIC_30
    description: Unknown metric, possibly related to sales
    tests:
    - not_null
  - name: PROPERTY_SL_CATEGORIES
    description: Categories of products sold in the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_STATUS
    description: Current status of the store
    tests:
    - not_null
  - name: PROPERTY_SL_ALTERNATES
    description: Alternative URLs for the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_VARIANT_COUNT
    description: Number of product variants in the store
    tests:
    - not_null
  - name: PROPERTY_SL_CREATED_AT
    description: Date when the store was created
    tests:
    - not_null
  - name: PROPERTY_SL_PLATFORM_RANK
    description: Ranking of the store on the platform
    tests:
    - not_null
  - name: PROPERTY_SL_PC_30
    description: Unknown metric, possibly related to sales
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_ENTERED_LEAD
    description: Date when the company became a lead
    tests:
    - not_null
  - name: PROPERTY_SL_MAGENTO_APPS_NUMBER
    description: Number of Magento apps used
    tests:
    - not_null
  - name: PROPERTY_SL_COUNTRY
    description: Country where the company is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_FEATURES
    description: Store features like checkout, returns, contact page
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_SUBREGION
    description: Geographical subregion of the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_LANGUAGE
    description: Primary language of the store
    tests:
    - not_null
  - name: PROPERTY_SL_PHONE_NUMBERS
    description: Phone numbers associated with the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_DOMAIN
    description: Website domain of the store
    tests:
    - not_null
  - name: PROPERTY_SL_RANK_PERCENTILE
    description: Store's rank percentile
    tests:
    - not_null
  - name: PROPERTY_SL_CITY
    description: City where the store is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_VENDOR_COUNT
    description: Number of vendors for the store
    tests:
    - not_null
  - name: PROPERTY_SL_ESTIMATED_SALES
    description: Estimated sales figure
    tests:
    - not_null
  - name: PROPERTY_SL_REGION
    description: Geographical region of the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_SHOPIFY_APPS_NUMBER
    description: Number of Shopify apps used
    tests:
    - not_null
  - name: PROPERTY_LIFECYCLESTAGE
    description: Current stage in the sales lifecycle
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ASSIGNEDDATE
    description: Date assigned to HubSpot owner
    tests:
    - not_null
  - name: PROPERTY_SL_TITLE
    description: Title or name of the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_OBJECT_SOURCE_ID
    description: HubSpot object source ID
    tests:
    - not_null
  - name: PROPERTY_CREATEDATE
    description: Date the record was created
    tests:
    - not_null
  - name: PROPERTY_SL_CURRENCY_CODE
    description: Currency code used by the store
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PC_365
    description: Unknown metric (possibly related to sales)
    tests:
    - not_null
  - name: PROPERTY_SL_SOURCE
    description: Source of the store information
    tests:
    - not_null
  - name: PROPERTY_SL_LAST_CRAWLED_AT
    description: Last date the store was crawled
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ID
    description: ID of the HubSpot owner
    tests:
    - not_null
  - name: PROPERTY_SL_THEME_NAME
    description: Name of the Shopify theme used
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_ID
    description: HubSpot object ID
    tests:
    - not_null
  - name: PROPERTY_HS_ALL_OWNER_IDS
    description: All HubSpot owner IDs associated
    tests:
    - not_null
  - name: PROPERTY_SL_ESTIMATED_VISITS
    description: Estimated number of store visits
    tests:
    - not_null
  - name: PROPERTY_SL_AVERAGE_PRODUCT_GRAMS
    description: Average product weight in grams
    tests:
    - not_null
  - name: PROPERTY_WEB_TECHNOLOGIES
    description: Web technologies used by the store
    cocoon_meta:
      missing_reason: Some websites might not use identifiable web technologies.
  - name: PROPERTY_IS_PUBLIC
    description: Whether the store is public
    cocoon_meta:
      missing_reason: Only relevant for companies that can be publicly traded
  - name: PROPERTY_DESCRIPTION
    description: Description of the store or business
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_INSTAGRAM_ACCOUNT
    description: Instagram account associated with the store
    cocoon_meta:
      missing_reason: Store doesn't have an Instagram account
  - name: PROPERTY_SL_INSTAGRAM_URL
    description: Instagram profile URL
    cocoon_meta:
      missing_reason: Store doesn't have an Instagram account
  - name: PROPERTY_SL_ZIP
    description: ZIP code of the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_COUNTRY
    description: Country where the company is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_FACEBOOK_ACCOUNT
    description: Facebook account username
    cocoon_meta:
      missing_reason: Store doesn't have a Facebook account
  - name: PROPERTY_TIMEZONE
    description: Timezone of the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_CITY
    description: City where the company is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_FACEBOOK_URL
    description: Facebook page URL
    cocoon_meta:
      missing_reason: Store doesn't have a Facebook account
  - name: PROPERTY_ADDRESS
    description: Company's physical address
    cocoon_meta:
      missing_reason: Not all businesses have physical addresses
  - name: PROPERTY_ZIP
    description: ZIP code (possibly for shipping)
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_SHIPPING_CARRIERS
    description: Shipping carriers used by the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_STATE
    description: State where the company is located
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_REDIRECTS_TO
    description: URL that the store redirects to
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_FACEBOOKGROUP_URL
    description: Facebook group URL
    cocoon_meta:
      missing_reason: Store doesn't have a Facebook group
  - name: PROPERTY_SL_FACEBOOKGROUP_ACCOUNT
    description: Facebook group account name
    cocoon_meta:
      missing_reason: Store doesn't have a Facebook group
  - name: PROPERTY_SL_YOUTUBE_FOLLOWERS_90_DP
    description: YouTube follower growth rate in 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_YOUTUBE_FOLLOWERS_90_D
    description: YouTube followers gained in 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_TWITTER_FOLLOWERS_30_D
    description: Twitter followers gained in 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_YOUTUBE_FOLLOWERS_30_D
    description: YouTube followers gained in 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_YOUTUBE_URL
    description: YouTube channel URL
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_YOUTUBE_FOLLOWERS
    description: Total number of YouTube followers
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_YOUTUBE_ACCOUNT
    description: YouTube account username
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_TWITTER_FOLLOWERS_90_DP
    description: Twitter follower growth rate in 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_TWITTER_POSTS
    description: Number of Twitter posts
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_TWITTERHANDLE
    description: Twitter handle
    cocoon_meta:
      missing_reason: Not all websites or businesses have Twitter accounts.
  - name: PROPERTY_SL_PLAN_CHANGED_AT
    description: Date when the plan was last changed
    cocoon_meta:
      missing_reason: Store doesn't have a plan or hasn't changed it
  - name: PROPERTY_LINKEDINBIO
    description: LinkedIn biography
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_TAGS
    description: Tags associated with the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_TWITTER_FOLLOWERS
    description: Total number of Twitter followers
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_PLAN
    description: Current plan or subscription tier
    cocoon_meta:
      missing_reason: Store doesn't have a specific plan
  - name: PROPERTY_SL_TWITTER_ACCOUNT
    description: Twitter account username
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_TWITTER_URL
    description: Company's Twitter profile URL
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_TWITTER_FOLLOWERS_30_DP
    description: Twitter follower growth rate in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_SL_YOUTUBE_FOLLOWERS_30_DP
    description: YouTube follower growth rate in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a YouTube account
  - name: PROPERTY_SL_TWITTER_FOLLOWERS_90_D
    description: Twitter follower count change in last 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a Twitter account
  - name: PROPERTY_INDUSTRY
    description: Industry category of the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_FACEBOOK_COMPANY_PAGE
    description: Company's Facebook page URL
    cocoon_meta:
      missing_reason: Not all businesses have Facebook pages
  - name: PROPERTY_FOUNDED_YEAR
    description: Year the company was founded
    cocoon_meta:
      missing_reason: Not applicable for informal or recent businesses
  - name: PROPERTY_SL_TIKTOK_FOLLOWERS_90_DP
    description: TikTok follower growth rate in last 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_SL_TIKTOK_FOLLOWERS_90_D
    description: TikTok follower count change in last 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_SL_TIKTOK_FOLLOWERS_30_DP
    description: TikTok follower growth rate in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_SL_TIKTOK_FOLLOWERS_30_D
    description: TikTok follower count change in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_SL_TIKTOK_FOLLOWERS
    description: Total number of TikTok followers
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_ANNUALREVENUE
    description: Company's annual revenue
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_LINKEDIN_URL
    description: Company's LinkedIn profile URL
    cocoon_meta:
      missing_reason: Store doesn't have a LinkedIn profile
  - name: PROPERTY_SL_TIKTOK_ACCOUNT
    description: Company's TikTok account name
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_LINKEDIN_COMPANY_PAGE
    description: Company's LinkedIn page URL
    cocoon_meta:
      missing_reason: Not all businesses have LinkedIn pages
  - name: PROPERTY_PHONE
    description: Company's phone number
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_TIKTOK_URL
    description: Company's TikTok profile URL
    cocoon_meta:
      missing_reason: Store doesn't have a TikTok account
  - name: PROPERTY_NUMBEROFEMPLOYEES
    description: Number of employees in the company
    cocoon_meta:
      missing_reason: May not apply to sole proprietorships or small businesses
  - name: PROPERTY_SL_IOS_APP_ID
    description: Company's iOS app ID
    cocoon_meta:
      missing_reason: Store doesn't have an iOS app
  - name: PROPERTY_SL_ANDROID_APP_ID
    description: Company's Android app ID
    cocoon_meta:
      missing_reason: Not all businesses have Android apps
  - name: PROPERTY_SL_SALES_CHANNELS
    description: Sales channels used by the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_PINTEREST_POSTS
    description: Number of Pinterest posts by the company
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_FOLLOWERS_30_D
    description: Pinterest follower count change in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_FOLLOWERS_30_DP
    description: Pinterest follower growth rate in last 30 days
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_FOLLOWERS
    description: Total number of Pinterest followers
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_URL
    description: Company's Pinterest profile URL
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_FOLLOWERS_90_DP
    description: Pinterest follower growth rate in last 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_FOLLOWERS_90_D
    description: Pinterest follower count change in last 90 days
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_SL_PINTEREST_ACCOUNT
    description: Company's Pinterest account name
    cocoon_meta:
      missing_reason: Store doesn't have a Pinterest account
  - name: PROPERTY_ADDRESS_2
    description: Secondary address of the company
    cocoon_meta:
      missing_reason: Additional address line often unnecessary
  - name: PROPERTY_TOTAL_MONEY_RAISED
    description: Total funds raised by the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_SL_SNAPCHAT_URL
    description: URL of the company's Snapchat profile
    cocoon_meta:
      missing_reason: Store doesn't have a Snapchat account
  - name: PROPERTY_SL_SNAPCHAT_ACCOUNT
    description: Snapchat username of the company
    cocoon_meta:
      missing_reason: Store doesn't have a Snapchat account
  - name: PROPERTY_SL_YELP_ACCOUNT
    description: Yelp account name of the company
    cocoon_meta:
      missing_reason: Store doesn't have a Yelp account
  - name: PROPERTY_HS_WAS_IMPORTED
    description: Indicates if the data was imported
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_ESTIMATED_MONTHLY_SALES
    description: Estimated monthly sales of the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_TWITTERFOLLOWERS
    description: Number of Twitter followers for the company
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_UPDATED_BY_USER_ID
    description: ID of the user who last updated the record
    cocoon_meta:
      missing_reason: Unknown
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:10.176432+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."EMAIL_SUBSCRIPTION"

version: 2
models:
- name: stg_EMAIL_SUBSCRIPTION
  description: The table is about email subscription categories. It contains details
    of different subscription types offered by a portal. Each subscription has an
    ID, name, description, and active status. The table also includes the portal ID
    associated with the subscriptions and a timestamp for when the record was last
    synced.
  columns:
  - name: ID
    description: Unique identifier for the subscription category
    tests:
    - not_null
  - name: PORTAL_ID
    description: Identifier for the associated portal
    tests:
    - not_null
  - name: NAME
    description: Name of the subscription category
    tests:
    - not_null
  - name: DESCRIPTION
    description: Brief explanation of the subscription category
    tests:
    - not_null
  - name: ACTIVE
    description: Indicates if the category is currently active
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of the last data synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:14.138008+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."OWNER"

version: 2
models:
- name: stg_OWNER
  description: The table is about owners or users. It contains personal details like
    name and email. Each owner has a unique ID. The table tracks when the record was
    created and last updated. It also indicates if the user is active. The ACTIVE_USER_ID
    may link to another table. The IS_ACTIVE field shows the current status of the
    owner. The _FIVETRAN_SYNCED field likely relates to data synchronization timing.
  columns:
  - name: OWNER_ID
    description: Unique identifier for the owner
    tests:
    - not_null
  - name: FIRST_NAME
    description: Owner's first name
    tests:
    - not_null
  - name: LAST_NAME
    description: Owner's last name
    tests:
    - not_null
  - name: EMAIL
    description: Owner's email address
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp when the record was created
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp when the record was last updated
    tests:
    - not_null
  - name: ACTIVE_USER_ID
    description: ID linking to active user, possibly in another table
    tests:
    - not_null
  - name: IS_ACTIVE
    description: Boolean indicating if the owner is currently active
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last data synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:38:58.800405+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."COMPANY_PROPERTY_HISTORY"

version: 2
models:
- name: stg_COMPANY_PROPERTY_HISTORY
  description: The table is about company property history. It tracks changes to various
    properties of companies over time. Each row represents a property change event.
    Details include the company ID, property name, timestamp of change, new value,
    source of the change, and Fivetran metadata. Properties cover diverse aspects
    like last modified date, product information, and crawl dates.
  columns:
  - name: COMPANY_ID
    description: Unique identifier for the company
    tests:
    - not_null
  - name: NAME
    description: Name of the company property being updated
    tests:
    - not_null
  - name: TIMESTAMP_
    description: Timestamp of when the property was updated
    tests:
    - not_null
  - name: VALUE_
    description: New value of the updated property
    cocoon_meta:
      missing_reason: Unknown
  - name: SOURCE_ID
    description: Identifier for the source of the update
    cocoon_meta:
      missing_reason: Not applicable for entries from COMPANY_INSIGHTS source.
  - name: SOURCE
    description: Name or type of the update source
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of Fivetran's last sync
    tests:
    - not_null
  - name: _FIVETRAN_START
    description: Start time of Fivetran's data processing
    tests:
    - not_null
  - name: _FIVETRAN_END
    description: End time of Fivetran's data processing
    tests:
    - not_null
  - name: _FIVETRAN_ACTIVE
    description: Indicates if the record is currently active
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:15.478190+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."PROPERTY_OPTION"

version: 2
models:
- name: stg_PROPERTY_OPTION
  description: The table is about property options. It contains details like labels,
    property IDs, values, display order, visibility, and sync timestamps. Each row
    represents a different property option, such as recipient addresses, banking,
    time zones, and tiers. The options have associated labels, unique identifiers,
    and display settings. The table likely serves as a reference for configurable
    properties in a system.
  columns:
  - name: LABEL
    description: Human-readable name for the property option
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_ID
    description: Unique identifier for the property option
    tests:
    - not_null
  - name: VALUE_
    description: Internal system value for the property option
    tests:
    - not_null
  - name: DISPLAY_ORDER
    description: Numeric order for displaying the option
    tests:
    - not_null
  - name: HIDDEN
    description: Boolean indicating if the option is hidden
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:16.454943+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."TICKET_PIPELINE_STAGE"

version: 2
models:
- name: stg_TICKET_PIPELINE_STAGE
  description: The table is about ticket pipeline stages. It contains details such
    as stage ID, pipeline ID, label, display order, and permissions. Each stage has
    a ticket state (open or closed) and a flag indicating if it's a closed stage.
    The table also includes creation and update timestamps, as well as Fivetran-specific
    fields for data synchronization.
  columns:
  - name: STAGE_ID
    description: Unique identifier for the stage
    tests:
    - not_null
  - name: PIPELINE_ID
    description: Identifier for the pipeline the stage belongs to
    tests:
    - not_null
  - name: LABEL
    description: Name or title of the stage
    tests:
    - not_null
  - name: DISPLAY_ORDER
    description: Order in which the stage appears in the pipeline
    tests:
    - not_null
  - name: WRITE_PERMISSIONS
    description: Permissions required to modify the stage
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp when the stage was created
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp when the stage was last updated
    tests:
    - not_null
  - name: IS_CLOSED
    description: Boolean indicating if the stage is closed
    tests:
    - not_null
  - name: TICKET_STATE
    description: State of tickets in this stage (OPEN/CLOSED)
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record was deleted in Fivetran
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last Fivetran synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:06.366388+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."CONTACT"

version: 2
models:
- name: stg_CONTACT
  description: The table is about contacts in a CRM system. It contains personal information
    like name and email, as well as metadata such as creation date, lifecycle stage,
    and source. The table also includes various analytics properties, tracking metrics
    like page views and conversion events. Each contact has a unique ID and is associated
    with an owner. The data appears to be from HubSpot, given the prefix "PROPERTY_HS_"
    on many fields.
  columns:
  - name: ID
    description: Unique identifier for the contact
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record was deleted in Fivetran
    tests:
    - not_null
  - name: IS_DELETED
    description: Flag indicating if the contact is deleted
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last Fivetran sync
    tests:
    - not_null
  - name: PROPERTY_HS_IS_UNWORKED
    description: Flag indicating if the contact is unworked
    tests:
    - not_null
  - name: PROPERTY_HS_COUNT_IS_WORKED
    description: Count of times the contact has been worked
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_ANALYTICS_FIRST_TIMESTAMP
    description: Timestamp of first analytics event
    tests:
    - not_null
  - name: PROPERTY_HS_TIME_IN_LEAD
    description: Time the contact has been in lead status
    tests:
    - not_null
  - name: PROPERTY_EMAIL
    description: Email address of the contact
    tests:
    - not_null
  - name: PROPERTY_HS_PIPELINE
    description: Pipeline the contact is associated with
    tests:
    - not_null
  - name: PROPERTY_HS_EMAIL_DOMAIN
    description: Domain of the contact's email address
    tests:
    - not_null
  - name: PROPERTY_HS_SOCIAL_GOOGLE_PLUS_CLICKS
    description: Number of Google Plus clicks
    tests:
    - not_null
  - name: PROPERTY_HS_COUNT_IS_UNWORKED
    description: Count of times the contact was unworked
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_OBJECT_SOURCE
    description: Source of the contact object
    tests:
    - not_null
  - name: PROPERTY_HS_V_2_DATE_ENTERED_LEAD
    description: Date the contact entered lead status
    tests:
    - not_null
  - name: PROPERTY_HS_REGISTERED_MEMBER
    description: Flag indicating if contact is a registered member
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_ANALYTICS_NUM_VISITS
    description: Number of visits by the contact
    tests:
    - not_null
  - name: PROPERTY_FIRSTNAME
    description: First name of the contact
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_SOURCE
    description: Source of the contact in analytics
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_LABEL
    description: Label for the object source
    tests:
    - not_null
  - name: PROPERTY_HS_SEQUENCES_ACTIVELY_ENROLLED_COUNT
    description: Count of active sequence enrollments
    tests:
    - not_null
  - name: PROPERTY_HS_USER_IDS_OF_ALL_OWNERS
    description: User IDs of all owners of the contact
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_JOBTITLE
    description: Job title of the contact
    cocoon_meta:
      missing_reason: Contact may not be employed or job title unknown.
  - name: PROPERTY_LASTNAME
    description: Last name of the contact
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_LATEST_SOURCE
    description: Latest source of the contact
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_REVENUE
    description: Revenue associated with the contact
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_AVERAGE_PAGE_VIEWS
    description: Average page views by the contact
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_NUM_EVENT_COMPLETIONS
    description: Number of completed events by the contact
    tests:
    - not_null
  - name: PROPERTY_HS_SOCIAL_FACEBOOK_CLICKS
    description: Number of Facebook clicks
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_ENTERED_LEAD
    description: Date the contact entered lead status
    tests:
    - not_null
  - name: PROPERTY_HS_LATEST_SOURCE_DATA_1
    description: Latest source of contact data
    tests:
    - not_null
  - name: PROPERTY_HS_LATEST_SOURCE_DATA_2
    description: Additional details about latest source
    tests:
    - not_null
  - name: PROPERTY_HS_SOCIAL_LINKEDIN_CLICKS
    description: Number of LinkedIn clicks
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_SOURCE_DATA_2
    description: Additional analytics source data
    tests:
    - not_null
  - name: PROPERTY_NUM_CONVERSION_EVENTS
    description: Number of conversion events
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_NUM_PAGE_VIEWS
    description: Number of page views
    tests:
    - not_null
  - name: PROPERTY_HS_ANALYTICS_SOURCE_DATA_1
    description: Primary analytics source data
    tests:
    - not_null
  - name: PROPERTY_NUM_UNIQUE_CONVERSION_EVENTS
    description: Number of unique conversion events
    tests:
    - not_null
  - name: PROPERTY_HS_ALL_CONTACT_VIDS
    description: All contact IDs associated with this contact
    tests:
    - not_null
  - name: PROPERTY_HS_LATEST_SOURCE_TIMESTAMP
    description: Timestamp of latest source update
    tests:
    - not_null
  - name: PROPERTY_LASTMODIFIEDDATE
    description: Date of last modification
    tests:
    - not_null
  - name: PROPERTY_HS_UPDATED_BY_USER_ID
    description: ID of user who last updated the contact
    tests:
    - not_null
  - name: PROPERTY_HS_CREATED_BY_USER_ID
    description: ID of user who created the contact
    tests:
    - not_null
  - name: PROPERTY_HS_SOCIAL_NUM_BROADCAST_CLICKS
    description: Number of broadcast clicks
    tests:
    - not_null
  - name: PROPERTY_LIFECYCLESTAGE
    description: Current lifecycle stage of the contact
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ASSIGNEDDATE
    description: Date when owner was assigned
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_LIFECYCLESTAGE_LEAD_DATE
    description: Date when contact became a lead
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_ID
    description: Source ID of the contact object
    tests:
    - not_null
  - name: PROPERTY_CREATEDATE
    description: Date when contact was created
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ID
    description: ID of the contact owner
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_OBJECT_ID
    description: Unique object ID of the contact
    tests:
    - not_null
  - name: PROPERTY_HS_IS_CONTACT
    description: Boolean indicating if it's a contact
    tests:
    - not_null
  - name: PROPERTY_HS_ALL_OWNER_IDS
    description: All owner IDs associated with this contact
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_OBJECT_SOURCE_USER_ID
    description: User ID of the object source
    tests:
    - not_null
  - name: PROPERTY_HS_SOCIAL_TWITTER_CLICKS
    description: Number of Twitter clicks
    tests:
    - not_null
  - name: PROPERTY_NUM_NOTES
    description: Number of notes on the contact
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_NOTES_LAST_UPDATED
    description: Date when notes were last updated
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_NUM_CONTACTED_NOTES
    description: Number of contacted notes
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_HS_CALCULATED_MOBILE_NUMBER
    description: Calculated mobile number
    cocoon_meta:
      missing_reason: Unknown
  - name: PROPERTY_MOBILEPHONE
    description: Mobile phone number
    cocoon_meta:
      missing_reason: Not all leads provide or have a mobile phone number.
  - name: PROPERTY_HS_SEARCHABLE_CALCULATED_MOBILE_NUMBER
    description: Searchable mobile number for contact
    cocoon_meta:
      missing_reason: Unknown
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:12.842441+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."ENGAGEMENT_TASK"

version: 2
models:
- name: stg_ENGAGEMENT_TASK
  description: The table is about task engagements. It contains details such as task
    type, priority, status, and due date. The table includes information on task creation,
    modification, and completion. It also stores data about task owners, related objects,
    and system properties. The table tracks engagement sources and pipeline stages
    for tasks.
  columns:
  - name: ENGAGEMENT_ID
    description: Unique identifier for the task engagement
    tests:
    - not_null
  - name: TYPE
    description: Type of engagement (TASK in this case)
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Indicates if the record was deleted in Fivetran
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last synchronization in Fivetran
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_RELATIVE_REMINDERS
    description: Array of relative reminders for the task
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_FOR_OBJECT_TYPE
    description: Type of object the task is associated with
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_PRIORITY
    description: Priority level of the task
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_TYPE
    description: Specific type or category of the task
    tests:
    - not_null
  - name: PROPERTY_HS_LASTMODIFIEDDATE
    description: Timestamp of last modification to the task
    tests:
    - not_null
  - name: PROPERTY_HS_BODY_PREVIEW_IS_TRUNCATED
    description: Indicates if task description preview is truncated
    tests:
    - not_null
  - name: PROPERTY_HS_PIPELINE
    description: ID of the pipeline associated with the task
    tests:
    - not_null
  - name: PROPERTY_HS_CREATEDATE
    description: Timestamp of task creation
    tests:
    - not_null
  - name: PROPERTY_HS_TIME_IN_AF_0_E_6_A_5_C_2_EA_3_4_C_72_B_69_F_7_C_6_CB_3_FDB_591_1652950531
    description: Time spent in a specific pipeline stage
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_COMPLETED
    description: Indicates if the task is completed
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_COMPLETED_LINKED_IN
    description: Indicates if task was completed via LinkedIn
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE
    description: Source of the task object
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_COMPLETED_EMAIL
    description: Indicates if task was completed via email
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_ALL_DAY
    description: Indicates if the task is an all-day event
    tests:
    - not_null
  - name: PROPERTY_HS_PIPELINE_STAGE
    description: ID of the pipeline stage for the task
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_SEND_DEFAULT_REMINDER
    description: Indicates if default reminder should be sent
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_ENTERED_AF_0_E_6_A_5_C_2_EA_3_4_C_72_B_69_F_7_C_6_CB_3_FDB_591_1652950531
    description: Date entered a specific pipeline stage
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_COMPLETED_CALL
    description: Indicates if task was completed via call
    tests:
    - not_null
  - name: PROPERTY_HS_UPDATED_BY_USER_ID
    description: ID of user who last updated the task
    tests:
    - not_null
  - name: PROPERTY_HS_CREATED_BY_USER_ID
    description: ID of user who created the task
    tests:
    - not_null
  - name: PROPERTY_HS_ENGAGEMENT_SOURCE
    description: Source of the engagement
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_COMPLETION_COUNT
    description: Number of times the task was completed
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_MISSED_DUE_DATE
    description: Indicates if the task missed its due date
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ASSIGNEDDATE
    description: Date the task was assigned to an owner
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_MISSED_DUE_DATE_COUNT
    description: Number of times the task missed due date
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_ID
    description: ID of the source object
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_OVERDUE
    description: Indicates if the task is overdue
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_FAMILY
    description: Categorizes the task type
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_STATUS
    description: Current status of the task
    tests:
    - not_null
  - name: PROPERTY_HS_CREATED_BY
    description: ID of the user who created the task
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_LABEL
    description: Source label of the task object
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_COMPLETED_SEQUENCE
    description: Indicates if task is part of completed sequence
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ID
    description: ID of the task owner
    tests:
    - not_null
  - name: PROPERTY_HS_TIMESTAMP
    description: Timestamp of task creation or modification
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_ID
    description: Unique identifier for the task object
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_IS_PAST_DUE_DATE
    description: Indicates if task is past due date
    tests:
    - not_null
  - name: PROPERTY_HS_TASK_SUBJECT
    description: Subject or title of the task
    tests:
    - not_null
  - name: PROPERTY_HS_USER_IDS_OF_ALL_OWNERS
    description: IDs of all users who own the task
    tests:
    - not_null
  - name: PROPERTY_HS_ALL_OWNER_IDS
    description: IDs of all owners (including non-users)
    tests:
    - not_null
  - name: PROPERTY_HS_MODIFIED_BY
    description: ID of the user who last modified the task
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_USER_ID
    description: ID of the user who sourced the task
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:13.625783+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."FORM"

version: 2
models:
- name: stg_FORM
  description: The table is about forms. It contains details of each form including
    a unique identifier (GUID), portal ID, name, action, method, CSS class, redirect
    URL, submit button text, follow-up ID, notification recipients, lead nurturing
    campaign ID, form type, creation date, update date, deletion status, and synchronization
    timestamp. The table appears to store information about forms used in a web portal
    or marketing platform, likely HubSpot.
  columns:
  - name: GUID
    description: Unique identifier for the form
    tests:
    - not_null
  - name: PORTAL_ID
    description: ID of the portal where the form is used
    tests:
    - not_null
  - name: NAME
    description: Name of the form
    tests:
    - not_null
  - name: ACTION_
    description: Action URL for form submission
    cocoon_meta:
      missing_reason: Empty string likely represents no specific action required.
  - name: METHOD
    description: HTTP method used for form submission
    tests:
    - not_null
  - name: CSS_CLASS
    description: CSS classes applied to the form
    tests:
    - not_null
  - name: REDIRECT
    description: URL to redirect after form submission
    cocoon_meta:
      missing_reason: Unknown
  - name: SUBMIT_TEXT
    description: Text displayed on the submit button
    tests:
    - not_null
  - name: FOLLOW_UP_ID
    description: ID for follow-up actions
    cocoon_meta:
      missing_reason: Unknown
  - name: NOTIFY_RECIPIENTS
    description: Recipients to notify upon form submission
    tests:
    - not_null
  - name: LEAD_NURTURING_CAMPAIGN_ID
    description: ID of associated lead nurturing campaign
    cocoon_meta:
      missing_reason: Unknown
  - name: FORM_TYPE
    description: Type or platform of the form
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp of form creation
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp of last form update
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Deletion status of the form
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:09.154907+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."DEAL_PIPELINE_STAGE"

version: 2
models:
- name: stg_DEAL_PIPELINE_STAGE
  description: The table is about deal pipeline stages. It contains details for each
    stage such as its ID, label, display order, and probability. The table also includes
    information on whether the stage represents a closed won deal, creation and update
    timestamps, and permissions. Each stage belongs to a pipeline, identified by the
    PIPELINE_ID column.
  columns:
  - name: STAGE_ID
    description: Unique identifier for the pipeline stage
    tests:
    - not_null
  - name: PIPELINE_ID
    description: Identifier for the pipeline the stage belongs to
    tests:
    - not_null
  - name: LABEL
    description: User-friendly name of the pipeline stage
    tests:
    - not_null
  - name: DISPLAY_ORDER
    description: Numeric order for displaying stages in the pipeline
    tests:
    - not_null
  - name: WRITE_PERMISSIONS
    description: Permission level required to modify the stage
    tests:
    - not_null
  - name: CREATED_AT
    description: Timestamp when the stage was created
    tests:
    - not_null
  - name: UPDATED_AT
    description: Timestamp when the stage was last updated
    tests:
    - not_null
  - name: PROBABILITY
    description: Likelihood of deal closing at this stage
    tests:
    - not_null
  - name: CLOSED_WON
    description: Indicates if this stage represents a won deal
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record was deleted
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last synchronization by Fivetran
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:09.660040+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."DEAL_STAGE"

version: 2
models:
- name: stg_DEAL_STAGE
  description: The table is about deal stages in a CRM system. It includes details
    such as deal ID, stage value, source, date entered, and Fivetran sync information.
    Each row represents a stage in a deal's lifecycle, with timestamps for when the
    stage was entered and last synced. The Fivetran columns suggest this data is part
    of a data integration process.
  columns:
  - name: DEAL_ID
    description: Unique identifier for the deal
    tests:
    - not_null
  - name: VALUE_
    description: Current stage of the deal
    tests:
    - not_null
  - name: SOURCE_ID
    description: Identifier of the user or system that created the entry
    tests:
    - not_null
  - name: SOURCE
    description: Origin of the deal stage update
    tests:
    - not_null
  - name: DATE_ENTERED
    description: Timestamp when the deal entered this stage
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Last synchronization timestamp by Fivetran
    tests:
    - not_null
  - name: _FIVETRAN_START
    description: Start of the current version's validity period
    tests:
    - not_null
  - name: _FIVETRAN_END
    description: End of the current version's validity period
    tests:
    - not_null
  - name: _FIVETRAN_ACTIVE
    description: Indicates if this is the current active version
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:08.178045+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."DEAL"

version: 2
models:
- name: stg_DEAL
  description: The table is about deals in a CRM system. It contains details like
    deal ID, portal ID, owner ID, deal name, amount, pipeline stage, creation date,
    and various other properties. The table tracks deal progress, associated contacts,
    probabilities, and financial projections. It also includes timestamps for stage
    changes, user IDs for deal creation and updates, and flags for deal status (open,
    closed, won).
  columns:
  - name: DEAL_ID
    description: Unique identifier for the deal
    tests:
    - not_null
  - name: PORTAL_ID
    description: Identifier for the portal associated with the deal
    tests:
    - not_null
  - name: IS_DELETED
    description: Flag indicating if the deal is deleted
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Fivetran-specific deletion flag
    tests:
    - not_null
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last Fivetran sync
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_ASSOCIATED_ACTIVE_DEAL_REGISTRATIONS
    description: Number of active deal registrations associated
    tests:
    - not_null
  - name: OWNER_ID
    description: Identifier of the deal owner
    tests:
    - not_null
  - name: PROPERTY_HS_PROJECTED_AMOUNT_IN_HOME_CURRENCY
    description: Projected deal amount in home currency
    tests:
    - not_null
  - name: PROPERTY_NUM_ASSOCIATED_CONTACTS
    description: Number of contacts associated with the deal
    tests:
    - not_null
  - name: PROPERTY_HS_DEAL_STAGE_PROBABILITY_SHADOW
    description: Shadow probability of the deal stage
    tests:
    - not_null
  - name: PROPERTY_DAYS_TO_CLOSE
    description: Estimated number of days until deal closure
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_ENTERED_APPOINTMENTSCHEDULED
    description: Date entered appointment scheduled stage
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_EXITED_APPOINTMENTSCHEDULED
    description: Date exited appointment scheduled stage
    tests:
    - not_null
  - name: PROPERTY_HS_DEAL_STAGE_PROBABILITY
    description: Probability of the current deal stage
    tests:
    - not_null
  - name: PROPERTY_HS_LASTMODIFIEDDATE
    description: Date and time of last modification
    tests:
    - not_null
  - name: PROPERTY_HS_CLOSED_DEAL_CREATE_DATE
    description: Creation date of closed deal
    tests:
    - not_null
  - name: PROPERTY_HS_IS_IN_FIRST_DEAL_STAGE
    description: Flag indicating if deal is in first stage
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE
    description: Source of the deal object
    tests:
    - not_null
  - name: PROPERTY_HS_CLOSED_DEAL_CLOSE_DATE
    description: Closing date of closed deal
    tests:
    - not_null
  - name: PROPERTY_HS_V_2_DATE_ENTERED_QUALIFIEDTOBUY
    description: Date entered qualified to buy stage
    tests:
    - not_null
  - name: PROPERTY_HS_IS_CLOSED_WON
    description: Flag indicating if deal is closed and won
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_LABEL
    description: Label for the deal object source
    tests:
    - not_null
  - name: PROPERTY_HS_USER_IDS_OF_ALL_OWNERS
    description: User IDs of all deal owners
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_TARGET_ACCOUNTS
    description: Number of target accounts for the deal
    tests:
    - not_null
  - name: PROPERTY_HS_IS_OPEN_COUNT
    description: Flag indicating if deal is open
    tests:
    - not_null
  - name: PROPERTY_HS_OPEN_DEAL_CREATE_DATE
    description: Creation date of open deal
    tests:
    - not_null
  - name: DEAL_PIPELINE_ID
    description: Identifier for the deal pipeline
    tests:
    - not_null
  - name: PROPERTY_DEALNAME
    description: Name of the deal
    tests:
    - not_null
  - name: DEAL_PIPELINE_STAGE_ID
    description: Identifier for the deal pipeline stage
    tests:
    - not_null
  - name: PROPERTY_AMOUNT
    description: Amount of the deal
    tests:
    - not_null
  - name: PROPERTY_HS_TIME_IN_QUALIFIEDTOBUY
    description: Time spent in 'Qualified to Buy' stage
    tests:
    - not_null
  - name: PROPERTY_HS_CREATEDATE
    description: Date and time when the deal was created
    tests:
    - not_null
  - name: PROPERTY_HS_DAYS_TO_CLOSE_RAW
    description: Number of days to close the deal
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_ASSOCIATED_DEAL_REGISTRATIONS
    description: Number of associated deal registrations
    tests:
    - not_null
  - name: PROPERTY_HS_FORECAST_AMOUNT
    description: Forecasted amount for the deal
    tests:
    - not_null
  - name: PROPERTY_HS_CLOSED_AMOUNT_IN_HOME_CURRENCY
    description: Closed amount in home currency
    tests:
    - not_null
  - name: PROPERTY_HS_TIME_IN_APPOINTMENTSCHEDULED
    description: Time spent in 'Appointment Scheduled' stage
    tests:
    - not_null
  - name: PROPERTY_HS_IS_CLOSED
    description: Flag indicating if the deal is closed
    tests:
    - not_null
  - name: PROPERTY_HS_UPDATED_BY_USER_ID
    description: ID of user who last updated the deal
    tests:
    - not_null
  - name: PROPERTY_AMOUNT_IN_HOME_CURRENCY
    description: Deal amount in home currency
    tests:
    - not_null
  - name: PROPERTY_HS_CREATED_BY_USER_ID
    description: ID of user who created the deal
    tests:
    - not_null
  - name: PROPERTY_HS_DATE_ENTERED_QUALIFIEDTOBUY
    description: Date entered 'Qualified to Buy' stage
    tests:
    - not_null
  - name: PROPERTY_HUBSPOT_OWNER_ASSIGNEDDATE
    description: Date when the deal owner was assigned
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_OF_ASSOCIATED_LINE_ITEMS
    description: Number of associated line items
    tests:
    - not_null
  - name: PROPERTY_HS_PROJECTED_AMOUNT
    description: Projected amount for the deal
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_ID
    description: Source ID of the deal object
    tests:
    - not_null
  - name: PROPERTY_CREATEDATE
    description: Date and time when the deal was created
    tests:
    - not_null
  - name: PROPERTY_HS_NUM_ASSOCIATED_DEAL_SPLITS
    description: Number of associated deal splits
    tests:
    - not_null
  - name: PROPERTY_HS_CLOSED_AMOUNT
    description: Closed amount of the deal
    tests:
    - not_null
  - name: PROPERTY_HS_IS_DEAL_SPLIT
    description: Flag indicating if the deal is split
    tests:
    - not_null
  - name: PROPERTY_HS_CLOSED_WON_COUNT
    description: Count of closed-won deals
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_ID
    description: Unique identifier for the deal object
    tests:
    - not_null
  - name: PROPERTY_HS_ALL_OWNER_IDS
    description: IDs of all owners associated with the deal
    tests:
    - not_null
  - name: PROPERTY_HS_OBJECT_SOURCE_USER_ID
    description: User ID of the deal object source
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:16.989066+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."USERS"

version: 2
models:
- name: stg_USERS
  description: The table is about Users. It contains user information such as ID,
    email address, role ID, and primary team ID. The table also includes metadata
    fields like _FIVETRAN_DELETED and _FIVETRAN_SYNCED, which are likely used for
    data synchronization and management purposes. Each row represents a unique user
    with their associated details.
  columns:
  - name: ID
    description: Unique identifier for the user
    tests:
    - not_null
  - name: EMAIL
    description: User's email address
    tests:
    - not_null
  - name: _FIVETRAN_DELETED
    description: Flag indicating if the record is deleted
    tests:
    - not_null
  - name: ROLE_ID
    description: Identifier for the user's role
    cocoon_meta:
      missing_reason: Unknown
  - name: PRIMARY_TEAM_ID
    description: Identifier for the user's primary team
    cocoon_meta:
      missing_reason: Unknown
  - name: _FIVETRAN_SYNCED
    description: Timestamp of last synchronization
    tests:
    - not_null
  tests: []

-- COCOON BLOCK START: PLEASE DO NOT MODIFY THIS BLOCK FOR SELF-MAINTENANCE
-- Generated at 2024-08-15 23:39:14.959582+00:00
-- COCOON BLOCK END
SELECT *
FROM "memory"."main"."PROPERTY"

version: 2
models:
- name: stg_PROPERTY
  description: The table is about Hubspot property definitions. It contains details
    of various properties for different Hubspot objects like notes, tasks, tickets,
    and contacts. Each row represents a property with attributes such as name, label,
    type, description, and whether it's Hubspot-defined. The table also includes creation
    and update timestamps for these properties.
  columns:
  - name: _FIVETRAN_ID
    description: Unique identifier for Fivetran sync
    tests:
    - not_null
  - name: HUBSPOT_OBJECT
    description: Type of Hubspot object the property belongs to
    tests:
    - not_null
  - name: NAME
    description: Internal name of the property
    tests:
    - not_null
  - name: LABEL
    description: Display name of the property
    tests:
    - not_null
  - name: TYPE
    description: Data type of the property
    tests:
    - not_null
  - name: FIELD_TYPE
    description: UI field type for the property
    tests:
    - not_null
  - name: DESCRIPTION
    description: Detailed explanation of the property
    cocoon_meta:
      missing_reason: Unknown
  - name: GROUP_NAME
    description: Category or group the property belongs to
    tests:
    - not_null
  - name: CALCULATED
    description: Indicates if the property is calculated
    tests:
    - not_null
  - name: HUBSPOT_DEFINED
    description: Indicates if the property is defined by Hubspot
    cocoon_meta:
      missing_reason: Unknown
  - name: SHOW_CURRENCY_SYMBOL
    description: Indicates if currency symbol should be displayed
    cocoon_meta:
      missing_reason: Not applicable for non-monetary fields.
  - name: CREATED_AT
    description: Timestamp when the property was created
    cocoon_meta:
      missing_reason: Unknown
  - name: UPDATED_AT
    description: Timestamp when the property was last updated
    cocoon_meta:
      missing_reason: Unknown
  - name: _FIVETRAN_SYNCED
    description: Timestamp of the last Fivetran sync
    tests:
    - not_null
  tests: []