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.

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

Add SHOW_INITIAL_ROWS parameter to STREAM resource #537

Closed
Anatoli-deBRADKE opened this issue May 6, 2021 · 0 comments
Closed

Add SHOW_INITIAL_ROWS parameter to STREAM resource #537

Anatoli-deBRADKE opened this issue May 6, 2021 · 0 comments
Labels
feature-request Used to mark issues with provider's missing functionalities

Comments

@Anatoli-deBRADKE
Copy link

Anatoli-deBRADKE commented May 6, 2021

Is your feature request related to a problem? Please describe.

At the moment it is not possible to change the value of optional parameter SHOW_INITIAL_ROWS of a snowflake stream resource.

SHOW_INITIAL_ROWS, a boolean parameter, specifies whether to return all existing rows in the source table as row inserts the first time the stream is consumed. The next time the stream is consumed and thereafter, the stream only returns the DML changes to the source table since the most recent offset. This parameter enables initializing any downstream process with the contents of the source table for the stream.

Unfortunately, this parameter has a default value equal to FALSE, and we don't have the possibility to set it to TRUE using the terraform resource.

Describe the solution you'd like

Add the optional boolean parameter SHOW_INITIAL_ROWS to the snowflake_stream resource.

Additional context

Snowflake Stream doc: https://docs.snowflake.com/en/sql-reference/sql/create-stream.html

@Anatoli-deBRADKE Anatoli-deBRADKE added the feature-request Used to mark issues with provider's missing functionalities label May 6, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature-request Used to mark issues with provider's missing functionalities
Projects
None yet
Development

No branches or pull requests

2 participants