ALTER TABLE table_name OWNER TO new_owner; ALTER TABLE table_name RENAME TO new_name; ALTER TABLE table_name ADD column_name column_type; ALTER TABLE
Continue reading
ALTER TABLE table_name OWNER TO new_owner; ALTER TABLE table_name RENAME TO new_name; ALTER TABLE table_name ADD column_name column_type; ALTER TABLE
Continue readingunload (‘SELECT * from schemaname.tablename’)TO ‘s3://bucketname/filename’credentials ‘aws_access_key_id=XXXXXX;aws_secret_access_key=XXXXX’DELIMITER ‘|’allowoverwriteESCAPE; copy schemaname.tablenamefrom ‘s3://bucketname/filename’credentials ‘aws_access_key_id=XXXXXX;aws_secret_access_key=XXXXX’DELIMITER ‘|’ESCAPE;
Continue readingCREATE USER username PASSWORD ‘password‘; CREATE USER username PASSWORD ‘password‘ CREATEDB; CREATE USER username PASSWORD ‘password‘ CREATEDB CREATEUSER; CREATE USER
Continue readingWhen you first create an AWS account, you are required to provide an email address that uniquely identifies your account
Continue readingCloudFront is Amazon’s content delivery network (CDN) service that quickly and securely delivers your content to end users all around
Continue readingPRIVATE IP Every EC2 instance that is launched is assigned a primary private IP address from the address range of
Continue readingBy default, all S3 buckets and objects are private and only the account that owns the objects has permissions to
Continue readingElastic IP is a public static IP that is associated with your AWS account. You can associate it to any
Continue readingAn application running on EC2 instance that needs access to S3 requires credentials. You can distribute credentials to the app
Continue readingSteps: Create S3 bucket Upload index.html and error.html to the S3 bucket Enable website hosting on the bucket Add bucket
Continue reading