RT Guide: Appendix B, Technical Documentation and Contact Information

Owned by Pallavi Mehta
Last updated: 19 Apr 2022 by Jeff Ussing

Technical Documentation and Contact Information

The following sections provide technical resources for SDC users.

Architecture Diagram

Workstation Details

Workstation Type

Type

Workstation Type

Type

Windows Workstation

t3a.medium

Note: Workstation size and type can be increased upon user request. Please refer to the Resize Workstation section under https://securedatacommons.atlassian.net/wiki/spaces/DESK/pages/2225405986/RT+Guide+Chapter+3+Accessing+and+Launching+Workstations#Resize-Workstation for instructions.

Tools and Versions

Note Versions are subject to change

Tool Name

Version

Tool Name

Version

Python

3.8.10

Cyberduck

7.10.135318

7-Zip

1900x64

Javelin PDF Reader

 

Notepad++

8.1.3

Git

2.33.0

Git Extensions

3.5.3.12551

Meld

3.20.4

Google Chrome

 

JDK (JAVA)

15.0.1

LibreOffice

7.2.0_Win_x64.msi

Putty

.76

R

4.1.1

RStudio Desktop

1.4.1717

SQL Workbench

Build 127

Anaconda

3-2021.05

KeePass

2.48.1

Contact Information

The best way to contact the SDC Support Team is via the SDC Service Desk.

Sign Up or Login to the Service Desk.

The SDC Support Team can also be reached at sdc-support@dot.gov.

  • S3
    Amazon Simple Storage Service, a place to store data.

  • Redshift
    A database system, which can be queried with SQL.

  • Hive
    The Apache Hive™ data warehouse software facilitates reading, writing, and managing large datasets residing in distributed storage and queried using SQL

AWS S3 CLI Commands

The following are a list of helpful commands to work with S3 from the terminal.

In these commands, ‘local’ refers to the user’s SDC workstation (EC2 instance). The listed commands can only be used from within the user’s workstation environment.

  • List objects in a bucket
    If there are any files at the bucket level, then this command will return the list of files. If there are only folders/prefixes under the bucket, then it will return the top level folder/prefix names of that bucket. Keep in mind, if you try to list objects that you do not have access to, you will get an access denied error.
    aws s3 ls s3://<bucketName>

  • List objects under a folder/prefix
    This command will list all the objects/files under that folder or prefix.
    aws s3 ls s3://<bucketName>/<prefix>/

  • Copy a local file to S3
    This command will copy a local file (test.txt) from your workstation over to an S3 bucket:
    aws s3 cp test.txt s3://<bucketName>/test.txt

  • Copy an S3 object to a local file
    The below command copies an S3 object to your workstation.
    aws s3 cp s3://<bucketName>/test.txt test.txt

Notification Service

Please see the documentation and example code on SDC’s GitLab: https://gitlab.prod.sdc.dot.gov/Commons/notification-service