Intro to Jupyter Workspaces

Presented by Jae Wilson and Riley Stahura @ Domopalooza 24

Audience

Domo Data Specialists with Intermediate to advanced Python coding experience

Prerequisite Domo University Courses

  • Working with DataSets in Domo
  • Transforming Data in Domo

You can enroll in these courses at any time though Domo University.

Description

Jupyter Workspaces in Domo is a web-based interactive development environment for Jupyter notebooks, code, and data. In this course, you’ll learn how to integrate Jupyter into your Domo data connection and transformation pipeline.

🥅 Learning Objectives

Upon completing this course learners should be able to:

  • Create and run a Jupyter Workspace DataFlow in Domo
  • Integrate input and output DataSets with Jupyter Workspaces
  • Create accounts in Domo for secure programmatic credential access
  • Setup scheduling/triggering for Jupyter Workspaces DataFlows

📋 Agenda

Welcome and Introduction to Jupyter

1300 - Introduction & Workspaces Setup

  • Introductions & Objectives

  • Jupyter and Domo

  • Where is Jupyter located in Domo?

  • Workspace Configuration

  • Optional Configuration Steps

    • Input Datasets
    • Output Datasets
    • Accounts
    • File Share

Jupyter Workspaces Setup

  • ▶️Login at domo-training-jupyter OR domo-community

    • if you need to be domo’ed to the community instance let the TAs know.

  • for training-jupyter:

    • username @domosftware.net
    • password Training!

  • ▶️ Spin up a Jupyter Workspace

  • ▶️ Clone GitHub repo via terminal

    git clone https://github.com/jaewilson07/domopalooza-24.git


Tutorial 1 - Authentication in Domo

  • API request basics
  • token-based authentication
  • network monitoring for API discovery

1400 - Workspace Management

  • Changing Workspace Ownership
  • Enabling Sharing and Sharing a Workspace
  • ▶️ Create a “DomoAccessToken” and “Abstract Credentials Store” account containing userame & password. Share w. JupyerWorkspace
  • ▶️ Add an Output Dataset - “AccountList” to JupyterWorkspace
  • Creating a Jupyter Notebook
  • Left-hand navigation - Files, Input/Output Datasets, Accounts
  • Domo Jupyter Library
    • Reading and Writing to a Dataset
    • Getting Account Credentials

Tutorial 2 & Break - Workspace Management, Working with Accounts & Domo Integration

  • Read Account Objects in Jupyter Workspaces
  • Export a dataframe to a Domo Dataset

1500 - Using DomoJupyter for Automation

  • Trigger from Dataset
  • Trigger on Schedule

Tutorial 3 - Generate a DomoStats style dataset

  • Get Accounts from DomoAccounts and format as a dataset
  • Merging API requests in a dataset

Tutorial 4 - (EXTRA) Access Token Authentication and updating Domo via API

  • generate an access_token and update an Account Object in Domo

1545 - Q&A Wrapup