cancel
Showing results for 
Search instead for 
Did you mean: 
Machine Learning
Dive into the world of machine learning on the Databricks platform. Explore discussions on algorithms, model training, deployment, and more. Connect with ML enthusiasts and experts.
cancel
Showing results for 
Search instead for 
Did you mean: 
Data + AI Summit 2024 - Data Science & Machine Learning

Forum Posts

YDB1
by New Contributor
  • 715 Views
  • 0 replies
  • 0 kudos

jupytemplate in databricks

Hi, Most of my notebooks follow the same structure (i.e. load data, preprocessing, learn ML model, evaluate, etc.). I came across the jupytemplate package which allows to define a template for your notebooks. However, I can't seem to make it work in ...

  • 715 Views
  • 0 replies
  • 0 kudos
Jeremy_E
by New Contributor
  • 984 Views
  • 1 replies
  • 1 kudos

Accessing served models from Excel

Anyone know of an Excel plug-in (or code example) that would connect to a databricks serverd model for scoring and present results back in Excel?

  • 984 Views
  • 1 replies
  • 1 kudos
Latest Reply
Aknakshay
New Contributor II
  • 1 kudos

I would create a python program to convert excel into csv or whatever format your model takes as input and use that input for the model. And vice versa. I can make it for you if you want

  • 1 kudos
sbo
by New Contributor III
  • 904 Views
  • 1 replies
  • 0 kudos

Resolved! Does MLFLOW support the storage of Spark Pipeline API

Does the pipeline api allow for saving an entire transformation pipeline and render the artifacts in MLFLOW.

  • 904 Views
  • 1 replies
  • 0 kudos
Latest Reply
BradC26
New Contributor III
  • 0 kudos

Yes the pipeline API allows pickling of a pipeline which can in fact be stored as an artifact. This allows for easy reproducibility of production pipelines!

  • 0 kudos
Dhara
by New Contributor III
  • 1959 Views
  • 2 replies
  • 0 kudos

Access multiple .mdb files using Python

Hi, I wanted to access multiple .mdb access files which are stored in the Azure Data Lake Storage(ADLS) or on Databricks File System using Python. Can you please help me by guiding how can I do it? It would be great if you can share some code snippet...

  • 1959 Views
  • 2 replies
  • 0 kudos
Latest Reply
Anonymous
Not applicable
  • 0 kudos

https://community.databricks.com/s/question/0D58Y00008rCmBySAK/access-multiple-mdb-files-using-pythonmyEHtrip Employee Login

  • 0 kudos
1 More Replies
ravi121
by New Contributor III
  • 2684 Views
  • 1 replies
  • 1 kudos

Can't edit the cluster created by mlflow model serving

I'm trying to deploy a ml model into production using mlflow. while in that process, I have registered the model to mlflow models. After that it created the cluster but then it was in pending state forever. when I checked the model events, I see a p...

Screen Shot 2022-05-10 at 5.49.53 PM
  • 2684 Views
  • 1 replies
  • 1 kudos
Latest Reply
Anonymous
Not applicable
  • 1 kudos

Hey @ravi g​ Does @Kaniz Fatma​'s answer help? If it does, would you be happy to mark it as best? If it doesn't, please tell us so we can help you.Thanks!

  • 1 kudos
naveen_marthala
by Contributor
  • 1709 Views
  • 1 replies
  • 2 kudos

What added advantage would using an Sql Alchemy database have, while I have an artifact destination for my MlFlow server?

I am setting up mlflow server with Postgres and S3 on AWS ECS(or AWS EC2) for personal usage. I would like to know if using Postgres would actually give me any benefit?as shown in scenario 5 in docs, I would like to set up server with proxied artifac...

  • 1709 Views
  • 1 replies
  • 2 kudos
Latest Reply
" src="" />
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
  • 2 kudos

This widget could not be displayed.
I am setting up mlflow server with Postgres and S3 on AWS ECS(or AWS EC2) for personal usage. I would like to know if using Postgres would actually give me any benefit?as shown in scenario 5 in docs, I would like to set up server with proxied artifac...

This widget could not be displayed.
  • 2 kudos
This widget could not be displayed.
Mr__E
by Contributor II
  • 3842 Views
  • 2 replies
  • 2 kudos

Resolved! OneHotEncoder fails with 'Cannot have an empty string for name'

I have followed the basic guide on using OneHotEncoder, matching the syntax exactly with my own data tables. The tables have enumerated string values. I first run a StringIndexer (both with and without handleInvalid set):indexer = StringIndexer( ...

  • 3842 Views
  • 2 replies
  • 2 kudos
Latest Reply
EliasHaydar
New Contributor II
  • 2 kudos

Nice catch ! Indeed, the error is misleading. In my case, it was a specific column that had a string with just whitespaces.

  • 2 kudos
1 More Replies
naveen_marthala
by Contributor
  • 9749 Views
  • 6 replies
  • 6 kudos

Resolved! How to start an mlflow server with a postgres backend already filled with metadata of many experiments?

I am experimenting with mlflow in docker containers.I have postgres running on docker. and when I had used an empty database while starting mlflow server, everything worked as expected;2022/05/01 13:57:45 INFO mlflow.store.db.utils: Creating initial ...

  • 9749 Views
  • 6 replies
  • 6 kudos
Latest Reply
Anonymous
Not applicable
  • 6 kudos

A step-by-step guide to setup MLflow with a Postgres DB for storing metadata and a systemd unit to keep it running.Setup MLflow in Production (you are here!)MLflow: Basic logging functions.MLflow logging for TensorFlow.MLflow Projects.Retrieving the ...

  • 6 kudos
5 More Replies
naveen_marthala
by Contributor
  • 4545 Views
  • 3 replies
  • 2 kudos

How to isolate environments for different projects in a single mlflow server?

I am planning to deploy MLFlow server deployed in AWS ECS as a centralised repositories for my machine learning experiments and runs and to strore events and artifacts. I would like to use MLflow Tracking Server enabled with proxied artifact storage ...

  • 4545 Views
  • 3 replies
  • 2 kudos
Latest Reply
Anonymous
Not applicable
  • 2 kudos

You would create a new experiment for each dataset yo just change the name. https://www.mlflow.org/docs/latest/python_api/mlflow.html#mlflow.create_experimentFor a new environment, https://mlflow.org/docs/latest/cli.html#cmdoption-mlflow-models-pred...

  • 2 kudos
2 More Replies
amits
by New Contributor III
  • 3999 Views
  • 6 replies
  • 4 kudos

Tableau extract creation frozen

Heya,I'm having an issue with extract creation from a Delta lake table. Tableau is frozen on "Rows retrieved: X" for too long.I actually succeeded in creating the first extract but saw I was missing a column. I went ahead and did a full rewrite -even...

  • 3999 Views
  • 6 replies
  • 4 kudos
Latest Reply
Prabakar
Databricks Employee
  • 4 kudos

@Amit Steiner​ what is the size of the table. Do you see any error or does Tableau get frozen without any error? I believe this to be more of a Tableau-related issue than Databricks.What is the version of Tableau that you are using? What is the conne...

  • 4 kudos
5 More Replies
jhonw901227
by New Contributor II
  • 941 Views
  • 0 replies
  • 0 kudos

MLflow Model Serving on Azure Databricks

I know that in the documentation about model serving says.The cluster is maintained as long as serving is enabled, even if no active model version exists. To terminate the serving cluster, disable model serving for the registered model.The cluster is...

  • 941 Views
  • 0 replies
  • 0 kudos
Giorgi
by Contributor
  • 3220 Views
  • 1 replies
  • 1 kudos

Resolved! How to read artifact file (CSV) programmatically?

Hello, can I programmatically access artifact file (csv), via artifact_uri and read it?Tried the following, but didn't work, says no such file or directory:mlflow.pyfunc.pandas.read_csv(artifact_uri+'/xgb-classifier-test-8/dataset_statistics.csv')pan...

  • 3220 Views
  • 1 replies
  • 1 kudos
Latest Reply
Giorgi
Contributor
  • 1 kudos

Maybe there are better solutions, here is what I've found:from mlflow.tracking import MlflowClient   client = MlflowClient() pd.read_csv(client.download_artifacts(run_id, "xgb-classifier-test-8/dataset_statistics.csv"))

  • 1 kudos
108387
by New Contributor II
  • 12901 Views
  • 1 replies
  • 1 kudos

Intermittent "Unexpected failure while waiting for the cluster to be ready" Error

We are encountering an occasional issue where jobs may fail with a message like the following:Run result unavailable: job failed with error message Unexpected failure while waiting for the cluster (ID) to be ready.Cause Unexpected state for cluster (...

  • 12901 Views
  • 1 replies
  • 1 kudos
Latest Reply
" src="" />
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
  • 1 kudos

This widget could not be displayed.
We are encountering an occasional issue where jobs may fail with a message like the following:Run result unavailable: job failed with error message Unexpected failure while waiting for the cluster (ID) to be ready.Cause Unexpected state for cluster (...

This widget could not be displayed.
  • 1 kudos
This widget could not be displayed.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group
Labels