Technical Documentation and Contact Information

The following sections provide technical resources for SDC users.

Architecture Diagram

SDC Service Desk > RT Guide: Appendix B, Technical Documentation and Contact Information > image-20210915-153651.png

Workstation Details

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

Note Versions are subject to change

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.

Useful Links

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