1 Risposta
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
1
Hi,
You can query Snowflake using Athena via the Federated query feature of Athena. Crawling the Snowflake tables will add them to your data catalog, but you can't point Athena directly to these tables and query them. I will drop the blog on how to set up the Athena connector for Snowflake, and also a blog on crawling your Snowflake tables and the use cases for that.
con risposta un anno fa
Thanks for the links! It seems "crawling Snowflake table schema to catalog" is NOT a way to go. Would you please confirm that?
In general crawled tables are meant to be used by Glue jobs, there is no guarantee that Athena or other tools outside of Glue will be able to read it. But any day Athena can add the support for that kind of table
Contenuto pertinente
- AWS UFFICIALEAggiornata 2 anni fa
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata 3 anni fa
- AWS UFFICIALEAggiornata un anno fa
That error means Athena doesn't recognize it's a special table and it's trying to use it like a standard Hive table. I don't think it's possible for Athena to query a JDBC table at this time