S3 <> Scispot Labsheets | Scispot Help Center

This page provides the instructions and reference information for setting up the Amazon S3 source connector with Scispot GLUE. It is important to be aware that using cloud storage may result in additional costs for transferring data out of the system, known as egress costs. This includes downloading files or accessing them from a different location. For detailed information on egress costs, please refer to the Amazon S3 pricing guide.

Prerequisites

Access to the S3 bucket containing the files to replicate.

SETUP GUIDE

Step 1: Set up Amazon S3

If you are syncing from a private bucket, you will need to provide your AWS Access Key ID and AWS Secret Access Key to authenticate the connection, and ensure that the IAM user associated with the credentials has read and list permissions for the bucket. If you are unfamiliar with configuring AWS permissions, you can follow these steps to obtain the necessary permissions and credentials:

Log in to your Amazon AWS account and open the IAM console.
In the IAM dashboard, select Policies, then click Create Policy.
Select the JSON tab, then paste the following JSON into the Policy editor (be sure to substitute in your bucket name):

{     "Version": "2012-10-17",     "Statement": [         {         "Effect": "Allow",         "Action": [                 "s3:GetObject",                 "s3:ListBucket"         ],         "Resource": [                 "arn:aws:s3:::{your-bucket-name}/*",                 "arn:aws:s3:::{your-bucket-name}"         ]         }     ] }

Give your policy a descriptive name, then click Create policy.
In the IAM dashboard, click Users. Select an existing IAM user or create a new one by clicking Add users.
If you are using an existing IAM user, click the Add permissions dropdown menu and select Add permissions. If you are creating a new user, you will be taken to the Permissions screen after selecting a name.
Select Attach policies directly, then find and check the box for your new policy. Click Next, then Add permissions.
After successfully creating your user, select the Security credentials tab and click Create access key. You will be prompted to select a use case and add optional tags to your access key. Click Create access key to generate the keys.

CAUTION

Your Secret Access Key will only be visible once upon creation. Be sure to copy and store it securely for future use.

For more information on managing your access keys, please refer to the official AWS documentation.

Step 2: Set up the Amazon S3 connector in Scispot

Login to your Scispot account

In the left navigation bar, click App Store.
Find and select S3 from the list of available apps.
Click on 'Add connector'
Add the following details
1. Access Key ID
2. Secret Access Key
3. Region

FILE FORMAT SETTINGS

Scispot Labsheets only support the CSV import from S3, while labspace supports all sorts of files from S3

Once the S3 setup is complete, you can now easily import data from S3 to Labsheets with a few clicks:

Click on 'Import' on your Labsheets home page
Click on 'Import CSV files from AWS S3'
You will then automatically see all the CSVs from an existing S3 linked to Scispot from the app store

Prerequisites​

SETUP GUIDE​