- 2396 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...
- 2396 Views
- 7 replies
- 4 kudos
Latest Reply
Absolutely accurate, in order to grow your business you need to create an image of your brand such that it is the first thing coming to customers mind when they think about a certain product or service that’s where social media marketing agencies com...
6 More Replies
by
Vijesh
• New Contributor II
- 2022 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 ...
- 2022 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
- 1852 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?
- 1852 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
- 848 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 ...
- 848 Views
- 1 replies
- 4 kudos
Latest Reply
Sure, will try and provide feedback for same
by
Yuliya
• New Contributor II
- 954 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...
- 954 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
- 479 Views
- 1 replies
- 3 kudos
What’s the USP? DB SQL serverless? When is it coming to Azure?
- 479 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
- 2675 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...
- 2675 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
- 1613 Views
- 4 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...
- 1613 Views
- 4 replies
- 2 kudos
Latest Reply
Hi @Krishna Wahi​, Just a friendly follow-up. Do you still need help, or @Bilal Aslam​'s response help you to find the solution? Please let us know.
3 More Replies
- 1709 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?
- 1709 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
- 336 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...
- 336 Views
- 0 replies
- 0 kudos
