Documentation

    Connectors

    Connectors let Input and Output blocks read from and write to the services your data lives in. Each guide lists what you need on the provider's side, the exact steps and the errors you may see.

    All connectors

    Databases

    ConnectorSign-inReadWrite
    BigQueryGoogle accountYesCreate, Replace, Append rows
    DatabricksPersonal access tokenYesCreate, Replace, Append rows
    MySQLDatabase loginYesCreate, Replace, Append rows
    PostgresDatabase loginYesCreate, Replace, Append rows
    SnowflakeProgrammatic access tokenYesCreate, Replace, Append rows
    SQL ServerSQL loginYesCreate, Replace, Append rows
    SupabaseAPI key and connection stringYesCreate, Replace, Append rows

    Business apps

    ConnectorSign-inReadWrite
    AirtableAirtable accountYesNo
    HubSpotHubSpot accountYesNo
    NotionNotion accountYesNo

    Finance

    ConnectorSign-inReadWrite
    QuickBooksQuickBooks accountYesNo
    StripeAPI keyYesNo
    XeroXero accountYesNo

    Files & storage

    ConnectorSign-inReadWrite
    DropboxDropbox accountYesNew file, or replace a file
    Google SheetsGoogle accountYesSheet: create, Replace, Append rows. File: new, or replace
    HTTPBearer token or noneYesNo
    OneDriveMicrosoft accountYesNew 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

    Local files and Cloud aren't connectors. They need no connection and appear as their own choices on the same blocks: see Input and Output.

    Prepare your data. Build it in Strata.

    Strata opens in your browser, with no account.