Release Notes
December 2024
Effective December 19, 2024 we use a new December 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
We have made these schema changes to improve schema usability.
10 total changes • 9 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSIGNMENT_ASSET | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET | Data available in the ASSIGNMENT_ASSET_TYPE table. | ||
ASSIGNMENT_ASSET_ARTICULATION_RULE | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_ARTICULATION_RULE | Data available in the ASSIGNMENT_ASSET_TYPE_ARTICULATION_RULE table. | ||
ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | Data available in the ASSIGNMENT_ASSET_TYPE_CHARACTERISTIC_TYPE table. | ||
ASSIGNMENT_ASSET_DATA_QUALITY_RULE | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_DATA_QUALITY_RULE | Data available in the ASSIGNMENT_ASSET_TYPE_DATA_QUALITY_RULE table. | ||
ASSIGNMENT_ASSET_DOMAIN_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_DOMAIN_TYPE | Data available in the ASSIGNMENT_ASSET_TYPE_DOMAIN_TYPE table. | ||
ASSIGNMENT_ASSET_STATUS | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_STATUS | Data available in the ASSIGNMENT_ASSET_TYPE_STATUS table. | ||
ASSIGNMENT_ASSET_TYPE | |||||
| column | New Column | scope_id | Column added to establish a relationship with the SCOPE_COMMUNITY and SCOPE_DOMAIN tables. | ||
ASSIGNMENT_ASSET_VALIDATION_RULE | |||||
| table | Deprecated Table | ASSIGNMENT_ASSET_VALIDATION_RULE | Data available in the ASSIGNMENT_ASSET_TYPE_VALIDATION_RULE table. | ||
ASSIGNMENT_SCOPE_COMMUNITY | |||||
| table | Deprecated Table | ASSIGNMENT_SCOPE_COMMUNITY | Data available in the SCOPE_COMMUNITY table. | ||
ASSIGNMENT_SCOPE_DOMAIN | |||||
| table | Deprecated Table | ASSIGNMENT_SCOPE_DOMAIN | Data available in the SCOPE_DOMAIN table. | ||
November 2024
The following Lite connectors now support the Hybrid Deployment model:
Expand to see the full list
- 7shifts
- 360Learning
- Absorb LMS
- ActiveCampaign
- Ada
- Adobe Workfront
- Afterpay
- Aha!
- Akamai
- Akeneo
- Amazon Attribution
- Anvyl
- Appcues
- Appfigures
- Attio
- Aumni
- Auth0
- AvantLink
- Awin
- Backbone PLM
- BallotReady
- Bazaarvoice
- Bigin by Zoho CRM
- BillingPlatform
- Birdeye
- Bitly
- Bizzabo
- Boostr
- Brave Ads
- Brevo
- Brex
- Brightcove
- Buildium
- Buildkite
- Buzzsprout
- Calabrio
- Calendly
- CallRail
- Campaign Monitor
- Canny
- Canvas by Instructure
- Care Quality Commission
- Castor EDC
- Chameleon
- Chargebee Product Catalog 1.0
- Chargebee Product Catalog 2.0
- ChargeDesk
- ChartMogul
- Checkout.com
- Chorus
- Churnkey
- ChurnZero
- Cin7
- Cin7 Core
- CircleCI
- CJ Commission Detail
- Clari
- ClickUp
- Clockify
- Close
- Codefresh
- Collibra
- Column
- Concord
- Confluence
- Copper
- Criteo Retail Media
- Crossbeam
- crowd.dev
- Culture Amp
- Cvent
- Datadog
- dbt Cloud
- DCL Logistics
- Deputy
- Destini
- Dixa
- Docebo
- DoorLoop
- Drata
- Drift
- Drip
- Dropbox Sign
- DSV
- Duoplane
- EasyPost
- eBay
- Electronic Tenant Solutions
- Employment Hero
- Eventbrite
- Eventsforce
- Everhour
- ExpenseIn
- Expensify
- EZOfficeInventory
- Factbird
- Factorial
- Fillout
- FireHydrant
- Flexport
- Float
- Fone Dynamics
- Forj Community
- Fountain
- Freightview
- FreshBooks
- Freshchat
- Freshdesk Contact Center
- FreshTeam
- Friendbuy
- FullStory
- Gainsight Product Experience
- Gem
- Genesys
- GetFeedback
- GitLab
- Gladly
- GlobalMeet
- Gmail
- GoCardless
- Google Business Profile
- Google Calendar
- Gorgias
- GRIN
- Guru
- HappyFox
- Harvest
- Helpshift
- HiBob
- Hopin
- iLevel
- Incident.io
- Infobip
- Insightly
- Integral Ad Science
- Integrate
- Ironclad
- ironSource
- Ivanti
- Jira Align
- Jotform
- JustCall
- Kandji
- Katana
- Kevel
- KeyPay
- Khoros Care
- Kisi
- Kissmetrics
- Klarna
- Lattice
- LaunchDarkly
- LearnUpon
- Lemlist
- Lessonly
- Liftoff
- Linear
- LinkSquares
- LiveChat Partner
- Lob
- Looker
- Loop
- Loopio
- Luma
- Mailgun
- Mambu
- Matomo
- Maxio Chargify
- Maxio SaaSOptics
- Medallia Agile Research
- Megaphone
- Mention
- Microsoft Entra ID
- Missive
- Mixmax
- MNTN
- Mode
- Moloco
- Mux
- myosh
- Namely
- Navan
- Notion
- Okendo
- Ometria
- ON24
- OnceHub
- Open Data DC
- Open Exchange Rates
- Opsgenie
- Oracle Moat Analytics
- Orbit
- Ordway
- Ortto
- PagerDuty
- Papershift
- Partnerize
- PartnerStack Vendor
- Paychex
- Persona
- Personio
- Picqer
- Pingdom
- Pinpoint
- Pinterest Organic
- Pivotal Tracker
- Piwik PRO
- Planful
- Planhat
- Playvox
- Playvox Workforce Management
- Podio
- PostHog
- Postmark
- PowerReviews Enterprise
- Prive
- Procore
- Productboard
- Productive
- Proofpoint Security Awareness
- Qualaroo
- Quora Ads
- Rakuten Advertising
- Ramp
- Rarible
- ReBound Returns
- ReferralHero
- Resource Management by Smartsheet
- RetailNext
- Retently
- Revel Systems
- RevenueCat
- REVIEWS.io
- RevOps
- RevX
- Ricochet360
- Ringover
- Rippling
- Rithum
- Rocketlane
- Rollbar
- Rootly
- RTB House
- Ruddr
- SafetyCulture
- Salsify
- Samsara
- SCORM
- Security Journey
- ServiceTitan
- Sharetribe
- ShipHero
- ShipNetwork
- ShipStation
- Shopware
- Short.io
- Shortcut
- Sigma Computing
- Simplecast
- Simplesat
- SISTRIX
- Skilljar
- SkillsTX
- SkuVault
- Smadex
- SmartHR
- SmartRecruiters
- Smartwaiver
- Snyk
- SolarWinds Service Desk
- SonarQube
- SparkPost
- Splash
- Split
- Squarespace
- StackAdapt
- Standard Metrics
- StarRez
- Statuspage
- Stylight
- Subscript
- Survicate
- Swoogo
- Tableau
- Talkwalker
- Teads
- Teamtailor
- Teamwork
- Tempo
- TestRail
- Thinkific
- Ticket Tailor
- Toggl Track
- Transcend
- Trelica
- Trello
- Tremendous
- Triple Whale
- Trisolute
- Tymeshift
- Udemy Business
- UKG Pro
- Upland Software
- UpPromote
- Veeqo
- Vitally
- Vonage Contact Center
- VTS
- VWO
- Webconnex
- When I Work
- Wherefour
- WooCommerce
- WordPress
- Workable
- Workday Strategic Sourcing
- WorkRamp
- Wrike
- Xandr
- Xray
- Yahoo Search Ads on Yahoo Japan
- YouGov Sport
- Younium
- Zenefits
- Zingtree
- Zoho Books
- Zoho Campaigns
- Zoho Desk
- Zonka Feedback
- Zoom
We have updated our sync strategy. We now re-import the ATTRIBUTE table once a month and no longer re-import the JOB table. Previously, we re-imported these two tables weekly.
October 2024
Effective October 17, 2024 we use a new October 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
We are making these schema changes to enhance the usability and efficiency of the connector schema.
6 total changes • 6 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSET_TAG | |||||
| table | Deprecated Table | ASSET_TAG | Data now available in the TAGS table. | ||
ASSIGNMENT_ATTRIBUTE_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_ATTRIBUTE_TYPE | Child table of the ASSIGNMENT_COMPLEX_RELATION_TYPE table. | ||
ASSIGNMENT_COMPLEX_RELATION_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_COMPLEX_RELATION_TYPE | Data now available in the COMPLEX_RELATION_TYPE table. | ||
ASSIGNMENT_DOMAIN | |||||
| table | Deprecated Table | ASSIGNMENT_DOMAIN | Data now available in the ASSET_TYPE table. | ||
ASSIGNMENT_LEG_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_LEG_TYPE | Child table of the ASSIGNMENT_COMPLEX_RELATION_TYPE table. | ||
ASSIGNMENT_RELATION_TYPE | |||||
| table | Deprecated Table | ASSIGNMENT_RELATION_TYPE | Data now available in the RELATION_TYPE table. | ||
September 2024
Effective September 12, 2024 we use a new September 2024 schema. Review the latest ERD to better understand the schema changes. Also, see our Schema Migrations article for more details.You should review the changes and update your downstream queries if necessary. Failing to do so may lead to missing or incomplete data in your data pipelines.
We're making these schema changes to ensure data integrity and because there are columns that use reserved keywords.
38 total changes • 38 possible breaking changes
| Table/column | Change type | Old name | New name | Notes | |
|---|---|---|---|---|---|
ASSET | |||||
| column | Rename Column | system | is_system | ||
ASSET_TYPE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_ARTICULATION_RULE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_CHARACTERISTIC_TYPE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE_ARTICULATION_RULE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ASSET_TYPE_CHARACTERISTIC_TYPE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_ATTRIBUTE_TYPE | |||||
| column | Rename Column | system | is_system | ||
ASSIGNMENT_LEG_TYPE | |||||
| column | Rename Column | system | is_system | ||
ATTACHMENT | |||||
| column | Rename Column | system | is_system | ||
ATTRIBUTE | |||||
| column | Rename Column | system | is_system | ||
ATTRIBUTE_TYPE | |||||
| column | Rename Column | system | is_system | ||
COMMENT | |||||
| column | Rename Column | system | is_system | ||
COMMUNITY | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION_ATTRIBUTE | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION_LEG | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE_ATTRIBUTE_TYPE | |||||
| column | Rename Column | system | is_system | ||
COMPLEX_RELATION_TYPE_LEG_TYPE | |||||
| column | Rename Column | system | is_system | ||
DATA_QUALITY_METRIC | |||||
| column | Rename Column | system | is_system | ||
DATA_QUALITY_RULE | |||||
| column | Rename Column | system | is_system | ||
DOMAIN | |||||
| column | Rename Column | system | is_system | ||
DOMAIN_TYPE | |||||
| column | Rename Column | system | is_system | ||
ISSUE | |||||
| column | Rename Column | system | is_system | ||
JOB | |||||
| column | Rename Column | system | is_system | ||
MAPPING | |||||
| column | Rename Column | system | is_system | ||
RATING | |||||
| column | Rename Column | system | is_system | ||
RELATION | |||||
| column | Rename Column | system | is_system | ||
RELATION_TYPE | |||||
| column | Rename Column | system | is_system | ||
RESPONSIBILITY | |||||
| column | Rename Column | system | is_system | ||
ROLE | |||||
| column | Rename Column | system | is_system | ||
SCOPE | |||||
| column | Rename Column | system | is_system | ||
SCOPE_COMMUNITY | |||||
| column | Primary Key Change | community_id 🔑 | Added to primary key. | ||
SCOPE_DOMAIN | |||||
| column | Primary Key Change | domain_id 🔑 | Added to primary key. | ||
SEARCH_VIEW_AGGREGATION | |||||
| column | Rename Column | limit | limits | ||
USERS | |||||
| column | Rename Column | language | languages | ||
June 2023
Lite connectors are now available for the following sources: