AWS GLUE JOB NOT DETECTING SCHEMA IN PYTHON SCRIPT
1
Hi,
I have created a new AWS Glue visual ETL job with source- PostgreSQL, target- Snowflake.
Output schema option shows correct schema as per the source, but the python script shows all the datatype as VARCHAR and the target snowflake table all columns are created with datatype - VARCHAR. Please let me know if there is any option to auto detect the schema in python script.
2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Seems that's a limitation of that target node, I've opened a ticket to request that it honors the schema.
0
Workaround found : "Just" change the python script manually to fix the output data type
répondu il y a 3 mois
Contenus pertinents
- Réponse acceptéedemandé il y a un an
- demandé il y a un an
- demandé il y a un an
AWS OFFICIELA mis à jour il y a 3 ans- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a un an
Is there a way to transfert data using a script without losing the data type ? Do you have the link of the ticket you speak about?