Questions tagged with S3 Select
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Issue with Athenalg...
Getting the below error
SYNTAX_ERROR: line 1:15: Schema ecommerce-raw-apsouth1-84245-dev does not exist
This query ran against the "" database, unless qualified by the query. Please post the error...
1
answers
0
votes
563
views
asked 2 years agolg...
I am trying to query data in my own account and am getting the following error:
```GENERIC_USER_ERROR: Cannot execute query. User in account <account id> is not authorized for any columns in table...
1
answers
0
votes
294
views
asked 2 years agolg...
I'm getting errors for a variety of attempts to read my S3 backup for DynamoDB.
The data looks like...
1
answers
0
votes
841
views
asked 2 years agolg...
Let's say I have an existing DynamoDB table and the data is deleted for some reason. I have a backup of the table in AWS Backups as well as an export of the table data in S3 in DynamoDB JSON or Amazon...
3
answers
2
votes
15111
views
asked 2 years agolg...
I need to Publish 1 file in Topic messaging service , that will be send to all subscriptions. Can you suggest what AWS service help me achieve this usecase? Approx file size 1MB to 5MB. I am not...
1
answers
0
votes
355
views
asked 2 years agolg...
I have a situation where the DB has a primary key field say "id" with an autoincrement or UUID auto generations field. I am using AWS RDS Postgres database.
Options 1 (Preferred) - The CSV I want to...
0
answers
0
votes
142
views
asked 2 years agolg...
I try to download image(.jpg, .png.) from S3 to Endpoint(made by Sagemaker) with s3url(s3://~~)
Because At the endpoint made by sagemaker, To send s3url is faster than to send image.
I can download...
1
answers
0
votes
646
views
asked 2 years agolg...
Hi,
There is an S3 Inventory I can access only using Redshift. I cannot access it from S3.
All the records from this Inventory follow the same pattern:
If the Key has this structure (which I...
Accepted AnswerS3 Select
2
answers
0
votes
953
views
asked 2 years agolg...
I have hosted video on aws s3 , i have took link of that and added to my wordpress website . But video loading only once . Next time it keeps bufferring
2
answers
0
votes
270
views
asked 2 years agolg...
An offshore team is dumping daily raw data from a SQL instance (.sql.gz zipped files) into an s3 bucket in my org. Task at hand is to import this data into a MySQL RDS instance, query the instance,...
1
answers
0
votes
714
views
asked 2 years agolg...
Running below standard query:
*****SELECT table_name, COUNT(*)
FROM information_schema.columns AS columns_number
where table_name like '%appl%'
GROUP BY table_name
ORDER BY 1 desc ;*****
It gives...
1
answers
0
votes
534
views
asked 2 years agolg...
I have 5 Batch jobs running on AWS Batch with Fargate,
when it was running I noticed the capacity to S3 spiked through the NAT Gateway.
I queried VPC Logs using Athena and found that the destination...
1
answers
0
votes
324
views
asked 2 years agolg...