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.
Started getting this error today when querying data from Athena in a table created from parquet files in our S3 bucket:
![Enter image description...
0
answers
0
votes
97
views
asked a year agolg...
Hi community,
I am trying to perform an ETL job using AWS Glue.
Our data is stored in MongoDB Atlas, inside a VPC.
Our AWS is connected to our MongoDB Atlas using VPC peering.
To perform the ETL...
1
answers
1
votes
436
views
asked a year agolg...
In Redshift, I'm trying to update a table using another table from another database. The error details:
SQL Error [XX000]: ERROR: Assert
Detail:
-----------------------------------------------
...
1
answers
0
votes
236
views
asked a year agolg...
I'm attempting to use AWS Data Pipeline to move a CSV file from my computer to AWS Data Lake as a parquet file. I'm unable to finad the exact template to select to migrate from my local...
0
answers
0
votes
82
views
asked a year agolg...
i want to directly move a csv file from my laptop to aws data lake using aws pipeline?
is it possible to so ? if yes how?
1
answers
0
votes
314
views
asked a year agolg...
Hey,
My ETL Glue job is:
1. reading from Data Catalogue (S3 based),
2. selecting specific fields from the input file (which is json)
2. doing some mapping
3. saving output data to Postgres Aurora...
2
answers
0
votes
330
views
asked a year agolg...
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
1691
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
1289
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
237
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
194
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
55
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
241
views
asked a year agolg...