topic Re: Databricks unmanaged table from Snowflake in Data Engineering

Databricks unmanaged table from Snowflake

155647 — Fri, 20 May 2022 12:29:24 GMT

Is there a way to create Databricks unmanaged table that's actually Snowflake table, not some S3 or DBFS location?

From documentation is rather vague is this possible: "You can create an unmanaged table with your data in data sources such as Cassandra, JDBC table, and so on. See Data sources for more information about the data sources supported by Databricks. Some common ways of creating an unmanaged table are:"

I have data stored both on S3 and Snowflake and want to be able to query both locations with Databricks. The challenge with Snowflake table is that you have to import secrets, create options, and load data into dataframe. A better solution would be to do that only once and then just access the table as databricks unmanaged table.

Re: Databricks unmanaged table from Snowflake

Hubert-Dudek — Sat, 21 May 2022 10:20:56 GMT

@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

Re: Databricks unmanaged table from Snowflake

Anonymous — Mon, 06 Jun 2022 12:55:35 GMT

Hi @Stefan Stojanovic following up did you get a chance to check @Hubert Dudek previous comments ?

Re: Databricks unmanaged table from Snowflake

Anonymous — Tue, 19 Jul 2022 15:48:28 GMT

Hey @Stefan Stojanovic

Hope everything is going great!

Does @Hubert Dudek's response answer your question? If yes, would you be happy to mark it as best so that other members can find the solution more quickly? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!