LogoLogo
  • 🦩Overview
  • 💾Datasets
    • Overview
    • Core Concepts
      • Columns & Annotations
      • Type & Property Mappings
      • Relationships
    • Basic Datasets
      • dbt Integration
      • Sigma Integration
      • Looker Integration
    • SaaS Datasets
    • CSV Datasets
    • Streaming Datasets
    • Entity Resolution
    • AI Columns
      • AI Prompts Recipe Book
    • Enrichment Columns
      • Quick Start
      • HTTP Request Enrichments
    • Computed Columns
    • Version Control
  • 📫Syncs
    • Overview
    • Triggering & Scheduling
    • Retry Handling
    • Live Syncs
    • Audience Syncs
    • Observability
      • Current Sync Run Overview
      • Sync History
      • Sync Tracking
      • API Inspector
      • Sync Alerts
      • Observability Lake
      • Datadog Integration
      • Warehouse Writeback
      • Sync Lifecycle Webhooks
      • Sync Dry Runs
    • Structuring Data
      • Liquid Templates
      • Event Syncs
      • Arrays and Nested Objects
  • 👥Audience Hub
    • Overview
    • Creating Segments
      • Segment Priorities
      • Warehouse-Managed Audiences
    • Experiments and Analysis
      • Audience Match Rates
    • Activating Segments
    • Calculated Columns
    • Data Preparation
      • Profile Explorer
      • Exclusion Lists
  • 🧮Data Sources
    • Overview
    • Available Sources
      • Amazon Athena
      • Amazon Redshift
      • Amazon S3
      • Azure Synapse
      • ClickHouse
      • Confluent Cloud
      • Databricks
      • Elasticsearch
      • Kafka
      • Google AlloyDB
      • Google BigQuery
      • Google Cloud SQL for PostgreSQL
      • Google Pub/Sub
      • Google Sheets
      • Greenplum
      • HTTP Request
      • HubSpot
      • Materialize
      • Microsoft Fabric
      • MotherDuck
      • MySQL
      • PostgreSQL
      • Rockset
      • Salesforce
      • SingleStore
      • Snowflake
      • SQL Server
      • Trino
  • 🛫Destinations
    • Overview
    • Available Destinations
      • Accredible
      • ActiveCampaign
      • Adobe Target
      • Aha
      • Airship
      • Airtable
      • Algolia
      • Amazon Ads DSP (AMC)
      • Amazon DynamoDB
      • Amazon EventBridge
      • Amazon Pinpoint
      • Amazon Redshift
      • Amazon S3
      • Amplitude
      • Anaplan
      • Antavo
      • Appcues
      • Apollo
      • Asana
      • AskNicely
      • Attentive
      • Attio
      • Autopilot Journeys
      • Azure Blob Storage
      • Box
      • Bloomreach
      • Blackhawk
      • Braze
      • Brevo (formerly Sendinblue)
      • Campaign Monitor
      • Canny
      • Channable
      • Chargebee
      • Chargify
      • ChartMogul
      • ChatGPT Retrieval Plugin
      • Chattermill
      • ChurnZero
      • CJ Affiliate
      • CleverTap
      • ClickUp
      • Constant Contact
      • Courier
      • Criteo
      • Crowd.dev
      • Customer.io
      • Databricks
      • Delighted
      • Discord
      • Drift
      • Drip
      • Eagle Eye
      • Emarsys
      • Enterpret
      • Elasticsearch
      • Facebook Ads
      • Facebook Product Catalog
      • Freshdesk
      • Freshsales
      • Front
      • FullStory
      • Gainsight
      • GitHub
      • GitLab
      • Gladly
      • Google Ads
        • Customer Match Lists (Audiences)
        • Offline Conversions
      • Google AlloyDB
      • Google Analytics 4
      • Google BigQuery
      • Google Campaign Manager 360
      • Google Cloud Storage
      • Google Datastore
      • Google Display & Video 360
      • Google Drive
      • Google Search Ads 360
      • Google Sheets
      • Heap.io
      • Help Scout
      • HTTP Request
      • HubSpot
      • Impact
      • Insider
      • Insightly
      • Intercom
      • Iterable
      • Jira
      • Kafka
      • Kevel
      • Klaviyo
      • Kustomer
      • Labelbox
      • LaunchDarkly
      • LinkedIn
      • LiveIntent
      • Loops
      • Mailchimp
      • Mailchimp Transactional (Mandrill)
      • Mailgun
      • Marketo
      • Meilisearch
      • Microsoft Advertising
      • Microsoft Dynamics
      • Microsoft SQL Server
      • Microsoft Teams
      • Mixpanel
      • MoEngage
      • Mongo DB
      • mParticle
      • MySQL
      • NetSuite
      • Notion
      • OneSignal
      • Optimizely
      • Oracle Database
      • Oracle Eloqua
      • Oracle Fusion
      • Oracle Responsys
      • Orbit
      • Ortto
      • Outreach
      • Pardot
      • Partnerstack
      • Pendo
      • Pinterest
      • Pipedrive
      • Planhat
      • PostgreSQL
      • PostHog
      • Postscript
      • Productboard
      • Qualtrics
      • Radar
      • Reddit Ads
      • Rokt
      • RollWorks
      • Sailthru
      • Salesforce
      • Salesforce Commerce Cloud
      • Salesforce Marketing Cloud
      • Salesloft
      • Segment
      • SendGrid
      • Sense
      • SFTP
      • Shopify
      • Singular
      • Slack
      • Snapchat
      • Snowflake
      • Split
      • Sprig
      • Statsig
      • Stripe
      • The Trade Desk
      • TikTok
      • Totango
      • Userflow
      • Userpilot
      • Vero Cloud
      • Vitally
      • Webhooks
      • Webflow
      • X Ads (formerly Twitter Ads)
      • Yahoo Ads (DSP)
      • Zendesk
      • Zoho CRM
      • Zuora
    • Custom & Partner Destinations
  • 📎Misc
    • Credits
    • Census Embedded
    • Data Storage
      • Census Store
        • Query Census Store from Snowflake
        • Query Census Store locally using DuckDB
      • General Object Storage
      • Bring Your Own Bucket
        • Bring your own S3 Bucket
        • Bring your own GCS Bucket
        • Bring your own Azure Bucket
    • Developers
      • GitLink
      • Dataset API
      • Custom Destination API
      • Management API
    • Security & Privacy
      • Login & SSO Settings
      • Workspaces
      • Role-based Access Controls
      • Network Access Controls
      • SIEM Log Forwarding
      • Secure Storage of Customer Credentials
      • Digital Markets Act (DMA) Consent for Ad Platforms
    • Health and Usage Reporting
      • Workspace Homepage
      • Product Usage Dashboard
      • Observability Toolkit
      • Alerts
    • FAQs
Powered by GitBook
On this page
  • Destination fields not showing up
  • Census permissions on dbt schemas/tables
  • 400 or 500 errors on a sync
  • Alerting
  • Destination Fields for billing
  • Ideas About Other Gotchas?

Was this helpful?

  1. Misc

FAQs

This is a page for answering some patterns of questions that we have seen. Hopefully this can make your Census UX smoother.

PreviousAlerts

Last updated 9 months ago

Was this helpful?

We try to provide a list for different categories of issues that we have seen customers run into. Please let us know if there are some other categories that you are curious about.

Destination fields not showing up

My field isn't showing up as a primary identifier on the service, or as a Lookup by option

Many services need these fields to be marked as an external id in the application. For example, needs this to be the case. You will likely need to have object/property configuration permissions to properly fix this in the destination service.

Why isn't the ID of an Object, in Salesforce, Pipedrive, Hubspot, etc. as an option for a primary identifier?

These ID's are reserved fields that we cannot use as a primary identifier, as they are protected by the destination service. We can however use it as a primary identifier for an Update Only Sync.

I'm sure this field is in the destination service and is properly set. Why isn't it showing up?

When setting up a sync for the first time, clicking on the Refresh Fields will check to see what fields Census is able to see as a primary identifier or as properties on the destination object.

Census permissions on dbt schemas/tables

Why does Census not have permissions to my dbt schema/table. I know I ran the SQL permissions script properly...

grant select on {{ this }} to user census

GRANT SELECT {{ this }} TO ROLE CENSUS_ROLE

400 or 500 errors on a sync

In general, Census should take care of these as much as possible so feel free to reach out to support at any point.

I'm seeing a 4XX error message on a sync. What should I do?

Check to see if any primary identifiers or string/varchar fields don't have any values that might trigger an error in a destination service. Examples that we have seen are: .. in an email field or an XSS-payload in a name field.

I'm seeing a 5XX error message on a sync. What should I do?

This is due to a server error, generally on the destination service. Check the error message and see if it provides guidance on what happened.

Alerting

My sync has had multiple failures, why did I only get one error message?

We optimize for signal with our alerting on sync failures or passing the threshold, assuming that the user will immediately respond and fix the error. Thus, we only send an error alert on failed records the first time it happens, and then another message once the sync recovers. The same logic is applied to when the connection (to either the source or destination) fails.

Destination Fields for billing

What are destination fields?

Destination fields are the total number of fields in downstream SaaS destinations (e.g., Intercom) which Census syncs data into for a workspace. These are measured across all syncs, not individual syncs.

For example, let’s say you have a Salesforce contacts sync and a Hubspot contacts sync. For 10 fields you could sync 1 field to Salesforce and nine to Hubspot, or five to each, or anything in between. If you sync the same five fields to both Hubspot and Salesforce, that would total to 10 fields because it’s relative to the downstream destination.

In the Census UI, destination fields can be found within a sync as the mapped fields and identifiers.

How are destination fields measured?

Each month a workspace can sync up to the number of destination fields specified by the plan. This includes destination fields updated by Census via scheduled, triggered and/or manual syncs.

Destination fields are unique per destination, so a field (e.g., active_users_last_30d) synced into two different destinations will be counted twice towards the monthly allocation, however if two different syncs send data to that same field within one destination, it will only count once.

Ideas About Other Gotchas?

We sometimes see permissions being overwritten when running dbt, which rebuilds the table (and sometimes the schema) in the data warehouse. A great way to make sure this does not happen is via . Here is some example code that might go in the post hook:

Or for Snowflake

We are constantly building out this page

Please via support@getcensus.com or start a conversation with us via the chat to let us know what questions we can help with, or something you found out through using Census.

📎
❄️
🚧
dbt post-hooks
contact us
in-app
Salesforce
Try clicking these buttons to pull available fields from the service and source