Census changelog
Census changelog

🧑‍💻 Create syncs programmatically via POST /syncs API




We’ve extended the Census API to support creating syncs programmatically.

👉 Read the API docs to learn more.

📁 New destinations: S3 and SFTP





Schedule secure data exports from your warehouse to CSV files in your S3 buckets or your SFTP server.

👉 Learn more about S3 or STFP on the docs

⏲️ Customize your schedule down to the exact hours and days with Cron




2021-10-21 22.07.51 cron schedule.gif

Want to schedule syncs to run hourly on weekdays only? Or how about once every four hours? You can now specify your sync schedule with incredibly granularity using a Cron expression.

👉 Read the docs to learn more.

⚡ More powerful sync field configuration




If you’ve created or edited syncs lately, you’ve probably noticed some changes in the user experience.

Customize sync behavior down to the field

For update and create syncs, you can choose to customize sync behaviour per field. For example you can choose to only set a field value if the existing field is empty, rather than always overriding the existing value.

2021-10-24 23.47.32 sync field config.gif

We’ve flipped the mapper

We’ve flipped the mapper UI so database columns are on the left and destination fields on the right to make it easier to understand the data flow.

👉 We want your feedback! Ping us via chat, on slack or shoot us an email with your thoughts.

➕ Set and forget, automatically add new fields to syncs if they appear in the model

Census Sync 10_2021_inline_01.png




You can now select “Sync all properties” when setting up your sync, and Census will automatically create any new field added to your model or table as a new field in the destination. You can even choose the naming case for the field name you want Census to create (e.g. UPPERCASE, CamelCase etc).

Note: This is only supported for destinations that allow creating new fields via Census.

👉 See all supported destinations on the docs

Connect to Read-only data sources

Census Sync 09_2021_04.png




We know getting additional permissions approved from your security team can slow you down.

That’s why you no longer need to give us write permission to get started connecting your warehouse! Just plug in your existing read-only credentials to get started in Read-only Mode.

Note: Read-only Mode will have some limited functionality, like not supporting incremental syncs (every sync will be a full sync). But they’re a fast way to get started without needing extra permissions from your security team, or to connect to sources that you aren’t able to write to, such as replicas of production databases.

👉 Get started with by creating a new connection in Read-only Mode or check out the docs on how to connect to your warehouse.

🚥 Avoid alert fatigue, set thresholds for invalid record alerting





In addition to choosing to receive alerts for invalid or rejected records you can also specify the threshold you want to be alerted on.

So that you don’t miss anything important, this alert will now default to on for all syncs if over 75% of the records from the source are invalid or rejected by the destination.

You can set this trigger threshold to be lower or even any for those syncs you want to keep an extra eye on.

👉 Read the docs to learn more on alerts in Census.

⏸️ Cancel running syncs




Realized something was wrong or you forgot to update something? You can now hit pause during an actively running sync and choose to cancel the job. This will also pause the schedule so the sync won’t attempt to run again until you hit “Resume”.

🆕 A new shortcut to set values directly in your syncs with "Constant values"




Census Sync 09_2021_05.png

Shhhh! Don’t tell anyone, but we know there are times when it’s not convenient to have all the data in your model. For example, setting up new audience names or setting that pesky required field “subscribed” in Mailchimp.

We now let you easily set a “constant” or static value in your sync, so you don’t have to go and add that value into your model.

To get started, simply select “Constant value” in the mapper for your field and type the value you want to set.

👉 We'd love to know what you think of this feature in the chat, or by shooting us an email.

💬 New destination: Freshdesk




Changelog_ Freshdesk.png

They’ve just gone public, and so has our integration! Operationalize your customer support by automating support ticket prioritization with product usage data in Freshdesk.

👉 Get started in the Census app now or contact us with any questions.