- 6533 Views
- 1 replies
- 0 kudos
Resolved! How to list all Delta tables in a Database?
I wanted to get a list of all the Delta tables in a Database. What is the easiest way of getting it.
- 6533 Views
- 1 replies
- 0 kudos
- 0 kudos
Below code, the snippet can be used to list down the tables in a databaseval db = "database_name" spark.sessionState.catalog.listTables(db).map(table=>spark.sessionState.catalog.externalCatalog.getTable(table.database.get,table.table)).filter(x=>x....
- 0 kudos
- 36365 Views
- 3 replies
- 1 kudos
- 36365 Views
- 3 replies
- 1 kudos
- 1 kudos
This is by design and working as expected. Spark writes the data distributedly. use of coalesce (1) can help to generate one file, however this solution is not scalable for large data set as it involves bringing the data to one single task.
- 1 kudos
- 1237 Views
- 1 replies
- 1 kudos
- 1237 Views
- 1 replies
- 1 kudos
- 1 kudos
Photon is supported for batch workloads today and is the standard on Databricks SQL clusters and available as an option for Automated and Interactive clusters. And photon is in public preview today so available as an option for everyone. See this lin...
- 1 kudos
- 1345 Views
- 2 replies
- 0 kudos
- 1345 Views
- 2 replies
- 0 kudos
- 0 kudos
Delta has significant value beyond the DML/ACID capabilities. Delta's data organization strategies that @Ryan Chynoweth mentions also offer an advantage even for read-only use cases for querying and joining the data. Delta also supports in-place con...
- 0 kudos
- 3386 Views
- 1 replies
- 0 kudos
- 3386 Views
- 1 replies
- 0 kudos
- 0 kudos
This spark-salesforce connector looks like an option to query this data via SOQL/SAQL and brought into Databricks/Spark
- 0 kudos
- 1105 Views
- 1 replies
- 0 kudos
- 1105 Views
- 1 replies
- 0 kudos
- 0 kudos
There's actually several options here!AWSIf you'd like a very quick setup but full featured environment for your org, use the AWS quickstart: https://aws.amazon.com/quickstart/architecture/databricks/If you're solo exploring, you can use Databricks c...
- 0 kudos
- 1360 Views
- 1 replies
- 0 kudos
Setting cluster settings through SCIM
is there a way to set the following cluster settings through the SCIM? I am not seeing anything in the API docs that would suggest it is possible but I want to double check here.Enable credential passthroughSingle User AccessPermission settings
- 1360 Views
- 1 replies
- 0 kudos
- 0 kudos
Credential passthroughThis actually needs some setting up in AWS IAM to get started. Once you've created the right instance profiles, you'll need to add them to your Databricks workspace. There's pretty exhaustive guides here that has each of the ste...
- 0 kudos
- 1366 Views
- 1 replies
- 0 kudos
- 1366 Views
- 1 replies
- 0 kudos
- 0 kudos
Databricks jobs api can invoke code from cloud storage. But please note that it will not be stored as a Databricks notebook, rather it would be a source file or jar.
- 0 kudos
- 2759 Views
- 1 replies
- 0 kudos
How do you capture change logs from RDMS source and ingest the changes in Databricks AWS?
A common option is to use AWS DMS, https://databricks.com/blog/2019/07/15/migrating-transactional-data-to-a-delta-lake-using-aws-dms.html
- 2759 Views
- 1 replies
- 0 kudos
- 0 kudos
https://databricks.com/blog/2019/07/15/migrating-transactional-data-to-a-delta-lake-using-aws-dms.html
- 0 kudos
- 6108 Views
- 2 replies
- 0 kudos
How I can test my Python code that I wrote using notebooks?
I've written the code in the notebooks using the Python, and I want to add tests to it to make sure that it won't break when I do more changes.What tools can I use for that tasks?
- 6108 Views
- 2 replies
- 0 kudos
- 0 kudos
@Alex Ott has an awesome answer!Here is a great blog from our engineering team that may help as well. https://databricks.com/blog/2020/01/16/automate-deployment-and-testing-with-databricks-notebook-mlflow.html
- 0 kudos
- 1637 Views
- 0 replies
- 0 kudos
Spark vs. Ray?
Ray has been getting a lot of traction lately for shining at distributed compute.What are the primary differences between Spark and Ray?In which areas/applications would each be best ? (i.e. Reinforcement Learning)In which cases would it make sense f...
- 1637 Views
- 0 replies
- 0 kudos
- 1011 Views
- 0 replies
- 0 kudos
How do you capture delta changes while building a delta pipeline and going from bronze to silver to gold?
You can use change data feed feature of delta tables as described here: https://docs.databricks.com/delta/delta-change-data-feed.html
- 1011 Views
- 0 replies
- 0 kudos
- 2769 Views
- 2 replies
- 0 kudos
Requirement to Run Koalas
Hi I am planning to run Koalas on Databricks environment, What are the requirements for running Koalas there
- 2769 Views
- 2 replies
- 0 kudos
- 0 kudos
Koalas is great! This really helps ease the transition from Pandas to Spark, because you can just use the same Pandas functions/classes through the Koalas API but everything runs in the background in Spark.
- 0 kudos
- 4510 Views
- 1 replies
- 0 kudos
what does this error in hyperopt mean, One error that users commonly encounter with Hyperopt is: There are no evaluation tasks, cannot return argmin of task losses.?
This means that no trial completed successfully. This almost always means that there is a bug in the objective function, and every invocation is resulting in an error. See the error output in the logs for details. In Databricks, the underlying error ...
- 4510 Views
- 1 replies
- 0 kudos
- 0 kudos
The fmin function should be of the form:def evaluate_hyperparams(params): """ This method will be passed to `hyperopt.fmin()`. It fits and evaluates the model using the given hyperparameters to get the validation loss. :param params: This d...
- 0 kudos
- 1956 Views
- 0 replies
- 0 kudos
Hyperopt, how to setup hyper-parameter for categorical vs numerical hyperparameter?
hp.quniform (“quantized uniform”) or hp.qloguniform to generate integers. hp.choice is the right choice when, for example, choosing among categorical choices (which might in some situations even be integers, but not usually).https://databricks.com/b...
- 1956 Views
- 0 replies
- 0 kudos
| User | Count |
|---|---|
| 1619 | |
| 790 | |
| 484 | |
| 349 | |
| 287 |
