cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

MadelynM
by Databricks Employee
  • 4064 Views
  • 0 replies
  • 0 kudos

[Recap] Data + AI Summit 2024 - Warehousing & Analytics | Improve performance and increase insights

Here's your Data + AI Summit 2024 - Warehousing & Analytics recap as you use intelligent data warehousing to improve performance and increase your organization’s productivity with analytics, dashboards and insights.  Keynote: Data Warehouse presente...

Screenshot 2024-07-03 at 10.15.26 AM.png
Warehousing & Analytics
AI BI Dashboards
AI BI Genie
Databricks SQL
  • 4064 Views
  • 0 replies
  • 0 kudos
Meagan
by New Contributor III
  • 5085 Views
  • 1 replies
  • 0 kudos

Resolved! Delta Sharing lists tables but says "access to resource is forbidden" when reading table contents

I am using Power BI Desktop to connect to Unity Catalog using Delta Sharing. When I connect, I enter my endpoint, enter my bearer token, browse the catalog and can see my tables. But when I try to preview or load a table, I get the error "access to r...

Meagan_0-1690388250151.png
  • 5085 Views
  • 1 replies
  • 0 kudos
Latest Reply
Meagan
New Contributor III
  • 0 kudos

It turned out we had to allow my IP address on the storage account used by Unity Catalog. I guess i wasn't expecting to need that for Delta Sharing, but that indeed did fix the problem. 

  • 0 kudos
DennisD
by New Contributor
  • 1559 Views
  • 0 replies
  • 0 kudos

Notebook stuck on Initializing RocksDB

Hi,While running a notebook during a nightrun on Azure Databricks, it got stuck on Initializing RocksDB. We are not using any streaming data nor have enabled RocksDB. Anyone has any clue how to disable RocksDB or prevent this in the future?Thanks! 

  • 1559 Views
  • 0 replies
  • 0 kudos
dprutean
by New Contributor III
  • 1921 Views
  • 1 replies
  • 1 kudos

JDBC DatabaseMetaData.getColumns().getComments() encoding issue

I am using the JDBC driver to load comments saved in Databricks, associated to tables and columns.Comments saved in Chinese are returned in the bad encoding. I useDatabaseMetaData.getColumns().getComments()

  • 1921 Views
  • 1 replies
  • 1 kudos
Latest Reply
saipujari_spark
Databricks Employee
  • 1 kudos

@dprutean Can you share an example with the expected results vs the actual results?

  • 1 kudos
eimis_pacheco
by Contributor
  • 5398 Views
  • 3 replies
  • 5 kudos

Resolved! Why companies use databricks SQL and Redshift at the same time?

Hi community,I suddenly found myself confused, and this might sound like an obvious answer for some but not for me at least in this moment.I am not getting why companies use databricks SQL and Redshift at the same time?I mean, with databricks platfor...

  • 5398 Views
  • 3 replies
  • 5 kudos
Latest Reply
Anonymous
Not applicable
  • 5 kudos

Hi @eimis_pacheco  We haven't heard from you since the last response from @-werners- , and I was checking back to see if her suggestions helped you. Or else, If you have any solution, please share it with the community, as it can be helpful to others...

  • 5 kudos
2 More Replies
Testing2
by New Contributor II
  • 5446 Views
  • 6 replies
  • 0 kudos

Unable start SQL warehouse AWS

Unable start SQL warehouse AWS. Warehouse is in starting state for a very long time and error is thrown

  • 5446 Views
  • 6 replies
  • 0 kudos
Latest Reply
rdkarthikeyan27
New Contributor II
  • 0 kudos

Can you please check on particular SQL warehouse instances type quota with cloud provider (Azure/AWS) . may be that particular instance type quota is over with your account . Same issue we have faced and requested AWS to increase the quota of that in...

  • 0 kudos
5 More Replies
dsugs
by New Contributor II
  • 13928 Views
  • 4 replies
  • 2 kudos

Resolved! I'm curious if anyone has ever written a file to S3 with a custom file name?

So I've been trying to write a file to S3 bucket giving it a custom name, everything I try just ends up with the file being dumped into a folder with the specified name so the output is like ".../file_name/part-001.parquet". instead I want the file t...

  • 13928 Views
  • 4 replies
  • 2 kudos
Latest Reply
rdkarthikeyan27
New Contributor II
  • 2 kudos

Spark feature where to avoid network io it writes each shuffle partition as a 'part...' file on disk and each file as you said will have compression and efficient encoding by default.So Yes it is directly related to parallel processing !!

  • 2 kudos
3 More Replies
scvbelle
by New Contributor III
  • 9268 Views
  • 5 replies
  • 5 kudos

Resolved! Recommended ETL workflow for weekly ingestion of .sql.tz "database dumps" from Blob Storage into Unity Catalogue-enabled Metastore

The client receives data from a third party as weekly "datadumps" of a MySQL database copied into an Azure Blob Storage account container (I suspect this is done manually, I also suspect the changes between the approx 7GB files are very small). I nee...

  • 9268 Views
  • 5 replies
  • 5 kudos
Latest Reply
Anonymous
Not applicable
  • 5 kudos

Hi @Sylvia VB​ Thank you for posting your question in our community! We are happy to assist you.To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers you...

  • 5 kudos
4 More Replies
naga_databricks
by Contributor
  • 8744 Views
  • 4 replies
  • 1 kudos

Resolved! From within a Databricks Notebook, how do you get the workflow and task name

I have a notebook where i want to use the workflow name and task name that it will be running under. How do i access these information?

  • 8744 Views
  • 4 replies
  • 1 kudos
Latest Reply
BilalAslamDbrx
Databricks Employee
  • 1 kudos

Please take a look at these docs, I think they are what you need: https://docs.databricks.com/workflows/jobs/task-parameter-variables.html

  • 1 kudos
3 More Replies
scbutler1
by New Contributor
  • 1107 Views
  • 0 replies
  • 0 kudos

Indexless Indexes

Super excited about learning how AI can help improve performance and throughout for our database customers.

  • 1107 Views
  • 0 replies
  • 0 kudos
fijoy
by Contributor
  • 3096 Views
  • 2 replies
  • 1 kudos

How can I create a table that's visible only to a specific run of a notebook?

I'd like to create an SQL table in a notebook that's visible to a specific run (session?) of a notebook. Meaning, even if 2 different users run that notebook at the same time, there should be no conflict. And the table should go away once the noteboo...

  • 3096 Views
  • 2 replies
  • 1 kudos
Latest Reply
igorstar
New Contributor III
  • 1 kudos

For now ‘CREATE TEMPORARY VIEW’ is the way to go. Once you read from it once, the following reads are going to be cached so it won’t be recomputed every time.

  • 1 kudos
1 More Replies
wward9
by New Contributor
  • 1548 Views
  • 0 replies
  • 0 kudos

Migrating From Azure Analysis Services To Lakehouse?

Does anyone have any experience migrating a gold layer from Azure Analysis Services (AAS) tabular structure to one centered around the lakehouse architecture? My company currently uses AAS to serve data to all levels of users across the company, but ...

  • 1548 Views
  • 0 replies
  • 0 kudos