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

Ability to Run Various Snowflake Op Commands #33

Open
wesseljt opened this issue Aug 30, 2023 · 0 comments
Open

Ability to Run Various Snowflake Op Commands #33

wesseljt opened this issue Aug 30, 2023 · 0 comments

Comments

@wesseljt
Copy link

I'm thinking of a use case where I want to unload data from snowflake to s3 -- but I don't want to pull the files locally first. I would want meltano to be able to issue something like:

COPY INTO X @Stage from table1
COPY INTO X @Stage from table2
COPY INTO X @Stage from table3
COPY INTO X @Stage from table4
etc.

then return some kind of success or failure after the command completes in snowflake. I'm currently planning to do this by scheduling tasks in snowflake - but would love the visibility of having this in meltano.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: No status
Development

No branches or pull requests

1 participant