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

Adds refresh mode to snowflake-dbt

matsavage opened this pull request 7 months ago

[Feature] Refresh mode for dynamic tables

matsavage opened this issue 7 months ago

[Tech Debt] Fix dynamic table tests

mikealfare opened this pull request 7 months ago

[Tech Debt] Fix DT testing that should be automated

mikealfare opened this issue 7 months ago

add retry to reduce flakiness of TestSecrets

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

[Feature] Improve key-pair auth performance

colin-rogers-dbt opened this issue 7 months ago

[Bug] dbt unit tests raise an error when `QUOTED_IDENTIFIERS_IGNORE_CASE = true` in Snowflake

ivanroquev opened this issue 7 months ago

Add `refresh_mode` and `initialize` as dynamic table options

mikealfare opened this pull request 7 months ago

Skip with reason dynamic table tests with reference to PR.

VersusFacit opened this pull request 7 months ago

[Feature] Support JWT Authentication

llam15 opened this issue 7 months ago

[ENTERPRISE-1418] Add support for plain JWT authentication

llam15 opened this pull request 7 months ago

Update nightly-release.yml to use 1.8.latest

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

[Backport 1.8.latest] quoting config not working with 1.8

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

quoting config not working with 1.8

McKnight-42 opened this pull request 7 months ago

[Bug] `quoting` config not working with 1.8

jeremyyeo opened this issue 8 months ago

Update 1.8 changelog to include reference to 1.7 changelog

AartBluestoke opened this pull request 8 months ago

[Bug] Silent SSO token expiration

mikealfare opened this pull request 8 months ago

[Bug] Seed file already exists when I run dbt-build with full refresh model

Evelyn-yx-Li opened this issue 8 months ago

Add tests to see if pre_model_hook works for tests around snowflake_warehouse

McKnight-42 opened this pull request 8 months ago

[Feature] Replace underscores with hyphens in account ids

colin-rogers-dbt opened this issue 8 months ago

[Bug] Replace underscores with hyphens in account identifiers

jtcohen6 opened this issue 8 months ago

replace underscores with hyphens in account ids

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

[Bug] `not_null` constraint only has effect when specified at the column level

matt-winkler opened this issue 8 months ago

[Bug] list_relations_without_caching & proxy & no-populate-cache

tsaastam opened this issue 8 months ago

Implement `get_catalog_for_single_relation` macro

aranke opened this pull request 8 months ago

Adap 953/merge agate lazy load

VersusFacit opened this pull request 8 months ago

Setup terraform for Snowflake CI instance

mikealfare opened this pull request 8 months ago

[Feature] metadata-based freshness checks for external tables

dataders opened this issue 8 months ago

[Bug] Use fully qualified names in rename for tables and views

mikealfare opened this pull request 8 months ago

[Feature] add functional test to cover new cover new custom config for tests.

McKnight-42 opened this issue 8 months ago

SPIKE: external table as model materialization

dataders opened this pull request 8 months ago

[Backport 1.7.latest] Dynamic tables with Snowflake change bundle 2024_03 results in dynamic table to issue

mikealfare opened this pull request 8 months ago

[Backport 1.8.latest] Dynamic tables with Snowflake change bundle 2024_03 results in dynamic table to issue

mikealfare opened this pull request 8 months ago

[Bug] is a dynamic table a table?

AartBluestoke opened this issue 8 months ago

[Feature] Allow snowflake__get_relation_last_modified to references models or sources

sp-tkerlavage opened this issue 8 months ago

Improve Memory Efficiency of process_results() Override

peterallenwebb opened this issue 8 months ago

[Bug] macros have no way to execute a query with a contained semicolon.

AartBluestoke opened this issue 8 months ago

[Feature] force correct 'use' when deploying

AartBluestoke opened this issue 8 months ago

Improve the memory efficiency of process_results() override

peterallenwebb opened this pull request 8 months ago

[Bug] Update `list_relations_without_caching` to support Snowflake bundle `2024_03`

mikealfare opened this pull request 8 months ago

Allow enabling/disabling stats collection on catalog table using env var

aranke opened this pull request 8 months ago

[Bug] _dbt_backup suffixed tables don't drop for dynamic tables

j-choe opened this issue 8 months ago

Performance test `show objects` vs `show terse objects`

mikealfare opened this pull request 8 months ago

remove duplicate package version and avoid bumping dbt-core version (#1044)

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

remove duplicate package version and avoid bumping dbt-core version

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

spike external table materialization for sources

dataders opened this pull request 8 months ago

[Bug] missing @dataclass decorator from both `SnowflakeRelationType` `SnowflakeIncludePolicy

dataders opened this issue 8 months ago

[Backport 1.8.latest] Bump deps on common, adapters, core

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

[SPIKE] Investigate treating dynamic tables as `RelationType.Table`

dataders opened this issue 8 months ago

Bump deps on common, adapters, core

jtcohen6 opened this pull request 8 months ago

SPIKE: Validate acceptable performance for switching `show terse objects` -> `show objects` to enable dynamic table detection

jtcohen6 opened this issue 8 months ago

[Backport 1.7.latest] Speedup catalog string comparison by using ilike before equals

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

[Backport 1.8.latest] Speedup catalog string comparison by using ilike before equals

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

[Bug] `snowflake__get_catalog_schemas_where_clause_sql` is very slow

aranke opened this issue 8 months ago

[Feature] dbt docs generate is slow against snowflake database with numerous schema (~200) and could be improved

extrospective opened this issue 8 months ago

[Bug] --empty doesn't work when using get_columns_in_relation

georgea-tk opened this issue 8 months ago

[Bug] AuthByKeyPair.prepare() takes 1 positional argument but 3 were given

mmyers5 opened this issue 8 months ago

[Bug] Use qualified names in `snowflake__get_rename_x_sql` macros

jtcohen6 opened this issue 8 months ago

[Feature] copy_grants option for seeds (for use in Snowflake Data Share)

sarah-tuva opened this issue 8 months ago

update test_anonymous_usage_stats.py

McKnight-42 opened this pull request 8 months ago

[Bug] DBT Creating Backup Dynamic Tables in Snowflake

kylienhu opened this issue 8 months ago

[Bug] Dynamic table full refresh table creation fails

eayursed opened this issue 9 months ago

Update CODEOWNERS

mikealfare opened this pull request 9 months ago

Update dev-requirements.txt to use common@main

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

[Feature] Support Snowflake China host OAuth connection snowflakecomputing.cn

AndrewCanva opened this issue 9 months ago

Cleanup main after cutting new 1.8.latest branch

FishtownBuildBot opened this pull request 9 months ago

Cleanup main after cutting new 1.8.latest branch

FishtownBuildBot opened this pull request 9 months ago

Mcknight/is dyanmic update

McKnight-42 opened this pull request 9 months ago

Update is_dyanmic check for new accpetable value after snowflake bundle change `2024_03`

McKnight-42 opened this pull request 9 months ago

[Backport 1.8.latest] Remove field.

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

Remove field.

VersusFacit opened this pull request 9 months ago

[Bug] Existing dynamic tables attempted to rebuild instead of issuing a fast `alter` and moving on

nydnarb opened this issue 9 months ago

[Bug] Dynamic tables with Snowflake change bundle `2024_03` results in dynamic table to issue

jeremyyeo opened this issue 9 months ago

Cleanup main after cutting new 1.8.latest branch

FishtownBuildBot opened this pull request 9 months ago

Cleanup main after cutting new 1.8.latest branch

FishtownBuildBot opened this pull request 9 months ago

Cross-database `date` macro

dbeatty10 opened this issue 9 months ago

Revert "Prefix secrets with DBT_ENV_SECRET_ for test env vars"

mikealfare opened this pull request 9 months ago

Cross-database `date` macro

dbeatty10 opened this pull request 9 months ago

Import relevant pytest(s) for cross-database `cast` macro

dbeatty10 opened this pull request 9 months ago

Import relevant pytest(s) for cross-database `cast` macro

dbeatty10 opened this issue 9 months ago

Update pin for `dbt-adapters` as reflected in #928

mikealfare opened this pull request 9 months ago

Bump actions/download-artifact from 3 to 4

dependabot[bot] opened this pull request 9 months ago

Bump dbt-labs/actions from 1.1.0 to 1.1.1

dependabot[bot] opened this pull request 9 months ago

Bump ubuntu from 22.04 to 24.04 in /docker

dependabot[bot] opened this pull request 9 months ago

[CI/CD Improvements] Migrate to `hatch` and standardize workflows

mikealfare opened this issue 9 months ago

[Bug] `test_python_model.py::TestSecrets::test_secrets` is failing in some scenarios

mikealfare opened this issue 9 months ago

Allow specifying 'application' for Snowflake in profiles.yaml

NehaNRane opened this pull request 9 months ago

Allow specifying 'application' for Snowflake in profiles.yaml

NehaNRane opened this pull request 9 months ago

Allow specifying 'application' for Snowflake in profiles.yaml

NehaNRane opened this pull request 9 months ago

Parametrizing application name for more flexibility

PrantikTechie opened this pull request 9 months ago

Parametrizing application name for more flexibility

PrantikTechie opened this pull request 9 months ago

Parametrizing application name for more flexibility

PrantikTechie opened this pull request 9 months ago

Move to `pre-commit` only

mikealfare opened this pull request 9 months ago

Prefix secrets with DBT_ENV_SECRET_ for test env vars

mikealfare opened this pull request 9 months ago

[Backport 1.0.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago

[Backport 1.1.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago

[Backport 1.2.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago

[Backport 1.3.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago

[Backport 1.4.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago

[Backport 1.5.latest] Pin `macos` runners to `macos-12` (#985)

mikealfare opened this pull request 9 months ago