CODEWITHSUNDEEP
amazon-web-servicesapache-sparkapache-spark-sqlsnowflake-cloud-data-platform
Ram Ghadiyaram
Ram Ghadiyaram

Reputation: 29185

How to Access RDD Tables via Spark SQL as a SnowFlake datawarehouse JDBC Distributed Query Engine?

Hi I want to query my temp database table from snowflake db.

Similary like How to Access RDD Tables via Spark SQL as a JDBC Distributed Query Engine?

Is there any way to do this from snowflake database running on AWS?

Upvotes: 0

Views: 245

Answers (1)

Marcin Zukowski
Marcin Zukowski

Reputation: 4729

Just to confirm - you want Snowflake to query the RDD that is created by Spark?

There is no way to connect from Snowflake to Spark and to query Spark RDDs from Snowflake But you can connect from Spark to Snowflake, copy the RDD to Snowflake, and then query it either from Spark (e.g. using Utils.runQuery() or from Snowflake directly.

More info, with examples, in Snowflake documentation

P.S. Snowflake is a single word :)

Upvotes: 1

Related Questions