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
  • 3122 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
  • 3122 Views
  • 0 replies
  • 0 kudos
scvbelle
by New Contributor III
  • 7185 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...

  • 7185 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
  • 7836 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?

  • 7836 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
  • 827 Views
  • 0 replies
  • 0 kudos

Indexless Indexes

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

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

  • 2464 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
  • 1191 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 ...

  • 1191 Views
  • 0 replies
  • 0 kudos
Jordan2
by New Contributor
  • 621 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.

  • 621 Views
  • 0 replies
  • 0 kudos
MJT07
by New Contributor
  • 1118 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!

  • 1118 Views
  • 0 replies
  • 0 kudos
Eric_Kieft
by New Contributor III
  • 11023 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.

  • 11023 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 New Contributor III
  • 2869 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...

  • 2869 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