1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
Glue can definitely be used for loading dimensional data into Redshift. Approach will depend on what kind of dimension it is (SCD Type). And you can certainly generate surrogate ids in Glue. Example: I have used this in the past.
def customer_id(custid):
x = int(str(hashlib.md5(custid.encode()).hexdigest()[:10]),16)
x = int(x)
return x
However, make sure you follow the logic consistently across different datasets to produce consistent surrogate ids.
Ideally, a staging table should be present and from staging to main table, you can govern the logic through redshift procedure or plain SQL depending upon the complexity.
répondu il y a 4 ans
Contenus pertinents
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- Comment puis-je résoudre les erreurs de connexion à AWS Marketplace dans mes tâches ETL d’AWS Glue ?AWS OFFICIELA mis à jour il y a 3 mois