Connectors
All connectors
Databases
| Connector | Sign-in | Read | Write |
|---|---|---|---|
| BigQuery | Google account | Yes | Create, Replace, Append rows |
| Databricks | Personal access token | Yes | Create, Replace, Append rows |
| MySQL | Database login | Yes | Create, Replace, Append rows |
| Postgres | Database login | Yes | Create, Replace, Append rows |
| Snowflake | Programmatic access token | Yes | Create, Replace, Append rows |
| SQL Server | SQL login | Yes | Create, Replace, Append rows |
| Supabase | API key and connection string | Yes | Create, Replace, Append rows |
Business apps
| Connector | Sign-in | Read | Write |
|---|---|---|---|
| Airtable | Airtable account | Yes | No |
| HubSpot | HubSpot account | Yes | No |
| Notion | Notion account | Yes | No |
Finance
| Connector | Sign-in | Read | Write |
|---|---|---|---|
| QuickBooks | QuickBooks account | Yes | No |
| Stripe | API key | Yes | No |
| Xero | Xero account | Yes | No |
Files & storage
| Connector | Sign-in | Read | Write |
|---|---|---|---|
| Dropbox | Dropbox account | Yes | New file, or replace a file |
| Google Sheets | Google account | Yes | Sheet: create, Replace, Append rows. File: new, or replace |
| HTTP | Bearer token or none | Yes | No |
| OneDrive | Microsoft account | Yes | New file, or replace a file |
To ask for another connector, use Request a connector under the connector controls in the editor.
How connections work
- Set one up from the Connection dropdown on an Input or Output block. Choose Create new connection, then follow the connector's guide.
- Connections are encrypted and stored by Oplema, and all connector traffic passes through Oplema's servers, even when the rest of your flow runs in your browser. The one exception is Google's file picker, which runs in your browser.
- A connection belongs to your account, not to a project. You can use it in any of your projects.
- Connections are not shared with people you share a project with. The project records which connection a block uses, but only you can use it. Someone else who runs that block must select a connection of their own, or the run fails with
connection not found. - A scheduled run uses the connections of the person who owns the schedule. A published dashboard reads with its publisher's connection.
- Connections made with an account sign-in can be refreshed with the connector's reconnect button, such as Reconnect to Dropbox. Connections made with a key, token or login can't be edited. Choose Delete (the ×) on the row in the dropdown and create the connection again.
Billing
- Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. A failed or cut-off read isn't charged. With no usage left, a read fails once it passes 50 MB, and project viewers (Viewer role) always stop at 50 MB.
- Writes: the first 50 MB of each write is free. After that, each write costs $0.01 per GB from your usage. With no usage left, a write fails once it passes 50 MB.
- Viewers on a project can read within the free 50 MB of each download. Writes need edit access.
- BigQuery, Snowflake and Databricks also charge you for their own compute, separately from Oplema.
If usage runs out, a read or write stops with This transfer exceeds the free 50 MB and the available usage credits. See Billing for who pays on team and shared projects.
Local files and Cloud
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.