- 5430 Views
- 7 replies
- 4 kudos
Currently, we are migrating from hive metastore to UC. We have several dashboards and a huge number of queries whose catalogs have been set to hive_metastore and using <db>.<table> access pattern.I'm just wondering if there's a way to switch catalogs...
- 5430 Views
- 7 replies
- 4 kudos
Latest Reply
May you can also have a look here, if you need hot fix https://github.com/databrickslabs/ucx
6 More Replies
by
Vijesh
• New Contributor II
- 4127 Views
- 5 replies
- 1 kudos
I have two tables EMPLOYEE & EMPLOYEE_ROLE. I'm trying to Update a column with a value from another column. I'm using SQL server join but i get an error - [parse_syntax_error] Syntax error at or near 'FROM' line 3. UPDATE CSET C.title = B.title FROM ...
- 4127 Views
- 5 replies
- 1 kudos
Latest Reply
Hi @Vijesh V Try to use merge into to perform cdc between tables :MERGE INTO target aUSING source bON {merge_condition}WHEN MATCHED THEN {matched_action}WHEN NOT MATCHED THEN {not_matched_action}
4 More Replies
by
cgrant
• Databricks Employee
- 4012 Views
- 4 replies
- 6 kudos
I'm trying to use the native execution engine, Photon. How can I tell if a query is using Photon or is falling back to the non-native Spark engine?
- 4012 Views
- 4 replies
- 6 kudos
Latest Reply
Typo error in my second point of the previous post. Click the execution plan of your task[this is available under SQL/Dataframe tab in Spark UI]. It explains what operations run in the photon engine and what didn't execute by photon.
3 More Replies
- 1629 Views
- 1 replies
- 4 kudos
Databricks SQL framework, easy to learn, fast to code, ready for production.I built an abstraction of the databricks-sql-connector in order to follow a pattern closer to the concepts of ORM tools, in addition to facilitating the adoption of the data ...
- 1629 Views
- 1 replies
- 4 kudos
Latest Reply
Sure, will try and provide feedback for same
by
Yuliya
• New Contributor II
- 2002 Views
- 2 replies
- 3 kudos
When trying to start SQL Warehouse from my Azure pay-as-you-go subscription, I'm getting error about not enough vCPUs provisioned. Documentation says to increase quota at Azure portal - but it requires knowing type of vCPUs to provision. What type of...
- 2002 Views
- 2 replies
- 3 kudos
Latest Reply
Hi @Yuliya Quintela,Just a friendly follow-up. Did Rostislaw's response help you to resolve your question? if it did, please mark it as best. Otherwise, please let us know if you still need help.
1 More Replies
- 1003 Views
- 1 replies
- 3 kudos
What’s the USP? DB SQL serverless? When is it coming to Azure?
- 1003 Views
- 1 replies
- 3 kudos
Latest Reply
Hi @Chandana Basani DB SQL Serverless in Azure is planned for GA on the Release quarter FY23 Q1 in the release month 2023-01Best,Akash
- 5086 Views
- 2 replies
- 5 kudos
So I want to create a select all button in a parameter. The actual parameter has around 200 options because of the size of the database. However, if I want a general summary where you can see all the options I would have to select one by one and that...
- 5086 Views
- 2 replies
- 5 kudos
Latest Reply
You could add '--- All Stores ---' to your list. Here is the query I would use to populate the drop-down. S.O. answer hereSELECT
store as store_name
FROM
(
Select Distinct
store
From
Table
UNION ALL
SELECT
...
1 More Replies
- 3111 Views
- 3 replies
- 2 kudos
I have my Databricks SQL Endpoint running, I have created many tables there using AWS S3 Delta. Now I want to query the Databricks SQL Endpoint from NodeJs. So It is possible ?I tried to find and researched a lot but didn't get any useful tutorial fo...
- 3111 Views
- 3 replies
- 2 kudos
Latest Reply
We are very interested in supporting two capabilities -- in fact these are being worked on already:The ability to issue a SQL query over REST and track its status, retrieve results etc.A NodeJS SDK for Databricks SQLKeep an eye on our release notes
2 More Replies
- 2941 Views
- 2 replies
- 1 kudos
I don't want one long or poorly written query to block my entire SQL endpoint for everyone else. Do I have the ability to kill specific queries?
- 2941 Views
- 2 replies
- 1 kudos
Latest Reply
Is there a way to stop the session programmatically? like "kill session_id" or something similar in API?
1 More Replies
- 776 Views
- 0 replies
- 0 kudos
Cluster Sizees on DB sql Cluster size Driver size Worker count
2X-Small i3.2xlarge 1
X-Small i3.2xlarge 2
Small i3.4xlarge 4
Medium i3.8xlarge 8
Large i3.8xlarge 16
X-Large i3.16xlarge 32
2X-Large i3.16xlarge...
- 776 Views
- 0 replies
- 0 kudos
