- 2720 Views
- 1 replies
- 0 kudos
Resolved! How can I make a cluster start up in the availability-zone (AZ) with the most available IPs?
I see the default in the UI is to always create clusters in a single AZ (e.g. us-west-2a), but want to distribute workloads across all available AZs.
- 2720 Views
- 1 replies
- 0 kudos
- 0 kudos
Found the answer - not available in the UI, but via API, you can submit the cluster definition with "aws_attributes": { "zone_id": "auto" },This is documented in the Cluster API: https://docs.databricks.com/dev-tools/api/latest/clusters.html#aw...
- 0 kudos
- 9455 Views
- 2 replies
- 0 kudos
- 9455 Views
- 2 replies
- 0 kudos
- 0 kudos
There is a native Cost Management Connector in Power BI that allows one to make powerful, customized visualization and cost/usage reports. I also recommend reviewing the Chargeback/Cost Analysis section of the ADB Best Practices guide here - https://...
- 0 kudos
- 3088 Views
- 1 replies
- 1 kudos
- 3088 Views
- 1 replies
- 1 kudos
- 1 kudos
Yes, Azure Data Factory can execute code on Azure Databricks. The best way to return values from the notebook to Data factory is to use the dbutils.notebook.exit() function at the end of your notebook or whenever you want to terminate execution.
- 1 kudos
- 13244 Views
- 1 replies
- 0 kudos
- 13244 Views
- 1 replies
- 0 kudos
- 0 kudos
The key benefits of High Concurrency clusters are that they provide fine-grained sharing for maximum resource utilization and minimum query latencies.Note that a Standard cluster is recommended for a single user. Standard clusters can run workloads d...
- 0 kudos
- 1368 Views
- 1 replies
- 0 kudos
What Databricks resources are available for university faculty members?
I would like to use Databricks to teach large-scale analytics in my classroom; does Databricks have any resources or community assets that can help me out?
- 1368 Views
- 1 replies
- 0 kudos
- 0 kudos
For folks that are looking to leverage Databricks as a teaching asset, please sign contact us for Databricks University Alliance. https://databricks.com/p/teach
- 0 kudos
- 4514 Views
- 1 replies
- 0 kudos
What Databricks resources are available for university students?
I want to learn how to use Databricks for my courses at university, and maybe to get a Databricks Certification. Can you help me out?
- 4514 Views
- 1 replies
- 0 kudos
- 0 kudos
We have a ton of great resources available for people who are wanting to learn Databricks, specifically for university students. Checkout our our university page, to learn more about Databricks Community Edition, Free workshops, and self-paced course...
- 0 kudos
- 1383 Views
- 1 replies
- 0 kudos
Efficient data retrieval process between Azure Blob storage and Azure databricks
I am trying to design a stream a data analytics project using functions --> event hub --> storage --> Azure factory --> databricks --> SQL server.What I am strugging with at the moment is the idea about how to optimize "data retrieval" to feed m...
- 1383 Views
- 1 replies
- 0 kudos
- 0 kudos
Check out our auto loader capabilities that can automatically track and process files that need to be processed. AutoloaderThere are two options: directory listing, which is essentially completing the same steps that you have listed above but in a sl...
- 0 kudos
- 2854 Views
- 1 replies
- 0 kudos
Resolved! Can you implement fine grained access controls on Delta tables?
I would like to provide row and column level security on my tables I have created in my workspace. Is there any way to do this?
- 2854 Views
- 1 replies
- 0 kudos
- 0 kudos
Databricks includes two user functions that allow you to express column- and row-level permissions dynamically in the body of a view definition.current_user(): return the current user name.is_member(): determine if the current user is a member of a s...
- 0 kudos
- 1330 Views
- 1 replies
- 1 kudos
- 1330 Views
- 1 replies
- 1 kudos
- 1 kudos
With Koalas, which is a Pandas'API on top of Spark Dataframes, there should be minimal code changes required.Please refer to this blog for more info
- 1 kudos
- 7997 Views
- 1 replies
- 0 kudos
Read excel files and append to make one data frame in Databricks from azure data lake without specific file names
I am storing excel files in Azure data lake (gen 1). They follow filenames follow the same pattern "2021-06-18T09_00_07ONR_Usage_Dataset", "2021-06-18T09_00_07DSS_Usage_Dataset", etc. depending on the date and time. I want to read all the files in th...
- 7997 Views
- 1 replies
- 0 kudos
- 0 kudos
If you are attempting to read all the files in a directory you should be able to use a wild card and filter using the extension. For example: df = (spark .read .format("com.crealytics.spark.excel") .option("header", "True") .option("inferSchema", "tr...
- 0 kudos
- 1767 Views
- 1 replies
- 0 kudos
How many users can the JDBC endpoint support in the All Purpose HC?
What is the max number of users can the JDBC endpoint support in the All Purpose high concurrency cluster? To support more sql workloads, is it better to go with Databricks Sql Enpoints?
- 1767 Views
- 1 replies
- 0 kudos
- 0 kudos
There is a limit an execution context limit of 145. This means you can have at most 145 notebooks attached to a cluster. https://kb.databricks.com/execution/maximum-execution-context.htmlIf you are primarily using SQL then Databricks SQL Endpoints wo...
- 0 kudos
- 1879 Views
- 1 replies
- 0 kudos
Resolved! Does size of optimized files after running OPTIMIZE varies between cloud providers (S3, Blob and GCS)?
are there any other parameters to consider running OPTIMIZE depending cloud vendor?
- 1879 Views
- 1 replies
- 0 kudos
- 0 kudos
The optimize is not dependent on the cloud provider whatsoever. Optimize will produce the same results regardless of the underlying storage. It is idempotent, meaning if it is run twice on the same dataset the the second execution has no effect.
- 0 kudos
- 2760 Views
- 1 replies
- 0 kudos
- 2760 Views
- 1 replies
- 0 kudos
- 0 kudos
If you expect a column to be commonly used in query predicates and if that column has high cardinality (that is, a large number of distinct values), then use ZORDER BY.You can specify multiple columns for ZORDER BY as a comma-separated list. However,...
- 0 kudos
- 1532 Views
- 1 replies
- 0 kudos
- 1532 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi Yes we have the best practices,I can point on the data bricks Docshttps://docs.databricks.com/administration-guide/access-control/tokens.html
- 0 kudos
- 1471 Views
- 1 replies
- 0 kudos
- 1471 Views
- 1 replies
- 0 kudos
- 0 kudos
we have a limit of 100 Secret scopes and each secret can have 1000 key-value pair of secrets.https://docs.microsoft.com/en-us/azure/databricks/security/secrets/secret-scopes
- 0 kudos
| User | Count |
|---|---|
| 1615 | |
| 777 | |
| 349 | |
| 287 | |
| 260 |
