Introduction to Notebooks
  • 09 Nov 2022
  • 2 Minutes to read
  • Dark
    Light

Introduction to Notebooks

  • Dark
    Light

Notebooks is the Sisense coding interface that enables data analysts to write ad-hoc queries and easily transform them into visualizations, for rapid and agile exploration.

Watch this video for an introduction to Notebooks:

Using a live connector, Notebooks enables you to test your data or get preliminary results from an ad-hoc SQL, Python or R query before visualizing the data with dashboards. This means that you can enter and execute a query to immediately view the results.

For example, you can run a SQL, Python or R query to find your company’s best selling items. You can join results from queries on different tables to find the top selling product with the highest profit margin and then use Python to make sophisticated profit predictions using advanced code libraries. The result is a table that can then be easily converted to one of several types of graphs. By default, the results are also rendered in a Statistics view as a basic column chart.

notebook_main.png

Limitations

Schema Browser Refresh

To make writing your queries easier, the Schema Browser shows all of the schemas and tables that exist in your database, and the columns within them.

When you connect to a Live data source, new changes are not automatically updated in the Notebooks schema.

To refresh the data, in the Schema Browser, mouse-over the data source and click Refresh.
refresh_button.png

Internet Access

For on-premises instances, access to the internet is required to use Notebooks. Access to the internet is required because the query and code outputs are stored in the Sisense Cloud for up to 30 days. After 30 days, the output table expires until the query or code is rerun from the editor.

Code Limitations

  • Timeout limits:
    • SQL query timeout is 4 minutes by default
    • Code execution timeout is 2 minutes by default
  • Users can change the runtime limits for a notebook by clicking the timer icon on the top right corner of the Notebook editor.
  • Browser memory:
    • Most browsers can only handle visualizations of up to 5MB, so to keep notebooks running smoothly, visualization results are capped. The Limit Rows bar of the SQL editor can be used to control the amount of data visualized, while allowing CSV downloads to include full unlimited result sets. To adjust the number of rows visualized, change the number in the limit box in the query editor.
    • When a code block for Python is added to a chart, the “Limit Preview” setting for charts still only applies to the SQL Output preview. The “Limit Preview” setting does not affect the number of rows or the size of the dataframe sent to the Python script, allowing the code to run on the full result set within a 500MB limit. If the Python code returns over 5MB of data an error will be surfaced, so in those cases a hard-coded limit or aggregation should be added to the SQL or code blocks, (separate from the “Limit Preview” setting).

Was this article helpful?