Monday, 23 August 2021

AWS - Useful commands

 LINUX Command to connect AWS using KEYS,


export AWS_ACCESS_KEY_ID=AKIAAAAUQG7QC2O4KS6NKGSM; 

export AWS_SECRET_ACCESS_KEY=I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS;  

aws s3 ls s3://kgsm/active/

s3://kgsm/raw

s3://kgsm/active



WINDOWS Command to connect AWS using KEYS,


setx AWS_ACCESS_KEY_ID AKIAV7UQG7Q7C2O4KS6NKGSM

setx AWS_SECRET_ACCESS_KEY I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS

setx AWS_DEFAULT_REGION us-east-1

aws s3 ls s3://kgsm/active/


WINDOWS Command to CREATE NEW FOLDER IN AWS and UPLOAD THE FILE


aws s3 cp F:\run.bat s3://kgsm/active/a1/

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 ...