Connecting Notebooks to a Data Source

Notebooks can connect to the following databases:

Note:

Connection to a database must be done through a secure connection, either SSL or SSH.

Connecting to a Database

To connect a database:

  1. Select a Live connector and enter the connection details.
  2. After entering the required information, click Next to connect.
  3. Sisense Notebooks supports SSH for Redshift, PostgreSQL and MySQL database connections. To connect, you must download this Sisense public key.
  4. Click the Connect to a Private Network and enter the information.
  5. Click Next.

Connecting Notebooks to Google BigQuery

To connect your Sisense Notebook to BigQuery:

  1. In your Google BigQuery account, click ADD KEY.
  2. From the dropdown menu, select Create New Key.
  3. Keep JSON as the default option and click CREATE. The JSON key file downloads to your computer.
  4. Open the Sisense File Manager. To do so, enter your Sisense URL into your browser and append /explore to the end.
    For example: https://site_name.sisense.com/app/explore
  5. Save the JSON file that you downloaded in this directory:
    /opt/sisense/storage/connectors/
  6. Return to your Notebook to create the BigQuery data connection.
  7. In the Service Account Key Path field, enter the full path of the BigQuery JSON file you saved:
    /opt/sisense/storage/connectors/[bigquery_key_file].json
    For example, if you saved the JSON file as bigquery_creds, the path would be:
    /opt/sisense/storage/connectors/bigquery_creds.json
  8. Click Next.

.r.