Connecting data starts with picking your source. We support a growing list of connectors that includes billing and productivity tools, databases, CRMs, and more. If you don’t see the connector you need let us know.
Once you’ve picked your Connector, you’ll need to configure it. Connector settings vary greatly but the common ones are:
Connector name — This will also be the resulting Dataset name. A Connector can create multiple Tables but only one Dataset.
Authentication — This is different per Connector, but we support OAuth, API keys, and access tokens depending on what the source calls for.
What data to sync — Most Connectors allow you to choose the tables or files that contain the data you care about.
How often to sync — Each Connector has a sync interval, which determines how frequently we retrieve new data.
With your settings entered, press Sync and we will test your connection. If we can’t connect, you’ll see error information provided by the source. These errors can be a bit cryptic, if you are having any issues at this stage, please reach out.
After the Connector setup tests pass, your Connector will begin syncing and you’ll be taken to the Connector’s page. Initial syncs can take longer because they may be retrieving a significant amount of historical data. Future syncs will only get new data if available.
Your Connector will continue to sync on the schedule you selected. You can change the Connector’s settings at any time on your Connector’s page.
Once your sync is done, check your Warehouse for your new Dataset and start Querying.
See a full list of our supported connectors here.