Glue Crawlers and MongoDB Atlas

0

Is it possible to wildcard the include path for a MongoDB crawler. I've tried a number of different options similar to the options available for JDBC and other relational database connections, but they don't seem to work (example include path: "mydb/%"). I get the following error: "Crawler Error: Conversion = '/'

已提問 2 個月前檢視次數 123 次
1 個回答
1
已接受的答案

It is not possible to use a wildcard in the include path when crawling MongoDB data using AWS Glue crawlers. The include path for MongoDB must specify the exact database and collection names.

However, there are a few options to consider:

  • Create multiple crawlers - one for each database/collection combination. This allows crawling specific subsets of data.
  • Use an exclude pattern to skip certain collections or documents based on patterns. For example, to exclude any collection starting with "temp_", you can use the exclude pattern "temp_*".
  • If the databases and collections have a consistent naming pattern, you can programmatically generate the crawler configuration including all the combinations. Then update this configuration periodically as needed.
  • Another alternative is to copy the MongoDB data into Amazon S3 using tools like AWS Database Migration Service. You can then crawl the data in S3 using wildcards in the include path.
profile picture
專家
已回答 2 個月前
profile picture
專家
已審閱 2 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南