Questions tagged with Database
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.
Hi everyone,
I upgraded all of my PostgreSQL 11 instances to 15+ earlier this month, but I am still getting AWS emails that begin with "You are receiving this message because you have one or more...
1
answers
1
votes
318
views
asked 5 months agolg...
I have some database on my RDS but suddently when i want to check the database was gone meanwhile i have the record, how it can be happend? is the anyone outside can help me how to recovery the...
2
answers
0
votes
286
views
asked 5 months agolg...
I was connected to mysql using command line with AWS credentials.
I was trying to add some privileges to be able to run a sql script file into the database. I followed some information and run the...
2
answers
0
votes
327
views
asked 5 months agolg...
I am new to Node.js in lightsail.
Can someone help me to get Mysql start in this,How can i connect via tunnel after,I tried find a documentation with no luck,
thanks in advance
1
answers
0
votes
261
views
asked 5 months agolg...
SSIS tasks can be configured on a SQL Server RDS instance. Can a task be created to access an FSx For Windows file share to read files and load into a table?
0
answers
0
votes
1052
views
asked 5 months agolg...
We're using ICEBERG table and we see that each update increase the number of folders and PARQUET files in S3, although data itself wasn't change. Is there an option to compacting and optimizing...
1
answers
0
votes
405
views
asked 5 months agolg...
Hi,
I'm using MERGE INTO with UPDATE on top of ICEBERG.
For example
`MERGE INTO accounts t USING monthly_accounts_update s
ON (t.customer = s.customer)
WHEN MATCHED
THEN UPDATE SET...
0
answers
0
votes
155
views
asked 5 months agolg...
The goal is to create a temp table with consecutive numbers from 1 to 25567.
I tried this SQL statements:
-- Create temp table
DROP TABLE IF EXISTS numbers;
CREATE TEMP TABLE numbers
...
1
answers
0
votes
201
views
asked 5 months agolg...
Using SQL Alchemy ORM to query an AWS athena database. First off, here is the raw SQL query, which is working perfectly
```sql
WITH zi AS (SELECT
trip.start_dt,
address.zone_id
FROM...
1
answers
0
votes
468
views
asked 5 months agolg...
I had a MySQL RDS DB Instance but now I cannot see it supportedpatient.cx71ia97qvpz.us-west-1.rds.amazonaws.com
and I caanot access it.
I had some past due billing for 2 months but I have already...
1
answers
0
votes
204
views
asked 5 months agolg...
I am tring to import data in my sql database manged by light sail, it gives me error of
22:10:33 Restoring saral_lagani_db (annual_report_link)
Running: mysql.exe...
1
answers
0
votes
184
views
asked 5 months agolg...
I wanted to upgrade the mysql engine from 5.7 to 8.0, but I got the error 'The parameter value for lower_case_table_names can't be changed for MySQL 8.0 DB instances.' I've very carefully checked that...
2
answers
0
votes
324
views
asked 5 months agolg...