crawler can not find the table

0

Hi. I had a table that was created by a crawler, then I deleted the table ( in Athena) and created it by DDL. after running crawler. it could not find the table and create a new table. note: The s3 objects were as they were before.. any one has any opinion?

profile picture
gefragt vor 3 Monaten403 Aufrufe
1 Antwort
0

Hi,

When you re-created the table using the DDL statement, the metadata (such as the database name, table name, column names, and data types) might not have matched the metadata that the crawler was expecting. AWS Glue crawlers rely on the metadata stored in the AWS Glue Data Catalog to identify existing tables. Or if the re-created table was not registered with the AWS Glue Data Catalog, the crawler would not be able to find it. AWS Glue crawlers only scan tables that are registered in the Data Catalog.

Refer - https://docs.aws.amazon.com/glue/latest/dg/populate-catalog-methods.html for guidance around Data Catalog settings.

AWS
beantwortet vor 3 Monaten
profile picture
EXPERTE
überprüft vor 3 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen