Step 1: Navigate to the Studies page and click on the Organization tab. Mount your study(ies) to your workspace.
The organization studies are linked to Amazon S3 secure storage. This means that anything saved in these study folders will be securely saved and accessible through any workspace the study is mounted to.
To mount a study to your workspace, check the box next to the study name.
For more information about studies, view the documentation here.
Step 2: Select the SageMaker compute platform.
Step 3: Set your workspace parameters.
Name: Any name. Note that the Name can contain only alphanumeric characters (case sensitive) and hyphens. It must start with an alphabetic character and cannot be longer than 128 characters.
Restricted CIDR: No change necessary
Project ID: Select your AIM AHEAD affiliation, for example Research-Fellowship or Consortium-Development-Project
Configuration: sagemaker-small
Description: Any description. Note that the Description must be at least 3 characters.
Step 4: Provision your workspace.
This may take 12-20 minutes.
Once your workspace is listed as AVAILABLE, you can connect to it.
When you are finished working on your workspace for the day, please STOP the workspace to avoid incurring excess cloud costs.
Connecting your project database
Step 1. Connect to your SageMaker workspace.
Click "Connections" and then "Connect". A new window will open with your SageMaker workspace.
Step 2. Open the SageMaker Examples tab.
Step 3. Copy the Access to Data and Compute using Service Workbench folder.
Click "Use" next to any of the notebooks under "Access to Data and Compute Using Service Workbench" and then "Create copy". This will copy the entire example folder to your workspace.
Step 4. Move the OCHIN example code notebooks into your study folder.
Note: these example notebooks are also located on GitHub.
When you first copy the examples, a new window will open with the notebook you copied.
If you see a popup that says "Kernel not found", select conda_python3 from the dropdown menu and click "Set Kernel".
Close out of that tab and navigate back to your Home Page.
Click on the Files tab of your Home page. You will notice the example code folder has been added.
Check the box next to the Access to Data and Compute Using Service Workbench folder and click "Move".
For the directory path, type /studies/ followed by the name of the study folder you linked to your workspace. Click Move.
Using R and python to access tables in your project database
The R and python example notebooks contain all the steps needed to connect to the OCHIN Database.
