v1.0.0-rc.6

Fixed

• In the Snowflake dialect, UPDATE and MERGE accept the target's name or
  alias on the columns SET assigns, as Snowflake does: UPDATE t SET t.a = 1
  and MERGE ... WHEN MATCHED THEN UPDATE SET m.ver = m.ver + 1 failed with
  Qualified column names in UPDATE .. SET not supported.

Install

Container image (linux/amd64, linux/arm64):

docker pull ghcr.io/akkio-inc/igloo:1.0.0-rc.6
# digest: sha256:e203e0439cacc8cadf48f4a8a6d10dde7fb0f78f9520efdc8e98496393b350eb

Helm chart:

helm install igloo oci://ghcr.io/akkio-inc/charts/igloo --version 1.0.0-rc.6

Verify the image signature and build provenance:

cosign verify ghcr.io/akkio-inc/igloo@sha256:e203e0439cacc8cadf48f4a8a6d10dde7fb0f78f9520efdc8e98496393b350eb \
  --certificate-identity https://github.com/akkio-inc/Igloo/.github/workflows/release.yml@refs/tags/v1.0.0-rc.6 \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com
gh attestation verify oci://ghcr.io/akkio-inc/igloo@sha256:e203e0439cacc8cadf48f4a8a6d10dde7fb0f78f9520efdc8e98496393b350eb --repo akkio-inc/Igloo

v1.0.0-rc.4

Fixed

• The catalog views (information_schema.columns, pg_attribute,
  duckdb_columns()) list the columns an ALTER TABLE changed as soon as it
  commits, in every session. They listed a table as a statement had last
  loaded it, so a client that reflected after its DDL, as SQLAlchemy and
  Alembic do, saw the old columns until a later statement loaded the table,
  and ten ADD COLUMNs in a row listed the first nine.
• With credentials from the AWS chain (IAM roles for service accounts),
  statements and commits no longer fail with Catalog write-write conflict on alter with "igloo_storage" when the credentials expire. DuckDB replaced
  them inside the transaction of whichever statement found them expired, and
  two sessions doing so at once conflicted. Igloo now replaces them every 10
  minutes, outside every transaction.
• Igloo's own reads of table files with credentials from the AWS chain, such
  as planning statements for workers and maintenance, no longer go without
  credentials for the last minute of each set's life. Its refresh ahead of
  their expiry asked the AWS SDK's cache, which gave the same credentials back
  until they had expired.
• The image builds on a machine of 6 GB. Its two C++ extensions ran a
  compile a core, or, for rb, all eleven at once, and the compiler was killed
  for memory. Each build now runs as many compiles at once as memory holds:
  1 GiB each for rb, and 2 GiB each for DuckDB and the iceberg extension. In
  6 GB on 4 cores the iceberg build took 26 minutes and peaked at 2.9 GB.

Install

Container image (linux/amd64, linux/arm64):

docker pull ghcr.io/akkio-inc/igloo:1.0.0-rc.4
# digest: sha256:8528fd06c687acd412b349f98fbc86b7df02a46c62ae9ca2cc0492a67dafe4f0

Helm chart:

helm install igloo oci://ghcr.io/akkio-inc/charts/igloo --version 1.0.0-rc.4

Verify the image signature and build provenance:

cosign verify ghcr.io/akkio-inc/igloo@sha256:8528fd06c687acd412b349f98fbc86b7df02a46c62ae9ca2cc0492a67dafe4f0 \
  --certificate-identity https://github.com/akkio-inc/Igloo/.github/workflows/release.yml@refs/tags/v1.0.0-rc.4 \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com
gh attestation verify oci://ghcr.io/akkio-inc/igloo@sha256:8528fd06c687acd412b349f98fbc86b7df02a46c62ae9ca2cc0492a67dafe4f0 --repo akkio-inc/Igloo

v1.0.0-rc.2

Igloo's first published release: an open-source SQL data warehouse that runs
in your own cloud account or on your own hardware.

Every change is listed in CHANGELOG.md.

Install

Container image (linux/amd64, linux/arm64):

docker pull ghcr.io/akkio-inc/igloo:1.0.0-rc.2
# digest: sha256:3d2408f4ee46b73238d2ab876378366e62b02c6aa0ddecb79493982dab43f6d9

Helm chart:

helm install igloo oci://ghcr.io/akkio-inc/charts/igloo --version 1.0.0-rc.2

Verify the image signature and build provenance:

cosign verify ghcr.io/akkio-inc/igloo@sha256:3d2408f4ee46b73238d2ab876378366e62b02c6aa0ddecb79493982dab43f6d9 \
  --certificate-identity https://github.com/akkio-inc/Igloo/.github/workflows/release.yml@refs/tags/v1.0.0-rc.2 \
  --certificate-oidc-issuer https://token.actions.githubusercontent.com
gh attestation verify oci://ghcr.io/akkio-inc/igloo@sha256:3d2408f4ee46b73238d2ab876378366e62b02c6aa0ddecb79493982dab43f6d9 --repo akkio-inc/Igloo