Amazon Web Services.
Questions tagged [aws]
481 questions
5
votes
2 answers
How to get the records from Amazon Athena for past week only
I am writing a query to get Amazon Athena records for the past one week only. Here is what I wrote so far:
WITH events AS (
SELECT
event.eventVersion,
event.eventID,
event.eventTime,
event.eventName,
event.eventType,
…
Kittystone
- 161
- 1
- 1
- 2
1
vote
1 answer
aws ec2 instance using instance profile role to connect to s3 bucket.. sql server 2022 backup getting operating system error 86
Looking to see if anyone else having this issue. I have a windows server 2019/sql server 2022 ec2 instance that has a instance profile using a role/policy to upload to an s3 bucket. I created a policy to allow to list,read,write etc.. to the s3…
KC_IT
- 11
- 1
1
vote
0 answers
AWS S3 CLI : Check Validate Inside Automatically?
We're using "s3api put-object" and explicitly checking Hash MD5 to make sure the file uploaded to S3 correctly (Unless the upload file is less than 5 GB)
aws s3api put-object --bucket mybucketname --key test.txt --body c:\temp\test.txt…
Sachiko
- 121
- 2
0
votes
1 answer
Does Amazon Web Services (AWS) RDS support locally redundant storage (LRS) for Microsoft SQL databases?
Looking at the documentation for Azure databases I see that they support LRS (local stored in three seperate location) (I'm not interested in GRS) and I was wondering if anyone knew if AWS offered the same functionality? Ideally I just want to…
gg.
- 103
- 2
0
votes
0 answers
Where clause in which the value of column2 changes based on column1
So I have a table which has
State1:
id
column1
column2
1
myboolvalue
false
1
myecogvalue
0
1
myintvalue
1700
State2
id
column1
column2
1
myboolvalue
true
1
myecogvalue
0
1
myintvalue
1700
In this case I want to have a…
user1472972
- 1
- 1