Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Table Load from Different Database

Hi,

I want to load table from one database to another database in matillion...

It is possible to load table...

Thanks,

Mathan.

3 Community Answers

Matillion Agent  

Laura Malins —

Hi Mathan

Do you mean load data from another Redshift database? We have an article on that:

https://redshiftsupport.matillion.com/customer/portal/articles/2676131?b_id=8915

Thanks
Laura


Mathan Selvaraj —

Hi Laura,

what i'm asking means..

My table input like one database and to send data to another database table table output..

It is possible to access multi database in single envirnoment

Thanks,

Mathan


Matillion Agent  

Laura Malins —

Hi Mathan

Unfortunately that’s not possible. For Transformation purposes all data in Redshift needs to be in the same database on the same cluster. You can move between schemas but not between databases.

In order to transform data from 2 different Redshift databases you would need to stage data from one database to the database your environment is using as per the article I referenced above.

Thanks
Laura

Post Your Community Answer

To add an answer please login