AWS Glue Crawlers Now Support Snowflake
Share
Services
[AWS Glue crawlers](https://docs.aws.amazon.com/glue/latest/dg/catalog-and-crawler.html) now support Snowflake, making it easier for you to understand updates to Snowflake schema and extract meaningful insights.
To crawl a Snowflake database, customers can create and schedule a Glue crawler with JDBC URL with credential information from AWS Secret Manager. A configuration option allows you to specify if you want the crawler to crawl the entire database or limit the tables by including schema/table path and exclude pattern to reduce crawl time. With each run of the crawler, the crawler inspects and catalogs information, such as updates or deletes to Snowflake tables, external tables, views, and materialized views in the AWS Glue Data Catalog. For Snowflake columns with non-Hive compatible types, such as geography or geometry, the crawler will extract that information as a raw data type and make it available in the Data Catalog.
AWS Glue crawler support for Snowflake is generally available in the following AWS Regions: US East (Ohio, N. Virginia), US West (Oregon), Asia Pacific (Tokyo, Osaka), Europe (Ireland). To learn more, read the [blog](https://aws.amazon.com/blogs/big-data/announcing-aws-glue-crawler-support-for-snowflake/), and visit the AWS Glue Crawler [documentation](https://docs.aws.amazon.com/glue/latest/dg/crawler-data-stores.html) to learn more.
What else is happening at Amazon Web Services?
Read update
Services
Share
AWS Glue Data catalog now automates generating statistics for new tables
about 12 hours ago
Services
Share
Amazon Q Developer transformation capabilities for mainframe modernization are now available (Preview)
about 12 hours ago
Services
Share