Connecting Notebooks to a Data Source
  • 19 Jul 2022
  • 1 Minute to read
  • Dark
    Light

Connecting Notebooks to a Data Source

  • Dark
    Light

Connecting to a Database

Notebooks can connect to the following databases:

  • Amazon Redshift
  • Snowflake
  • Posgres
  • MySQL
  • BigQuery
Note:

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

To connect a database:

  1. For Snowflake and Redshift, prepare your data warehouse by following the relevant instructions to set up security groups, network policies and user permissions.
    Preparing your Redshift Data Warehouse
    Preparing your Snowflake Data Warehouse
Note:

When you are preparing the data warehouse, do not create the sisense_views schema and the sisense_write user permissions.

  1. If the database is private or behind a firewall, enter the following IP addresses in the whitelist for Notebooks to connect:
    The Sisense Cloud IPs: 54.186.74.45 and 54.187.196.247
    The public IP address specific to a deployment. Contact your CSM or the Support Team for this IP.
  2. Select a Live connector and enter the connection details.
    For more information about connecting to your data source, see the following:
    Connecting Sisense Notebooks to BigQuery**(TBD)**
    Connecting to MySQL
    Connecting to Redshift
    Connecting to Snowflake
  3. After selecting the database type, enter the required information and click Next to connect.

add-connections.png

  1. Sisense Notebooks supports SSH for Redshift, PostgreSQL and MySQL database connections. To connect, you must download this Sisense public key.
  2. Click the Connect to a Private Network and enter the information.
  3. Click Next.

Connecting Notebooks to Google BigQuery

This topic describes how to connect your Notebook 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
  1. Click Next.

Was this article helpful?