Databricks Community

Marra · 10-07-2022

Hi!So I've been looking into trying Unity Catalog since it seems to add many great features.But one thing I cant get my head around is the fact that we cant (shouldn't?) use multiple metastores in the same region in UC.Let me explain my usecase:We ha...

Marra · 06-07-2022

I'm having issues trying to read temporary views in SQL Analytics module. Ive managed to create temporary views based on a query but I don't know how to read from them? Just using the name of the view returns "Table or view not found".

Marra · 10-10-2022

@Sivaprasad C S Hi, ok so we will try to work with the schema.table levels to separate our environments.But is it possible / will it be possible to use different storage for managed tables in one metastore? Since we will be using the same metastore ...

Marra · 06-15-2022

I havn't been able to resolve the issue. I'm using a admin account in databricks so it should't be a permission issue?Is there any sample dataset that I can use in sql analytics so that I can try again and share my specific code here?

Marra · 06-07-2022

I should be able to read the view with "select * from view_test"?

Marra · 06-07-2022

So this is interesting, I tried to run the CREATE query per your example above:CREATE TEMPORARY VIEW IF NOT EXISTS view_test ASselect * from ....But this gave me a exception:"It is not allowed to define a TEMPORARY view with IF NOT EXISTS"However, I ...

Marra · 06-07-2022

No, I'm actually having issues reading from the view in the same session that created it. Using the same view name I get a table or view not found.

Databricks Community

User Stats

User Activity

Unity Catalog - multiple metastore in same region

Read temporary views in SQL Analytics

Re: Unity Catalog - multiple metastore in same region

Re: Read temporary views in SQL Analytics

Re: Read temporary views in SQL Analytics

Re: Read temporary views in SQL Analytics

Re: Read temporary views in SQL Analytics