Segment

Share on facebook
Share on twitter
Share on linkedin

Snowflake Cost Saving

We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now

Data Connector Description:

Data Connector Type: Event

Data Connector Documentation:

[Segment, Segment, is an event tracking library. , Supported services, You can send events directly to your destination using , Fivetran Webhooks, or host them in an S3 bucket as a storage service, and connect your S3 bucket with , Fivetran Segment S3, ., Features, Featurexa0Namexa0xa0xa0xa0, Supported, Notes, Capture Deletes, check, Custom Data, check, Custom tables and standard tables with custom columns, Data Blocking, Column Hashing, Re-sync, check, Connector level. Will sync only the last 30 days of data due to the S3/webhooks retention period., History, API Configurable, check, Priority-first sync, dbt Package, Setup guide, Follow our step-by-step , Segment setup guide, to connect Segment with your destination using Fivetran connectors., Schema information, “Segment schema follows Fivetrans “, standard API schema rules, . We try to follow , “Segments schema”, as closely as possible, and support all tables in their schema, except for the ones in testing stage., “We further normalize the tables and make sure theres as little duplication as possible across all tables. “, We centralize all the data in a star schema. The central table of the star schema is , tracks, which maintains the standard property for every track event. For example, all event tables would have a device column, which we would pull into the central table, among other , common, columns across all tables. , We will sync the following standard tables: , identifies, pages, screens, tracks, “In the following section, COLUMN lists the title of every column in the table, and TYPE tells you the columns data type. REFERENCE tells you which table and column you can join the current table with.”, identifies, Column, Type, Reference, message_id üîë, TEXT, address_city, TEXT, address_country, TEXT, address_postal_code, TEXT, address_state, TEXT, address_street, TEXT, age, BIGINT, anonymous_id, TEXT, avatar, TEXT, birthday, TIMESTAMP, context_app_build, TEXT, context_app_name, TEXT, context_app_version, TEXT, context_campaign_content, TEXT, context_campaign_medium, TEXT, context_campaign_name, TEXT, context_campaign_source, TEXT, context_campaign_term, TEXT, context_device_id, TEXT, context_device_manufacturer, TEXT, context_device_model, TEXT, context_device_name, TEXT, context_device_type, TEXT, context_device_version, TEXT, context_ip, TEXT, context_library_name, TEXT, context_library_version, TEXT, context_locale, TEXT, context_location_city, TEXT, context_location_country, TEXT, context_location_latitude, DOUBLE, context_location_longitude, DOUBLE, context_location_region, TEXT, context_location_speed, BIGINT, context_network_bluetooth, BOOLEAN, context_network_carrier, TEXT, context_network_cellular, BOOLEAN, context_network_wifi, BOOLEAN, context_os_name, TEXT, context_os_version, TEXT, context_page_hash, TEXT, context_page_path, TEXT, context_page_referrer, TEXT, context_page_search, TEXT, context_page_title, TEXT, context_page_url, TEXT, context_referrer_link, TEXT, context_referrer_name, TEXT, context_referrer_type, TEXT, context_referrer_url, TEXT, context_screen_density, BIGINT, context_screen_height, BIGINT, context_screen_width, BIGINT, context_timezone, TEXT, context_user_agent, TEXT, created_at, TIMESTAMP, current_country, TEXT, description, TEXT, email, TEXT, first_name, TEXT, gender, TEXT, given_name, TEXT, integrations_google_analytics, BOOLEAN, integrations_mixpanel, BOOLEAN, last_name, TEXT, name, TEXT, phone, TEXT, project_id, TEXT, received_at, TIMESTAMP, sent_at, TIMESTAMP, surname, TEXT, TIMESTAMP, TIMESTAMP, title, TEXT, type, TEXT, user_id, TEXT, username, TEXT, version, TEXT, website, TEXT, pages, Column, Type, Reference, message_id üîë, TEXT, anonymous_id, TEXT, app_session_id, TEXT, client_type, TEXT, context_app_build, TEXT, context_app_name, TEXT, context_app_version, TEXT, context_campaign_content, TEXT, context_campaign_medium, TEXT, context_campaign_name, TEXT, context_campaign_source, TEXT, context_campaign_term, TEXT, context_device_id, TEXT, context_device_manufacturer, TEXT, context_device_model, TEXT, context_device_name, TEXT, context_device_type, TEXT, context_device_version, TEXT, context_ip, TEXT, context_library_name, TEXT, context_library_version, TEXT, context_locale, TEXT, context_location_city, TEXT, context_location_country, TEXT, context_location_latitude, DOUBLE, context_location_longitude, DOUBLE, context_location_region, TEXT, context_location_speed, BIGINT, context_network_bluetooth, BOOLEAN, context_network_carrier, TEXT, context_network_cellular, BOOLEAN, context_network_wifi, BOOLEAN, context_os_name, TEXT, context_os_version, TEXT, context_page_hash, TEXT, context_page_path, TEXT, context_page_referrer, TEXT, context_page_search, TEXT, context_page_title, TEXT, context_page_url, TEXT, context_referrer_link, TEXT, context_referrer_name, TEXT, context_referrer_type, TEXT, context_referrer_url, TEXT, context_screen_density, BIGINT, context_screen_height, BIGINT, context_screen_width, BIGINT, context_timezone, TEXT, context_user_agent, TEXT, environment, TEXT, name, TEXT, order_id, TEXT, order_session_id, TEXT, path, TEXT, project_id, TEXT, received_at, TIMESTAMP, referrer, TEXT, search, TEXT, sent_at, TIMESTAMP, store_id, TEXT, TIMESTAMP, TIMESTAMP, title, TEXT, type, TEXT, url, TEXT, user_id, TEXT, version, TEXT, screens, Column, Type, Reference, message_id üîë, TEXT, anonymous_id, TEXT, brand_id, DOUBLE, category_id, DOUBLE, context_app_build, TEXT, context_app_name, TEXT, context_app_version, TEXT, context_campaign_content, TEXT, context_campaign_medium, TEXT, context_campaign_name, TEXT, context_campaign_source, TEXT, context_campaign_term, TEXT, context_device_id, TEXT, context_device_manufacturer, TEXT, context_device_model, TEXT, context_device_name, TEXT, context_device_type, TEXT, context_device_version, TEXT, context_ip, TEXT, context_library_name, TEXT, context_library_version, TEXT, context_locale, TEXT, context_location_city, TEXT, context_location_country, TEXT, context_location_latitude, DOUBLE, context_location_longitude, DOUBLE, context_location_region, TEXT, context_location_speed, BIGINT, context_network_bluetooth, BOOLEAN, context_network_carrier, TEXT, context_network_cellular, BOOLEAN, context_network_wifi, BOOLEAN, context_os_name, TEXT, context_os_version, TEXT, context_page_hash, TEXT, context_page_path, TEXT, context_page_referrer, TEXT, context_page_search, TEXT, context_page_title, TEXT, context_page_url, TEXT, context_referrer_link, TEXT, context_referrer_name, TEXT, context_referrer_type, TEXT, context_referrer_url, TEXT, context_screen_density, BIGINT, context_screen_height, BIGINT, context_screen_width, BIGINT, context_timezone, TEXT, context_user_agent, TEXT, country_name, TEXT, coutry_name, TEXT, curated_home, BOOLEAN, department_id, DOUBLE, name, TEXT, old_screen_name, TEXT, postal_code, TEXT, project_id, TEXT, received_at, TIMESTAMP, sent_at, TIMESTAMP, service_type, TEXT, store_id, DOUBLE, TIMESTAMP, TIMESTAMP, title, TEXT, type, TEXT, user_id, TEXT, version, TEXT, tracks, Column, Type, Reference, anonymous_id, TEXT, context_app_build, TEXT, context_app_name, TEXT, context_app_version, TEXT, context_campaign_content, TEXT, context_campaign_medium, TEXT, context_campaign_name, TEXT, context_campaign_source, TEXT, context_campaign_term, TEXT, context_device_id, TEXT, context_device_manufacturer, TEXT, context_device_model, TEXT, context_device_name, TEXT, context_device_type, TEXT, context_device_version, TEXT, context_ip, TEXT, context_library_name, TEXT, context_library_version, TEXT, context_locale, TEXT, context_location_city, TEXT, context_location_country, TEXT, context_location_latitude, DOUBLE, context_location_longitude, DOUBLE, context_location_region, TEXT, context_location_speed, BIGINT, context_network_bluetooth, BOOLEAN, context_network_carrier, TEXT, context_network_cellular, BOOLEAN, context_network_wifi, BOOLEAN, context_os_name, TEXT, context_os_version, TEXT, context_page_hash, TEXT, context_page_path, TEXT, context_page_referrer, TEXT, context_page_search, TEXT, context_page_title, TEXT, context_page_url, TEXT, context_referrer_link, TEXT, context_referrer_name, TEXT, context_referrer_type, TEXT, context_referrer_url, TEXT, context_screen_density, BIGINT, context_screen_height, BIGINT, context_screen_width, BIGINT, NOTE: These tables support nested dynamic columns. We add a prefix to the nested column names to avoid potential conflicts between the custom column names and the schema column names. Depending on the attribute type, we add a prefix properties_, or , traits_ to the custom column name to unnest and promote them., For example, if we detect the following nested column , timestamp, :, {n timestamp : “1970-01-01T00:00:00Z”,n properties : n {n timestamp : 16000000000n }n }n, we rename it as , properties_timestamp, :, {n timestamp : “1970-01-01T00:00:00Z”,n properties_timestamp : 16000000000n }n]

Share on facebook
Share on twitter
Share on linkedin

Join The Club

Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!