- Quick Start
How to set up a connection with Bracket
Bracket lets you connect popular tools and backend databases for two-way or one-way syncs. In this guide, we’ll talk through how to get everything connected in a few quick steps.
1. Prepare your data sources for the sync
The prerequisites for a successful sync are:
- Both data sources exist and have at least one field
- Both data sources have a unique key
- The secondary data source is empty of data
2. Create an account on our web app
Bracket web-appSet up your syncs here
3. Enter connection details for each data source
On the web app, you’ll need to enter certain connection details to get syncs running. See below for a summary of what information you’ll need.
|Data source||What you’ll need|
|Airtable||An existing Airtable base|
|Notion||An existing Notion database|
|Google Sheets||Share Sheet with Bracket service account and get the Sheet ID|
|Postgres||Connection string URI|
|MongoDB||Connection string URI with Bracket as added user and whitelisting IP address 0.0.0.0/0 or Bracket’s dedicated IP addresses|
|Snowflake||Login credentials and details about the warehouse / table to be synced|
4. Choose your sync direction
Choose a one-way or two-way sync. If you’d like to customize the sync so that certain fields are one-way and others are two-way, just ping us.
5. Review the fields to be synced and choose sync frequency
After clicking “Review,” you’ll be taken to the admin page for the newly created connection
Before you initiate the sync, you should:
- Make sure the field names and intersection types are accurate
- Verify that the field names for each data source have appropriate capitalization, spaces, etc.
- Verify that
INTERSECTION TYPEis accurate. You can figure out the appropriate intersection type here
- Update the sync frequency as needed. See the different sync frequency options by plan here
6. Initiate sync
Active to begin the sync. Refresh the page and scroll to the bottom to verify that a sync job has been planned.
You can also test the sync without writing data (before or during a sync) by clicking “Test run” on the Job History section.