Time to complete: 5-10 minutes.
We are going to use AWS Cloud9 as our cloud-based integrated development environment. It will get you bootstrapped with the right tools and access for the workshop.
If you already have a Cloud9 environment, feel free to use that.
Expand if you want detailed directions
Create your Cloud9 instance by following these steps:
- Navigate to AWS Cloud9 in the console
- Click Create environment
- Provide a name: FDIWorkshop
- Click Next step
- Leave all defaults
- Click Next step
- Click Create environment
Your AWS Cloud9 environment is being created and your screen will look like this:
After a minute or so, your environment will be ready and you can continue.
- Find the "Welcome" tab and click the plus icon next to it
- Select New Terminal
- Run a command to get the caller identity:
aws sts get-caller-identity
- This command will let you know who you are (account number, user ID, ARN)
Hint: New editors and terminals can be created by clicking the green "+" icon in a circle
Let's get our code and start working. Inside the terminal:
- Run the following command to get the S3 bucket name (that has 'simplebucket' in the name):
TeamRole:~/environment $ aws s3 ls | grep simplebucket 2020-01-07 20:50:06 mod-7c974653c2164bca-simplebucket-1hao8m22eqq93
- Sync artifacts to your bucket
TeamRole:~/environment $ export artifacts=s3://ee-assets-prod-us-east-1/modules/7c974653c2164bcab350d902744088c5/v1 TeamRole:~/environment $ export bucketname=`aws s3 ls | grep simplebucket | cut -d" " -f3` TeamRole:~/environment $ aws s3 sync $artifacts/data/ s3://$bucketname/data/ TeamRole:~/environment $ aws s3 sync $artifacts/scripts/ s3://$bucketname/scripts/
- Sync scripts to local
TeamRole:~/environment $ mkdir -p scripts
TeamRole:~/environment $ aws s3 sync $artifacts/scripts/ scripts
- Verify contents in your S3 bucket, notice Bloomberg EOD price data (as compressed files) exists under <...-simplebucket-...>/data/eod_px/ folder
Expand if you want detailed directions
Check the data contents in S3 by following these steps:
- Navigate to Amazon S3 in the console
- Click on the mod-...-simplebucket-... bucket
- Click on folder data then folder eod_px
- You should notice several compressed files (*.gz) files in there. These are Bloomberg North American Equities End of Day prices in Bloomberg's native format.
At this point we have built our cloud based development environment, verified it is configured with the right credentials, refreshed our S3 buckets and copied down the scripts.
We're ready to proceed with building the data catalog in AWS Glue.