Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-21-2022 03:20 AM
@Stefan Stojanovic, It is a lot of hassle. Still, you can create your metastore as described by snowflake (it will handle Databricks tables without problems as well):
https://docs.snowflake.com/en/user-guide/tables-external-hive.html
and add it to Databricks as external hive meta stores
https://docs.databricks.com/data/metastores/external-hive-metastore.html
A more simple way would be (but when I checked it with some other database, it was not working)
take that jar from snowflake and try to register as an external table with JDBC string. Here is an example with Postgres https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html
My blog: https://databrickster.medium.com/