Questions tagged with Extract Transform & Load Data
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.
My AWS glue job is configured to extract data from one rds postgres DB and insert it into another one (after some transormations).
Although the job completes "succesfully", I can't see any data i the...
1
answers
0
votes
540
views
asked 10 months agolg...
I would like to adopt Iceberg tables for easier data management in the data lake but we have a dependency on Redshift Spectrum and it seems that Amazon is not planning on supporting Iceberg in...
1
answers
0
votes
422
views
asked a year agolg...
Hello, I have a table with a lot of daily sales in QuickSight. I have grouped the table by daily date and created two more columns: daily sales for this year using the formula = sum(ifelse(date =...
1
answers
0
votes
211
views
asked a year agolg...
Hi,
**Problem statement:** Currently if we're running a query with multiple temporary tables and want to rerun the whole query without errors, it is necessary to drop the temporary tables. Usually...
1
answers
4
votes
229
views
asked a year agolg...
I'm using aws glue's visual etl builder to extract data from one rds postgres DB, transform it, then insert it into another rds postgres db (similar business entities but different schema).
The...
2
answers
0
votes
1092
views
asked a year agolg...
What are the pros and cons when it comes to using **AWS Glue** over Redshift's internal functions (such as **COPY** and **INSERT**)? for bulk data loading (In terms of **cost, time, and...
1
answers
0
votes
381
views
asked a year agolg...
I'm building a glue job for a data migration with schema changes and mappings between two RDS postgres DBs.
I'm getting an error connecting to glue apis.
```
AnalysisException:...
1
answers
0
votes
305
views
asked a year agolg...
Trying to write to my OpenSearch cluster
"An error occurred while calling o265.pyWriteDynamicFrame. Connection error (check network and/or proxy settings)- all nodes failed; tried...
1
answers
0
votes
417
views
asked a year agolg...
using aws for data visualization using custom python scripts and the best database for the usecase.lg...
I am sending data into kinesis data streams and thinking of using firehose to send data into Redshift, i want to use this database to run custom Python scrips to visualize data.
1
answers
0
votes
331
views
asked a year agolg...
Hi everyone, I was trying to ingest csv data to Timestream Db with AWS SDK boto3.M y credential , region , Database_Name, Table_Name are all correct but still I am unable to connect to endpoint of my...
0
answers
0
votes
84
views
asked a year agolg...
Json data is being considered as string while loading data from postgres to json file by AWS Gluelg...
I want to migrate postgres data to redshift, but I have a lot of jsonb data in postgres so for that I had given SUPER data type in Redshift but the problem here is while loading the data to redshift...
1
answers
0
votes
1027
views
asked a year agolg...
The setup we currently have is a kafka cluster with various topics; 1 topic per data structure, and a default consumer that runs on all of these topics. The consumer simply takes the persisted data...
2
answers
0
votes
276
views
asked a year agolg...