/tmp/train_lng.py:30: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
  df = pd.read_sql("SELECT equipment_id, vibration_rms, inlet_pressure_bar, outlet_pressure_bar, temperature_c, label FROM lng_operating_event", conn)
/home/dagster/.local/lib/python3.12/site-packages/mlflow/types/utils.py:407: UserWarning: Hint: Inferred schema contains integer column(s). Integer columns in Python cannot represent missing values. If your input data contains missing values at inference time, it will be encoded as floats and will cause a schema enforcement error. The best way to avoid this problem is to infer the model schema based on a realistic data sample (training dataset) that includes missing values. Alternatively, you can declare integer columns as doubles (float64) whenever these columns may have missing values. See `Handling Integers With Missing Values <https://www.mlflow.org/docs/latest/models.html#handling-integers-with-missing-values>`_ for more details.
  warnings.warn(
[step2] Trino fetch lng_operating_event
[step2] rows=12000, anomaly_rate=0.0535
[step2] precision=1.000 recall=0.935 f1=0.966 roc_auc=1.000
[step2] experiment_id=2
[step2] run_id=939eb79b693e48ec92cfd656cade3f27
[step2] artifacts uploaded
{
  "run_id": "939eb79b693e48ec92cfd656cade3f27",
  "version": "1",
  "precision": 1.0,
  "recall": 0.9345794392523364,
  "f1": 0.966183574879227,
  "roc_auc": 1.0,
  "model_uri": "models:/anomaly-lng@Production",
  "artifact_uri": "s3://mlflow-artifacts/2/939eb79b693e48ec92cfd656cade3f27/artifacts/model"
}