Step 3: Add a Connection

Add a Database Connection

To add a database, select the relevant database from the list of connectors. Once chosen, click on the '+' icon associated with the selected database.

You will be prompted to provide the following details:

  1. User*

  2. Account*

  3. Database*

  4. Password

  5. Schema

  6. Role

  7. Warehouse

  8. Passcode

  9. Authenticator

  10. Private Key Path

  11. Private Key Passphrase

  12. Max Chunk Download Workers

  13. Custom JSON Decoder Enabled

  14. Copy Method

Once the necessary details have been entered, click 'Connect Database' to establish the connection.

Note: Fields marked with an asterisk (*) are mandatory. Input requirements may vary depending on the database selected.

Add a Cloud Storage Connection

For cloud storage services, follow a similar process. Choose the relevant cloud storage option, click on the '+' icon, and provide the required information:

  1. Container*

  2. Account*

  3. Shared Access Signature URL

  4. Connection String

Once the necessary details have been entered, click 'Connect Database' to establish the connection.

Note: The required fields may differ depending on the cloud storage provider you're connecting to.

Add a File

  1. Go to the File tab, located below the Database category.

  1. Click on the Upload File button. A prompt will appear for you to select a file from your local machine.

    Supported File Types:

    • .csv

    • .xlsx

    • .json

    • .parquet

  2. Once your file is selected, click Upload File again to finalize the upload.

Last updated