- 2440 Views
- 1 replies
- 3 kudos
How to change compression codec of sql warehouse written files?
Hi, I'm currently starting to use SQL Warehouse, and we have most of our lake in a compression different than snappy. How can I set the SQL warehouse to use a compression like gzip, zstd, on CREATE, INSERT, etc? Tried this: set spark.sql.parquet.comp...
- 2440 Views
- 1 replies
- 3 kudos
- 3 kudos
Hi @Alejandro Martinez​ Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question. Thanks.
- 3 kudos
- 1870 Views
- 0 replies
- 2 kudos
Availability of SQL Warehouse to Data Science and Engineering persona ​Hi All,Now we can use SQL Warehouse in our notebook execution.It's in previ...
Availability of SQL Warehouse to Data Science and Engineering persona ​ Hi All, Now we can use SQL Warehouse in our notebook execution. It's in preview now and soon will be GA.
- 1870 Views
- 0 replies
- 2 kudos
- 4716 Views
- 1 replies
- 9 kudos
Refreshing SQL DashboardYou can schedule the dashboard to automatically refresh at an interval.At the top of the page, click Schedule.If the dashboard...
Refreshing SQL DashboardYou can schedule the dashboard to automatically refresh at an interval.At the top of the page, click Schedule.If the dashboard already has a schedule, you see Scheduled instead of Schedule.Select an interval, such as Every 1 h...
- 4716 Views
- 1 replies
- 9 kudos
- 9 kudos
Useful
- 9 kudos
- 19904 Views
- 5 replies
- 2 kudos
SQL Warehouse high number of concurrent queries
We are going to be a databricks customer and did some PoC tests. Our one test contains dataset in one partitioned table (15colums) is roughly 250M rows, each partition is ~50K-150K rows. Occasionally we have hundreds (up to one thousand) concurrent u...
- 19904 Views
- 5 replies
- 2 kudos
- 2 kudos
Hi @Marian Kovac​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thank...
- 2 kudos
- 7042 Views
- 4 replies
- 6 kudos
SQL Query execution plan explain and optimize the performance for query run.
When we executing SQL query in databricks SQL warehouse editor what will be best practices to optimize the execution plan and get result faster
- 7042 Views
- 4 replies
- 6 kudos
- 6 kudos
Hi @vinay kumar​ Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help. We'd love to hear from you.Thanks...
- 6 kudos