In this guide, we will show you how to connect Slack to Census and create your first sync.
Have your Census account ready. If you need one, create a Free Trial Census account now.
Have your Slack account ready.
In the Connections page in Census, click the Add Service button under the Service Connections section, and select Slack.
If you are not already logged in to Slack, you will be redirected to a page to log in to Slack to authorize your account to use Census. Once you are logged in, you'll see a page like the image below, confirming you want to authorize Census.
Once you've authorized Census, you'll be redirected back to the Connections page in Census and you should see your Slack connection there.
See our docs for each supported data source for further information:
Navigate to the Models page in Census and click the Add Model button.
Here you can a write SQL query to select the data you want to send to Slack.
Once you have created your model, give it a useful name, and click Save Model.
Navigate to the Syncs page in Census and click the Add Sync button.
Follow the instructions below as you go through each section:
For Connection, select the data warehouse you connected in step 2.
For Source, select the model you created in step 3.
For Connection, select Slack.
For Object, select the Slack channel you would like to sync data to.
Pick the column that uniquely identifies each record in your data source. Census will use this to identify new records that need to be synced to Slack.
Select the additional fields you want to sync to Slack using Add Mapping.
If you want to quickly select all the fields from your model in step 3, click on the Multiple dropdown and select All From Source.
Since Append is the only sync behavior option available for Slack, you can decide if existing records in source should be sent to destination.
Click the Run Test button to test whether your sync successfully sends a single record from your data source to Slack.
Click the Next button to see the final preview of the sync settings. If you selected Skip Current Records in the Should existing data be synced? section, it should look something like this:
To run the sync now, select the Run a sync now? checkbox and click the Create Sync button. Your sync is in now progress!
In Slack, go to the channel that you set up the sync to.
If everything went well, you should see your data there:
any unique field