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.
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
280
views
asked a year agolg...
I signed up for the free trial, however, while trying to run ETL Jobs for learning, I was charged for AWS Glue Jobrun. It was a mistake since it is a thing that I cannot oversee. I tried to run the...
2
answers
0
votes
302
views
asked a year agolg...
I am using Data Quality to evaluate the dataset and I am routing the failed rules and failed records. But when i check the s3 bucket for the failed records i am seeing empty files along with the...
0
answers
0
votes
121
views
asked a year agolg...
Hi, I'm running a data pipeline from legacy DB(oracle) to Redshift using AWS Glue.
I want to test the connection to the legacy DB before executing ETL without test query in working python...
1
answers
0
votes
289
views
asked a year agolg...
Can't load the datalg...
Can't load the data from server and what can I do now ?
1
answers
0
votes
190
views
asked a year agolg...
I am trying to create an insert into statement which queries a source table, which has a column containing a STRUCT data-type. This table is automatically created via crawler and the column definition...
1
answers
0
votes
517
views
asked a year agolg...
I've been setting an AWS Glue test environment in which business users should use tables available in Glue catalog as data sources for their Glue jobs. The tables in the catalog come from data marts...
2
answers
0
votes
1256
views
asked a year agolg...
Hello,
I have a Glue Pyspark job that writes to Amazon S3 in a CSV format, I don't see any file with CSV extension on Amazon S3. How can see it ?
I am using `write_dynamic_frame.from_options`...
3
answers
0
votes
303
views
asked a year agolg...
Hi!
I'm having some issue processing a DynamoDB export in Glue. It looks like my schema is breaking DynamicFrame's unnestDDBJson transformation.
This is the minimal test case that will trigger the...
1
answers
0
votes
458
views
asked a year agolg...
Using the step: "Derived Column" where I can use SQL functions to derive new columns I found SUBSTRING works but CHARINDEX it doesn't. And as usual with AWS documentation, there's no place or...
1
answers
0
votes
384
views
asked a year agolg...
Hi there,
I have an AWS Glue Pipeline where I am reading data from an RDS Postgres instance and copying data over into a RedShift warehouse. I have noticed that when using the "MERGE" operation, that...
1
answers
0
votes
786
views
asked a year agolg...
I am new to AWS Glue and I am encountering an issue while trying to use the "google bigquery connector 0.24.2 for aws glue 3.0" in an AWS Glue Job. The goal is to establish a connection between my RDS...
1
answers
0
votes
323
views
asked a year agolg...