Copying data across Snowflake databases, schemas from different accounts

McDon — Fri, 15 Nov 2024 23:32:44 GMT

My scenario:

I want to read from:

Snowflake Account/Credentials A, Database A, Schema A, Table A

Then map the data to

Snowflake Account/Credentials B, Database B, Schema B, Table B

Using the Talend documentation example I started with this example

I butchered this and came up with this (which does not work):

Is there any documentation that would help me carry this out?

Ideally, I'm looking for ELT-style components where the Snowflake commands would be submitted as opposed to extracting the data locally and then loading to the new account or database.

Thank you in advance for any information.

Re: Copying data across Snowflake databases, schemas from different accounts

McDon — Tue, 25 Jan 2022 03:04:23 GMT

Anyone?

topic Re: Copying data across Snowflake databases, schemas from different accounts in Talend Studio

Copying data across Snowflake databases, schemas from different accounts

Re: Copying data across Snowflake databases, schemas from different accounts