I submitted my assignment by mistake with out finishing The last part on Jupiter. How ever now when I have gone back to do the assignment I can not start again. IT seems to want to continue on from where I left and I can not find where Jupitor link is after I check for it after the terraform installation files, where it should be. Also now that The AWS console is not resetting, what do I do? do I have to delete data base and instance and then start again. and what about the clock?
Hello @MoyoKwaLee,
If you cannot find the url in the jupyter_output.log, yes you can let the let clock run out of time and you will start from the beginning. Did you try creating a new instance and running source scripts/setup.sh for a new url:
1 Like
okay that seems to have worked. I am now by the jupyter page. How ever I am not sure how to proceed to use Athena. Do I go back into The cloud 9 Environment in AWS and then go back to the root directory and to execute the first past of the Instructions on Jupyter?
Hello,
Yes you can follow the instructions in the md file and come back to jupyter , it is the last part.
The file is not clear. It just says go to jupyter and follow the instructions. How ever, on jupyter is just says Import all packages, but there is no where it says to actually import it. I am not sure where to start this process exactly
Hello @MoyoKwaLee,
First keep that jupyter tab open, we will need it later. Back in the cloud9 have you followed the instructions on the C1_W2_Assignment.md up to 4.11?
If you followed the steps you should see a similar glue job in AWS glue:
Did you run it and got SUCCESS, you shoul be able to import the files in jupyter. Hope it helps
Yes I did and checked if everything was okay in the S3 bucket and the status of the installation on ETL jobs tab in the AWS console under the Glue Studio. All is fine until the Jupyter area. I do not know which tab to go to, to import the python files stated in step one on the instruction found on Jupyter
I think the main issue I know have is where to input those values in Jupyter?
I don’t know where to input this in order to import the files and execute the rest of the instructions. It is not clear
@MoyoKwaLee,
Have you checked the S3 bucket? you should be able to see the 4 star schema tables created in gold folder. You need to import the libraries in the first cell and then you should get this output after you run the second cell:
thank you. I have been to the s3 bucket. It looks like this
So after the last step before we go to Jupyter all is done and then that is the Se Bucket.
Then I go to Jupyter. From there I am lost. I understand what I am meant to do as in import those files. But where I am supposed to carryout the process as in the window, or in the web jupyter environment, or I copy the text and the go back to cloud 9 and run python and install there? This is where I do not know how to proceed?
I will try to explain:
1)Got the url after the command source scripts/setup.sh
2)Run succesfully the de-c1w2-etl-job and created the schema tables
3)This is the last part after you created the de-c1w2-analytics-db and run the queries:
Have you tried to submit in the upper right corner of the lab. You should pass
last time i stopped here i got 70, let see how best to complete a few more steps
Hello @MoyoKwaLee
I guess you failed in the “Creation of S3 Bucket for Amazon Athena Query Results” before. Do you get any output when you run the queries in the jupyter. Post a screenshot of the error, thanks
okay best to submit and try again aftrer the time is done
Hello
Sure you can always click the Start Lab button and refresh the time. I suggest to start from the beginning if you want to cleanup the AWS account and be able to create new de-c1w2-etl-job andde-c1w2-analytics-db from the start
its is done. Thank you
1 Like