Wednesday, 26 July 2023

AWS

AMAZON ELASTIC COMPUTE CLOUD (EC2) is a part of Amazon.com's cloud-computing platform, Amazon Web Services (AWS), that allows users to rent virtual computers on which to run their own computer applications.

AMAZON S3 or AMAZON SIMPLE STORAGE SERVICE is a service offered by Amazon Web Services (AWS) that provides object storage through a web service interface.


LOGIN/CONNECTION ESTABLISHMENT


setx AWS_ACCESS_KEY_ID AKIAV7UQG7Q7C2OKGSM

setx AWS_SECRET_ACCESS_KEY I1DCBC3nwsRcV8+KSMSOLJMr1aZ8EzID

setx AWS_DEFAULT_REGION us-east-1


LIST FILES

aws s3 ls s3://abc/files/


COPY FILES

aws s3 cp F:\run.bat s3://abc/files/


DELETE FILES

aws s3 rm s3://abc/files/run.bat


Sample URL for file download

https://s3.amazonaws.com/abc/xyz.txt

DBT - Models

Models are where your developers spend most of their time within a dbt environment. Models are primarily written as a select statement and ...