Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Feature] transient dynamic tables #716

Open
3 tasks done
homerunner-mqp opened this issue Jun 17, 2024 · 7 comments
Open
3 tasks done

[Feature] transient dynamic tables #716

homerunner-mqp opened this issue Jun 17, 2024 · 7 comments
Assignees
@colin-rogers-dbt
Labels
feature:dynamic-tables Issues related to dynamic tables in Snowflake pkg:dbt-snowflake Issue affects dbt-snowflake type:enhancement New feature request

Comments

@homerunner-mqp
Copy link

Is this your first time submitting a feature request?

  • I have read the expectations for open source contributors
  • I have searched the existing issues, and I could not find an existing issue for this feature
  • I am requesting a straightforward extension of existing dbt-snowflake functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Could we implement the "transient" table config to dynamic tables? Follows same pattern as for tables.
https://docs.snowflake.com/en/sql-reference/sql/create-dynamic-table

Describe alternatives you've considered

None.

Who will this benefit?

For cases of dynamic tables as output from a data warehouse, it could decrease cost.

Are you interested in contributing this feature?

Possibly

Anything else?

No response
@homerunner-mqp homerunner-mqp added type:enhancement New feature request triage:product In Product's queue labels Jun 17, 2024
@dataders dataders added the feature:dynamic-tables Issues related to dynamic tables in Snowflake label Jul 16, 2024
@amychen1776 amychen1776 removed the triage:product In Product's queue label Jul 24, 2024
@bpruss
Copy link

bpruss commented Sep 25, 2024

I just realized that transient dynamic tables will make a huge difference in our failsafe storage.

@andreasbjorshol
Copy link

I just realized that transient dynamic tables will make a huge difference in our failsafe storage.

I have noticed the same. This would make a huge difference and is in line with Snowflake's recommendation for dynamic tables with high refresh throughput.

@jhsb25
Copy link

jhsb25 commented Oct 16, 2024

working on this dbt-labs/dbt-snowflake#1210

@jhsb25
Copy link

jhsb25 commented Oct 18, 2024

waiting for approval but dbt-labs/dbt-snowflake#1210 is good to merge

@jhsb25
Copy link

jhsb25 commented Oct 21, 2024

@dataders can I get an approval on dbt-labs/dbt-snowflake#1210

@colin-rogers-dbt colin-rogers-dbt self-assigned this Nov 6, 2024
@jhsb25
Copy link

jhsb25 commented Nov 8, 2024

@colin-rogers-dbt please can you approve dbt-labs/dbt-snowflake#1210

@amychen1776
Copy link
Contributor

@jhsb25 We are looking at this PR and will update accordingly if we are able to merge this in. Please do not tag adapter maintainers 🙏

@mikealfare mikealfare added the pkg:dbt-snowflake Issue affects dbt-snowflake label Jan 15, 2025
@mikealfare mikealfare transferred this issue from dbt-labs/dbt-snowflake Jan 25, 2025
mikealfare added a commit that referenced this issue Jan 25, 2025
@julio-romero @mikealfare @dbeatty10
Update connections.py so it doesn’t run anything after its canceled (#…
fd28b35 
…716)

* Update connections.py so it doesn’t run anything after its canceled
* Update expected cancellation query
* Changelog entry

---------

Co-authored-by: Mike Alfare <13974384+mikealfare@users.noreply.github.com>
Co-authored-by: Doug Beatty <doug.beatty@dbtlabs.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@colin-rogers-dbt colin-rogers-dbt

Labels
feature:dynamic-tables Issues related to dynamic tables in Snowflake pkg:dbt-snowflake Issue affects dbt-snowflake type:enhancement New feature request
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
8 participants
@bpruss @dataders @mikealfare @jhsb25 @amychen1776 @colin-rogers-dbt @andreasbjorshol @homerunner-mqp