Connecting Notebooks to a Data Source
Notebooks can connect to the following databases:
- Connecting to Databricks
- Connecting to SQL Server
- Amazon Redshift
- Connecting to Snowflake
- Connecting to Google BigQuery - For more information see the section below, Connecting Notebooks to Google BigQuery.
- Connecting to PostgreSQL
- Connecting to MySQL
Note:
Connection to a database must be done through a secure connection, either SSL or SSH.
Connecting to a Database
To connect a database:
- Select a Live connector and enter the connection details.
- After entering the required information, click Next to connect.
- Sisense Notebooks supports SSH for Redshift, PostgreSQL and MySQL database connections. To connect, you must download this Sisense public key.
- Click the Connect to a Private Network and enter the information.
- Click Next.
Connecting Notebooks to Google BigQuery
To connect your Sisense Notebook to BigQuery:
- In your Google BigQuery account, click ADD KEY.
- From the dropdown menu, select Create New Key.
- Keep JSON as the default option and click CREATE. The JSON key file downloads to your computer.
- 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
- Save the JSON file that you downloaded in this directory:
/opt/sisense/storage/connectors/
- Return to your Notebook to create the BigQuery data connection.
- 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
- Click Next.
.r.