Uploading retool database's table to aws rds

Queries and Resources
,
1

  • Goal:
    I am update pre-existing / create new table in AWS RDS using local retool database tables.

  • Steps:
    I created a postgreSQL component that allows me to write to the RDS I want to use, but I cannot seem to pull data from retool database in the same query. I am not sure how to achieve my goal anymore. Essentially, I want something like:

  • Details:
    CREATE TABLE1 AS
    SELECT
    *
    FROM retooldb.table2

  • Screenshots:

  • App json export:

2

Hello @314tko!

There definitely is a way for you to migrate your data from Retool DB to AWS RDS.

But it will likely need to be broken up into two queries. One will select the data from the Retool DB table. The second query will be to either create sand insert the data from your Retool table to the AWS DB table.

Or you can manually create the table in AWS and then just insert the data from Retool. Be sure to have the DB schema set up properly.

You can read more about Retool migrations on our docs here!

Which AWS service are you thinking of having your DB tables on?