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: 
Data + AI Summit 2024 - Data Warehousing, Analytics, and BI

Forum Posts

MadelynM
by Contributor II
  • 598 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
  • 598 Views
  • 0 replies
  • 0 kudos
shan_chandra
by Esteemed Contributor
  • 2610 Views
  • 2 replies
  • 4 kudos

Resolved! How to provide read access only to the view in DBSQL and not the underlying table?

Facing the below errorUser cannot select on table `database2.view1` because: There is no owner for table `database1.table1`. Ask your administrator to set an owner."

  • 2610 Views
  • 2 replies
  • 4 kudos
Latest Reply
shan_chandra
Esteemed Contributor
  • 4 kudos

Please find the below resolutionThe owner of the table needs to be the same as the owner of the ViewCreate a group with users for whom we require only access to the viewThe group needs to have SELECT and READ_METADATA on view(database2.view1), USAGE ...

  • 4 kudos
1 More Replies
Coutinho
by New Contributor
  • 1150 Views
  • 0 replies
  • 0 kudos

How to export a struct field of Big Query to Parquet/DeltaTable with all struct fields?

Hi I don't know if anyone can help me with a question about BIG QUERY and Parquet in Databricks.We have export a field named EVENT_PARAMS from a BIG QUERY to a PARQUET table in databricks.In BIG QUERY, we notice that this column is a STRUCT that has ...

  • 1150 Views
  • 0 replies
  • 0 kudos
Maverick1
by Valued Contributor II
  • 4178 Views
  • 4 replies
  • 4 kudos

Resolved! How to refer the ".whl" files from repos into a Databricks "python wheel" task in Databricks jobs?

I was trying to see whether it would be possible to refer a library from a Repos path (as “files in repos” feature is already available).I can see the “.whl” file in the repo itself but it is not visible under the “Workspace” option of “python wheel”...

Screenshot 2022-03-21 at 7.20.51 PM Screenshot 2022-03-21 at 7.21.25 PM
  • 4178 Views
  • 4 replies
  • 4 kudos
Latest Reply
Maverick1
Valued Contributor II
  • 4 kudos

As of now, The only resolutions for this query are:Either push/deploy the library to an DBFS or S3 path.Either deploy the library on a repos path and then refer it inside a notebook via passing repos path.Accessing Workspace path or root "file:/" pat...

  • 4 kudos
3 More Replies
William
by New Contributor
  • 508 Views
  • 0 replies
  • 0 kudos

data_centers_q2_q3.snappy

I am writing to inquire about the following error: om.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.sql.AnalysisException: Unable to infer schema for Parquet. It must be specified manually. at org.apache.s...

  • 508 Views
  • 0 replies
  • 0 kudos
datadude
by New Contributor
  • 8018 Views
  • 1 replies
  • 0 kudos

How to connect to ServiceNow via JDBC?

Hi all,I'm trying to connect to ServiceNow as a data source to ingest some data to a lake.ServiceNow is a MySQL database underneath, however, I cannot figure out how to connect to it with "regular" MySQL JDBC - has anyone ever tried this?

  • 8018 Views
  • 1 replies
  • 0 kudos
Latest Reply
User16764241763
Honored Contributor
  • 0 kudos

Hello @Frank Wagner​ Thank you for posting to Databricks Community ForumIt seems like there is not enough documentation around JDBC connectivitySeems like there are a few commercial connectorshttps://www.cdata.com/drivers/servicenow/jdbc/https://www....

  • 0 kudos
Telcosought
by New Contributor
  • 639 Views
  • 0 replies
  • 0 kudos

Logo-12

Telcosought is a networking website they are focusing on all about 4g networking researching newtechnology in the field of networking.Telcosought is a group of persons who have more than 10year of experience in networking. So that with Telcosought yo...

  • 639 Views
  • 0 replies
  • 0 kudos
Adalberto
by New Contributor II
  • 2789 Views
  • 4 replies
  • 0 kudos

Resolved! Unable to connect to Cluster or SQL endpoint from mac using Simba ODBC connector

Hi, I've been trying to connect to Databricks (cluster or endpoint) from Mac m1 using the simba odbc connector. I followed the instructions in:https://docs.microsoft.com/en-us/azure/databricks/scenarios/connect-databricks-excel-python-rhttps://docs.d...

DSN configuration Error message
  • 2789 Views
  • 4 replies
  • 0 kudos
Latest Reply
Atanu
Esteemed Contributor
  • 0 kudos

are you using latest connector? also, check your firewall setup for the same.

  • 0 kudos
3 More Replies
Hotstar_ad_bloc
by New Contributor
  • 541 Views
  • 0 replies
  • 0 kudos

Extension adds features and functions to a browser. It's created using familiar web-based technologies—HTML, CSS, and JavaScript. This means that ...

Extension adds features and functions to a browser. It's created using familiar web-based technologies—HTML, CSS, and JavaScript. This means that you can do a lot more in an extension. Browser extensions can manipulate the content of web pages and he...

  • 541 Views
  • 0 replies
  • 0 kudos
RicksDB
by Contributor II
  • 6515 Views
  • 13 replies
  • 14 kudos

SQL endpoint JDBC table support

Hi, is there any way/workaround to query JDBC tables the same way one can do with other type of clusters?Doing so right now causes an error saying that only text based files are supported (json, parquet, delta etc) even though the tables are recogniz...

  • 6515 Views
  • 13 replies
  • 14 kudos
Latest Reply
RyanD-AgCountry
Contributor
  • 14 kudos

I've been waiting patiently for this option since public preview early 2021. The vast majority of our data is in SQL Server databases, and because we are unable to query these data sources is the primary reason the data team hasn't adopted SQL Worksp...

  • 14 kudos
12 More Replies

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Labels
Top Kudoed Authors