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 Databricks Employee
  • 820 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
  • 820 Views
  • 0 replies
  • 0 kudos
shan_chandra
by Databricks Employee
  • 2733 Views
  • 1 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."

  • 2733 Views
  • 1 replies
  • 4 kudos
Latest Reply
shan_chandra
Databricks Employee
  • 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
Coutinho
by New Contributor
  • 1215 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 ...

  • 1215 Views
  • 0 replies
  • 0 kudos
Maverick1
by Valued Contributor II
  • 4424 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
  • 4424 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
145625
by New Contributor II
  • 1108 Views
  • 0 replies
  • 1 kudos

What are the best practices to store VectorUDT into the databricks feature store?

Hello, I am having issues to store VectorUDT columns into the databricks feature store. I saw that the feature store is not able to handle this kind of data type, but can store arrays. So, I tried to convert my VectorsUDT into arrays as a workaround....

  • 1108 Views
  • 0 replies
  • 1 kudos
William
by New Contributor
  • 540 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...

  • 540 Views
  • 0 replies
  • 0 kudos
datadude
by New Contributor
  • 8284 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?

  • 8284 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
  • 676 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...

  • 676 Views
  • 0 replies
  • 0 kudos
Adalberto
by New Contributor II
  • 2933 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
  • 2933 Views
  • 4 replies
  • 0 kudos
Latest Reply
Atanu
Databricks Employee
  • 0 kudos

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

  • 0 kudos
3 More Replies
KC_1205
by New Contributor III
  • 1880 Views
  • 0 replies
  • 1 kudos

Update NumPy from 1.18 to 1.21

Hi all, I am planning to update the DB to 9.1 LTS from 7.3 LTS, corresponding NumPy version will be 1.19 and later would like to update 1.21 in the notebooks. At cluster I have Spark version related to the 9.1 LTS which will support 1.19 and notebo...

  • 1880 Views
  • 0 replies
  • 1 kudos

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