Without leaving the AWS CLI, you can create or delete a bucket after you have the necessary permissions to read and write S3 buckets. Using
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Create S3 Bucket from AWS / EC2 / Jump Server
Without leaving the AWS CLI, you can create a bucket after you have the necessary permissions to read and write S3 buckets. Using your EC2
Copy or Move files from EC2 to S3 Bucket
The following command helps in copying or moving the files from Jump Server / EC2 instance to the S3 bucket. To move file from EC2
FIND_IN_SET function in MySQL
If a string is found in a string list with N substrings, the “Find in set” function returns a value in the “1 to N”
DATEDIFF_BIG Function in SQL Server
This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
MongoDB Cloud in Navicat – Connection Failed
It was described in my previous post how to connect to the MongoDB Cloud in Navicat. If you are having trouble connecting, your IP address
Big Data & SQL 