Release Notes
July 2024
LinkedIn has deprecated the following tables:
PAGE_STATISTIC_BY_REGION- replaced byPAGE_STATISTIC_BY_GEOPAGE_STATISTIC_BY_COUNTRY- replaced byPAGE_STATISTIC_BY_GEO_COUNTRYREGIONCOUNTRY
April 2024
We have added new Quickstart packages for the following connectors:
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.
January 2024
We have changed the schema of the following tables according to the Posts API.
Expand for the full list of changed tables and their columns
SHARE_HISTORYid🔑last_modified_time🔑ad_context_dsc_ad_accountad_context_dsc_ad_typead_context_dsc_namead_context_dsc_statusad_context_is_dscauthorcommentarycontainer_entitycontent_call_to_action_labelcontent_landing_pagecreated_timedistribution_external_distribution_channelsdistribution_feed_distributionfirst_published_atis_reshare_disabled_by_authorlifecycle_statelifecycle_state_info_content_statuslifecycle_state_info_is_edited_by_authorlifecycle_state_info_review_statusresponse_context_parentresponse_context_rootvisibility
UGC_POST_HISTORYid🔑last_modified_time🔑ad_context_dsc_ad_accountad_context_dsc_ad_typead_context_dsc_namead_context_dsc_statusad_context_is_dscauthorcommentarycontainer_entitycontent_call_to_action_labelcontent_landing_pagecreated_timedistribution_external_distribution_channelsdistribution_feed_distributionfirst_published_atis_reshare_disabled_by_authorlifecycle_statelifecycle_state_info_content_statuslifecycle_state_info_is_edited_by_authorlifecycle_state_info_review_statusresponse_context_parentresponse_context_rootvisibility
POST_CONTENT_fivetran_id🔑post_id🔑article_descriptionarticle_sourcearticle_thumbnailarticle_thumbnail_alt_textarticle_titlecarousel_idmedia_alt_textmedia_idmedia_titlemulti_image_alt_textpoll_questionpoll_settings_durationpoll_settings_is_voter_visible_to_authorpoll_settings_vote_selection_typepoll_unique_voters_countreference_idtype
SHARE_CONTENT_fivetran_id🔑share_id🔑article_descriptionarticle_sourcearticle_thumbnailarticle_thumbnail_alt_textarticle_titlecarousel_idmedia_alt_textmedia_idmedia_titlemulti_image_alt_textpoll_questionpoll_settings_durationpoll_settings_is_voter_visible_to_authorpoll_settings_vote_selection_typepoll_unique_voters_countreference_idtype
November 2023
We have added a new column, agent, to the COMMENT_HISTORY table as part of the schema change in the new version of the LinkedIn API.
July 2023
We have made the following schema changes to support the LinkedIn API changes:
- Replaced the
FOLLOWERS_BY_REGIONtable with theFOLLOWERS_BY_GEOtable. The new table links toGEOinstead ofREGION. - Replaced the
FOLLOWERS_BY_COUNTRYtable with theFOLLOWERS_BY_GEO_COUNTRYtable. The new table links toGEOinstead ofCOUNTRY.
June 2023
We have added a new table, TOTAL_FOLLOWER_STATISTIC. The table contains information about the total followers count by organization.
May 2023
We have switched to the /posts endpoint. As a result of this switch, we have changed the column list of some of the existing tables and added some new tables.
Expand for the full list of new and changed tables and their columns
SHARE_HISTORYid🔑last_modified_time🔑authorcontainer_entitycreated_actorcreated_timedistribution_external_distribution_channelsdistribution_feed_distributionfirst_published_atlast_modified_actorlifecycle_stateresponse_context_parentresponse_context_rootvisibility
UGC_POST_HISTORYid🔑last_modified_time🔑authorcontainer_entitycreated_actorcreated_timedistribution_external_distribution_channelsdistribution_feed_distributionfirst_published_atlast_modified_actorlifecycle_stateresponse_context_parentresponse_context_rootvisibility
POST_CONTENT_fivetran_id🔑post_id🔑article_descriptionarticle_sourcearticle_thumbnailarticle_thumbnail_alt_textarticle_titlecarousel_idmedia_alt_textmedia_idmedia_titlemulti_image_alt_textpoll_questionpoll_settings_durationpoll_settings_is_voter_visible_to_authorpoll_settings_vote_selection_typepoll_unique_voters_counttype
SHARE_CONTENT_fivetran_id🔑share_id🔑article_descriptionarticle_sourcearticle_thumbnailarticle_thumbnail_alt_textarticle_titlecarousel_idmedia_alt_textmedia_idmedia_titlemulti_image_alt_textpoll_questionpoll_settings_durationpoll_settings_is_voter_visible_to_authorpoll_settings_vote_selection_typepoll_unique_voters_counttype
POST_CAROUSEL_CARD_fivetran_id🔑media_id🔑landing_pagemedia_alt_textmedia_idmedia_title
SHARE_CAROUSEL_CARD_fivetran_id🔑media_id🔑landing_pagemedia_alt_textmedia_idmedia_title
POST_MULTI_IMAGE_fivetran_id🔑id🔑alt_texttitle
SHARE_MULTI_IMAGE_fivetran_id🔑id🔑alt_texttitle
POST_CONTENT_POLL_OPTION_fivetran_id🔑text🔑is_voted_by_viewervote_count
SHARE_CONTENT_POLL_OPTION_fivetran_id🔑text🔑is_voted_by_viewervote_count
POST_DISTRIBUTION_TARGET_SENIORITIESpost_id🔑post_last_modified_time🔑seniority_id🔑
POST_DISTRIBUTION_TARGET_INDUSTRIESpost_id🔑post_last_modified_time🔑industry_id🔑
POST_DISTRIBUTION_TARGET_LOCATIONSpost_id🔑post_last_modified_timelocation
POST_DISTRIBUTION_TARGET_INTERFACE_LOCALESpost_id🔑post_last_modified_time🔑countrylanguage
POST_DISTRIBUTION_TARGET_JOB_FUNCTIONSpost_id🔑post_last_modified_time🔑function_id🔑
POST_DISTRIBUTION_TARGET_STAFF_COUNT_RANGESpost_id🔑post_last_modified_time🔑staff_count_range
January 2023
We have migrated from the Industries API to the new Industry Taxonomy Versions API.
June 2022
We have removed statistic values used for ID calculation of lifetime statistic entities. We update statistic records in the destination when their values change instead of adding new values.
December 2021
Our LinkedIn Company Pages connector is now generally available. Read our LinkedIn Company Pages connector documentation.
We have released pre-built, dbt Core-compatible data models for LinkedIn Company Pages. Find the model in Fivetran's dbt hub. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.