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
  • 3926 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
  • 3926 Views
  • 0 replies
  • 0 kudos
fijoy
by Contributor
  • 3045 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...

  • 3045 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
  • 1535 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 ...

  • 1535 Views
  • 0 replies
  • 0 kudos
Jordan2
by New Contributor
  • 865 Views
  • 0 replies
  • 0 kudos

Data+AI summit

Lakehouseiq looks really cool! Lakehouseiq is a Llm agent that builds sql queries from natural language. Ties into their other products like biz context  lineage and previous queries.

  • 865 Views
  • 0 replies
  • 0 kudos
MJT07
by New Contributor
  • 1313 Views
  • 0 replies
  • 0 kudos

Summit

Today was the first day of summit and learned about how different models can be deployed for different decision points. I'm curious to know what users have found to be model control issues regarding this. Thanks!

  • 1313 Views
  • 0 replies
  • 0 kudos
Eric_Kieft
by New Contributor III
  • 12056 Views
  • 4 replies
  • 1 kudos

Is there a way to determine location/folder in the Recents view?

With multiple locations for items to exist, duplicate names make it hard to tell which one is which without opening.

  • 12056 Views
  • 4 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

@Eric Kieft​ :In Databricks, the Recents view shows the recently accessed notebooks, dashboards, and folders. However, it does not show the exact location of the item. To determine the location of an item in the Recents view, you can try the followin...

  • 1 kudos
3 More Replies
pauloquantile
by Databricks Partner
  • 3314 Views
  • 1 replies
  • 2 kudos

How to prevent users from scheduling SQL queries?

We have noticed that users can schedule SQL queries, but currently we haven't found a way to find these scheduled queries (this does not show up in the jobs workplane). Therefore, we don't know that people scheduled this. The only way is to look at t...

  • 3314 Views
  • 1 replies
  • 2 kudos
Latest Reply
Anonymous
Not applicable
  • 2 kudos

@Paulo Rijnberg​ :In Databricks, you can use the following approaches to prevent users from scheduling SQL queries and to receive notifications when such queries are scheduled:Cluster-level permissionsJobs APINotification hooksAudit logs and monitori...

  • 2 kudos
DataArchitect
by New Contributor III
  • 9158 Views
  • 6 replies
  • 5 kudos

Migration of Databricks Jobs, SQL dasboards and Alerts from lower environment to higher environment?

I want to move Databricks Jobs, SQL dasboards, Queries and Alerts from lower environment to higher environment, how we can move?

  • 9158 Views
  • 6 replies
  • 5 kudos
Latest Reply
Anonymous
Not applicable
  • 5 kudos

Hi @Shubham Agagwral​ 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 answ...

  • 5 kudos
5 More Replies
Chengcheng
by New Contributor III
  • 7315 Views
  • 1 replies
  • 3 kudos

Best practice of handling Data Duplication in a Delta Live Table Pipeline with daily batch data source.

I am building a data pipeline using Delta Live table in Azure Databricks to move data from a raw data table to a feature table and model inference results table. However, I am concerned about the potential for duplication issues in future operations,...

  • 7315 Views
  • 1 replies
  • 3 kudos
Latest Reply
Anonymous
Not applicable
  • 3 kudos

Hi @Chengcheng Guo​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question. Thanks.

  • 3 kudos
alejandrofm
by Valued Contributor
  • 3500 Views
  • 1 replies
  • 3 kudos

How to change compression codec of sql warehouse written files?

Hi, I'm currently starting to use SQL Warehouse, and we have most of our lake in a compression different than snappy. How can I set the SQL warehouse to use a compression like gzip, zstd, on CREATE, INSERT, etc? Tried this: set spark.sql.parquet.comp...

  • 3500 Views
  • 1 replies
  • 3 kudos
Latest Reply
Anonymous
Not applicable
  • 3 kudos

Hi @Alejandro Martinez​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question. Thanks.

  • 3 kudos
Nikhil3107
by New Contributor III
  • 25955 Views
  • 1 replies
  • 2 kudos

RuntimeError: It appears that you are attempting to reference SparkContext from a broadcast variable, action, or transformation. SparkContext can only be used on the driver, not in code that it run on workers. For more information, see SPARK-5063.

I created the following model:     which calls get_identifier_information() which is as follows:     This is how I log the model     And this is the error I am running into:   RuntimeError: It appears that you are attempting to reference SparkContext...

image image image
  • 25955 Views
  • 1 replies
  • 2 kudos
Latest Reply
Anonymous
Not applicable
  • 2 kudos

Hi @Nikhil Gajghate​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question. Thanks.

  • 2 kudos