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.
Hello, I am running a job to apply an ETL on a semi-colon-separated CSV on S3, however, when I read the file using the DynamicFrame feature of AWS and try to use any method like `printSchema` or...
1
answers
0
votes
1761
views
asked a year agolg...
Is there a way to query a Microsoft SQL Server programmatically in a python job shell in AWS Glue?lg...
We have been able to connect to a Microsoft SQL Server DB using both Glue's DynamicFrame and Spark's own JDBC write option due to the Glue connection option. However, considering the transactional...
1
answers
1
votes
1312
views
asked a year agolg...
Hello
I have JSON files for jobs created and extracted from Amazon transcribe and I need to add it to cloud formation stack of PCA
so I found that on my PCA(post call analytics) dashboard there is...
1
answers
0
votes
246
views
asked a year agolg...
Aws interface issuelg...
I am trying to download a dataset from S3 bucket using aws interface.
I have the security code and other details.
But when I type the code for downloading the data, I get an error.
I am not even...
1
answers
0
votes
198
views
asked a year agolg...
```
2023-03-10 03:52:55,572 ERROR [stream execution thread for [id = bea7911a-d787-44e1-836b-8488a43e16ea, runId = ba5fb563-91a6-4d39-befb-f740a9be9a08]] streaming.MicroBatchExecution...
0
answers
0
votes
56
views
asked a year agolg...
Error to view tablelg...
After using a crawler to create a table it shows the following error which I don't know how to fix.
![Error](/media/postImages/original/IMr9UNFbk4Q-qth24BoQLcPQ)
1
answers
0
votes
254
views
asked a year agolg...
Hi,
I have noticed that when running the DataBrew recipe job for data masking, the job is failing when the parquet file has a single record in it.
The error is following:
> "Exception: Error: Unable...
1
answers
0
votes
519
views
asked a year agolg...
New to glue and athena.
I have a great toy example by an AWS community builder working. But in my real use case, I want to capture all the fields from an eventbridge event 'detail' section and...
1
answers
0
votes
222
views
asked a year agolg...
Trying to surface daily csvs in S3 in Redshift via AWS Glue Studio but databases aren't showing uplg...
I am trying to use the AWS Glue Studio to build a simple ETL workflow. Basically, I have a bunch of `csv` files in different directories in S3.
I want those csvs to be accessible via a database and...
1
answers
0
votes
220
views
asked a year agolg...
Hi All,
I have some issues when running my glue job, I landed my pipe delimited csv file in a s3 bucket and after running the crawler pointing to the folder where the file is placed, a glue catalog...
1
answers
0
votes
1617
views
asked a year agolg...
Looking for a little insight on this:
ETL job fails with the following error: “Connection reset on https://xxxxxx.com:9200 https://xxxxxxx.com:9200"
Basic information:
*ETL job is pulling data...
1
answers
0
votes
214
views
asked a year agolg...
Hey Guys!
I am trying to Read a large amout of data(About 45GB in 5.500.000 files) in S3 and rewrite in a partitioned folder (In another Folder inside the same Bucket) but I am facing this...
1
answers
0
votes
445
views
asked a year agolg...