How to build a data catalog in Glue for Snowflake?

2k Views Asked by At

I am new to snowflake. I am wondering how to build a data catalog for snowflake's data?

I cannot find documentation on that. I can find this post. But it seems that it does not use the catalog function.

2

There are 2 best solutions below

0
On

I find useful information here where you need to add jdbc connection then define a crawler but seems not supporting Snowflake database as the latter link says

Crawlers can crawl the following data stores through a JDBC connection:

Amazon Redshift

Amazon Relational Database Service (Amazon RDS)

Amazon Aurora

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Publicly accessible databases

Aurora

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

Also, again I find in defining connection link here those are the supported databases only

AWS Glue can connect to the following data stores through a JDBC connection:

Amazon Redshift

Amazon Aurora

Microsoft SQL Server

MySQL

Oracle

PostgreSQL

1
On

Now the Snowflake support is added in AWS Glue Crawler.

Refer: https://aws.amazon.com/blogs/big-data/announcing-aws-glue-crawler-support-for-snowflake/