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.
I need to construct a complex JSON which replicates the structure of API response using sql query, in order to compare both for testing purpose.
Can/will redshift support JSON functions (such as...
1
answers
0
votes
354
views
asked 4 months agolg...
I am using a cross-region global Aurora Serverless v2 cluster for my PostgreSQL database.
Now it could be, that there are multiple connections from multiple services to it.
My question is now,...
1
answers
0
votes
424
views
asked 5 months agolg...
My server calls are taking almost a minute to complete. The server call in question is a simple select ~100 rows from a single table and order them. I'm seeing a number like 18449.83 avg latency on...
1
answers
0
votes
279
views
asked 5 months agolg...
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
311
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
278
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
313
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
256
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
1048
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
390
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
148
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
196
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
461
views
asked 5 months agolg...