[ADAP-517] [Bug] latest and 1.x.latest tags for ghcr Docker releases are stale

[scotthenley]

Is this a new bug in dbt-snowflake?

• I believe this is a new bug in dbt-snowflake
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Look at https://github.com/dbt-labs/dbt-snowflake/pkgs/container/dbt-snowflake/versions?filters%5Bversion_type%5D=tagged

1.3.0 container image is still tagged as "latest":

Expected Behavior

The most recent stable image version should be tagged as "latest"

Steps To Reproduce

1. Look at https://github.com/dbt-labs/dbt-snowflake/pkgs/container/dbt-snowflake
2. 1.3.0 is tagged as latest.

Relevant log output

No response

Environment

- OS:
- Python:
- dbt-core:
- dbt-snowflake:

Additional Context

This is related to #564

I posted a question in the discussions section on March 17 inquiring about this.

[dbeatty10]

Thanks for reaching out @scotthenley !

I'm not sure if this got fixed in the last couple hours, but this is showing 1.5.0 for me:

And so is here:

Could you take a look again and see if this is fixed for you as well?

[scotthenley]

Hi @dbeatty10

I am still seeing the "latest" tag on the 1.3 image. We use the tag to pull the most recent stable version for various CI processes rather than pinning to a version number.

https://github.com/dbt-labs/dbt-snowflake/pkgs/container/dbt-snowflake/versions?filters%5Bversion_type%5D=tagged

[dbeatty10]

Thanks for that @scotthenley -- I see what you are saying!

I'm guessing this is affecting other dbt adapters as well (dbt-bigquery here, etc).

We've been iterating on our release processes, and this piece probably got lost along the way.

Thank you for letting us know so we can get this up-to-date 🙏

[gxpd-jjh]

@dbeatty10 It is still showing latest as v1.3.0.

[mikealfare]

From what we can tell, this tag is being deprecated and we cannot adjust it. Closing as "can't do".

[dbeatty10]

dbt-labs/dbt-core#9495 fixes the underlying issue (thank you @mikealfare !), and this particular issue will be resolved for each 1.x version of this adapter upon its next patch release.

We are choosing not to address any un-supported versions at this time, so <=1.4.x will not be updated.

Here are the most recent ones for the supported versions of dbt-snowflake in PyPI:

• 1.7.1
• 1.6.6
• 1.5.6

So this will be completely resolved for >=1.5.x when each of the following are released (but only if each is released prior to falling out of support):

• 1.7.2
• 1.6.7
• 1.5.7

[dbeatty10]

Screenshot of latest and 1.7.latest: