table_name is not used in Metrics

[mgdenno]

It seems like the following does not work anymore...This is sued in both notebooks and prefect, and has worked recently. Bug introduced?

sdf = ev.metrics(
    table_name="sim_joined_timeseries"
)

pyspark.errors.exceptions.captured.AnalysisException: [TABLE_OR_VIEW_NOT_FOUND] The table or view teehr.joined_timeseries cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalog.
To tolerate the error on drop use DROP VIEW IF EXISTS or DROP TABLE IF EXISTS. SQLSTATE: 42P01

[mgdenno]

@samlamont thoughts? see the same thing?

[mgdenno]

This seems to work...

sdf = ev.table(
    table_name="sim_joined_timeseries",
    namespace_name="teehr",
    catalog_name="iceberg"
).query(
    group_by=SIM_GROUPBY,
    order_by=SIM_GROUPBY,
    include_metrics=SIM_METRICS
).to_sdf()

[mgdenno]

I really don't see anything that would have caused this since f3815a51f2556b31eedb8390838a238e54db86b0

[samlamont]

Hmm it seems to work for me. These all work in teehr-hub bleeding edge:

# this one:
ev.metrics(table_name="sim_joined_timeseries").to_sdf().show()

# And this one:
sdf = ev.metrics(table_name="sim_joined_timeseries").to_sdf()
sdf.show()

# And metrics calcs like:
ev
.metrics(table_name=joined_forecast_table_name)
.query(
    include_metrics=[
        count,
        rmsdr,
        rbias,
        nse,
        kge
    ],
    group_by=[
        "primary_location_id",
        "secondary_location_id",
        "configuration_name",
        "unit_name",
        "variable_name",
        "member"
    ]
).to_sdf()

Any chance you were still pointing to the local catalog? If you check ev.active_catalog?

[mgdenno]

I also tried building on my personal Linux laptop and it still doesn't work. Very weird. Needs more investigation.