github.com/dbt-labs/dbt-snowflake issues | Ecosyste.ms: OpenCollective

[Feature] Include database in the Iceberg file path

ms32035 opened this issue 9 days ago

Add new params to quiet mypy, a type ignore doesn't work.

VersusFacit opened this pull request 18 days ago

Fix adapter.get_relation to find quoted case-sensitive relations

prashantpiyush opened this pull request 18 days ago

Point to the current branch for scheduled testing

mikealfare opened this pull request 20 days ago

[Bug] `hard_deletes: new_record` not working as expected

jeremyyeo opened this issue 23 days ago

[Bug] Duplicated query comments for snapshots

mwojcik321 opened this issue 24 days ago

Update default python version for python models

mikealfare opened this pull request 25 days ago

Refactor dbt-snowflake to use `batch` context object instead of `__dbt_internal` variables

QMalcolm opened this issue 25 days ago

`hard_deletes` config and `new_record` option for snapshots

dbeatty10 opened this pull request 26 days ago

[Feature] Support Iceberg table format for dbt Snapshots

maurofloriano opened this issue 26 days ago

[Backport 1.9.latest] Fix refresh_strategy = auto semantics for dynamic tables

github-actions[bot] opened this pull request 27 days ago

Fix refresh_strategy = auto semantics for dynamic tables

VersusFacit opened this pull request 27 days ago

[Regression] Existing Dynamic Tables Are Being Recreated Even Without Full Refresh

gseda19 opened this issue 27 days ago

[Feature] Default external volume not being consider on dbt-snowflake iceberg.

maurofloriano opened this issue 30 days ago

[Backport 1.9.latest] [Refactor] use new model.batch context vars

github-actions[bot] opened this pull request about 1 month ago

[Backport 1.9.latest] support MicrobatchConcurrency capability

github-actions[bot] opened this pull request about 1 month ago

Refactor `node.config.__dbt_internal_*` usage to new `batch.*` context variables

MichelleArk opened this issue about 1 month ago

update libpq-dev dependency to 13.18-0+deb11u1

colin-rogers-dbt opened this pull request about 1 month ago

[Backport 1.9.latest] Use timestamp_tz type in microbatch `delete` DDL

github-actions[bot] opened this pull request about 1 month ago

Enable MicrobatchConcurrency for dbt-snowflake

MichelleArk opened this issue about 1 month ago

support MicrobatchConcurrency capability

MichelleArk opened this pull request about 1 month ago

[Refactor] use new model.batch context vars

MichelleArk opened this pull request about 1 month ago

Use timestamp_tz type in microbatch `delete` DDL

MichelleArk opened this pull request about 1 month ago

Cleanup main after cutting new 1.9.latest branch

FishtownBuildBot opened this pull request about 1 month ago

[Bug] dbt-snowflake opens a new connection per each model

TiansuYu opened this issue about 1 month ago

Adap 209/update iceberg docs note

VersusFacit opened this pull request about 2 months ago

[Bug] `dbt build --empty` results in a SQL compilation error when joining unaliased models

amardatar opened this issue about 2 months ago

ADAP-1115: Move to `hatch` and `pyproject.toml`

mikealfare opened this pull request about 2 months ago

[BUG] 'str' object has no attribute 'get' with externalbrowser authentication

javierpe27 opened this issue about 2 months ago

[Bug] Impossible to use adapter.get_relation to find quoted case-sensitive relations in Snowflake

TerjeRusska opened this issue about 2 months ago

[Bug] dbt snowflake no longer works for microbatch

sarahjryan opened this issue about 2 months ago

move github runner from macos-12 to macos-14

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

move github runner from macos-12 to macos-14 (#1230)

mikealfare opened this pull request about 2 months ago

Update unit test mocks to handle the new `query_id` field

mikealfare opened this pull request about 2 months ago

Remove dev branch dependencies from dev requirements

mikealfare opened this pull request about 2 months ago

Make `list_relations_without_caching` pagination configurable

mikealfare opened this pull request about 2 months ago

[Bug] `dbt-snowflake` raises an error when caching less than the maximum number of objects in a schema

mikealfare opened this issue about 2 months ago

remove SnowflakeAdapterResponse in favor of updated AdapterResponse in base

colin-rogers-dbt opened this pull request about 2 months ago

Add adapter.quote call around column names in alter_relation_add_remove_columns

skadyan opened this pull request about 2 months ago

[Bug] Adding a column with on_schema_change=(append_new_columns, sync_all_columns) fails when the column name contains whitespace

skadyan opened this issue about 2 months ago

[Bug] Microbatch timestamps incorrectly offset for system timezone in Snowflake

bthomson22 opened this issue 2 months ago

move github runner from macos-12 to macos-14

colin-rogers-dbt opened this pull request 2 months ago

Normalize is_iceberg Field for Consistency in Snowflake with QUOTED_IDENTIFIERS_IGNORE_CASE

VersusFacit opened this pull request 2 months ago

[Bug] Setting the enable_iceberg_materializations flag to True on a dbt project that is connected to a Snowflake account with QUOTED_IDENTIFIERS_IGNORE_CASE = true results in error tuple.index(x): x not in tuple

Tonayya opened this issue 2 months ago

[Feature] Support Open Catalog (Polaris) Integration

colin-rogers-dbt opened this issue 2 months ago

Revert requirements.

VersusFacit opened this pull request 2 months ago

[Feature] Add the ability to create tables and views with a row access policy.

greenantim2 opened this issue 2 months ago

[Bug] Python Model Error Upgrading to dbt Cloud Versionless: Using snowflake.snowpark.session.create_dataframe() method

jha-aurora opened this issue 2 months ago

Add url.

VersusFacit opened this pull request 2 months ago

[Backport 1.4.latest] Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

[Backport 1.5.latest] Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

[Backport 1.6.latest] Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

[Backport 1.7.latest] Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

[Bug] target_lag < 1 minute throws an error

noel opened this issue 3 months ago

[Backport 1.8.latest] Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

Feature/external catalog config

colin-rogers-dbt opened this pull request 3 months ago

fix: [microbatch] delete redundant using clause

ugmuka opened this pull request 3 months ago

add query_id to SQLQueryStatus (demonstration only)

cmcarthur opened this pull request 3 months ago

Add query tag back to incremental models

mikealfare opened this pull request 3 months ago

Drop support for Python 3.8

mikealfare opened this pull request 3 months ago

adding transient dynamic table capabilities

jhsb25 opened this pull request 3 months ago

[Bug] Cartesian Join based deletion is causing performance problems when it hits a certain scale for microbatch models

graciegoheen opened this issue 3 months ago

Add snowflake telemetry.

VersusFacit opened this pull request 3 months ago

[Feature] Support ordering on Incremental Materializations

danielefrigo opened this issue 3 months ago

Add database role support

seediang opened this pull request 3 months ago

[Feature] Support for database roles

seediang opened this issue 3 months ago

[Bug] Using `--empty` Flag with `dynamic_table` Materialization Results in Snowflake Error

lloydbranch opened this issue 3 months ago

[Backport 1.8.latest] [Bug] Fix scenarios where `--empty` flag pushes `limit 0` into metadata queries

github-actions[bot] opened this pull request 3 months ago

Upgrade py38 objects in Snowflake

colin-rogers-dbt opened this issue 3 months ago

Add various snapshot config tests to test_simple_snapshot.py

gshank opened this pull request 3 months ago

Fix Dynamic Iceberg Table Required DDL Params

VersusFacit opened this pull request 3 months ago

[Bug] dynamic iceberg tables don't build without base_location_subpath option

VersusFacit opened this issue 3 months ago

[Feature] Ability to specify CATALOG_SYNC for Iceberg table materialization

sfc-gh-dyaroshenko opened this issue 3 months ago

[Feature] Incremental strategies for delete+insert and microbatch cause unnecessary cross joins

SystemOfaDrow opened this issue 3 months ago

Update database role tests to avoid colliding with parallel test runs

mikealfare opened this pull request 3 months ago

Add test for 321/support all on schema change options

VersusFacit opened this pull request 3 months ago

Adap 321/support all on schema change options

VersusFacit opened this pull request 3 months ago

Adap 321/add iceberg incremental models

VersusFacit opened this pull request 3 months ago

update dbt-common dependency to 1.10 and dbt-adapters to 1.7

colin-rogers-dbt opened this pull request 3 months ago

[Microbatch] Optimizations: use view for temp relation + remove `using` clause during delete statement

MichelleArk opened this pull request 3 months ago

[Feature] Support calling `dbt.config.get()` inside another `dbt.config()` call

jeremyyeo opened this issue 3 months ago

Add logic to enable iceberg incremental tables.

VersusFacit opened this pull request 3 months ago

Add required 'begin' config for testing microbatch models

MichelleArk opened this pull request 3 months ago

[Bug] Fix issue where `dbt-snowflake` attempts to drop database roles during grants sync

mikealfare opened this pull request 4 months ago

Dynamic Table testing improvements

mikealfare opened this pull request 4 months ago

Dynamic Table testing improvements

mikealfare opened this pull request 4 months ago

Remove a macro that is entirely a docstring

mikealfare opened this pull request 4 months ago

Throw error when building Iceberg tables without behavior flag set

VersusFacit opened this pull request 4 months ago

Add support for Iceberg table format in Dynamic Tables

mikealfare opened this pull request 4 months ago

[dbt-snowflake] Microbatch strategy

MichelleArk opened this issue 4 months ago

[Bug] [SPIKE] Root Cause Analysis of quoting/case handling issues

colin-rogers-dbt opened this issue 4 months ago

[Regression] [Bug] Incorrect column order in view after successful job run

crystalro0 opened this issue 4 months ago

Microbatch strategy

MichelleArk opened this pull request 4 months ago