Importing data from Amazon Redshift

You can import the data from Amazon Redshift to the RapidCanvas platform. For this, you must establish a connection with this database by providing the connect string. After establishing the connection successfully, you can query the database to fetch the data from the available tables and load the data to the platform.

To import data from Amazon Redshift:

1. Hover over the menu icon and select Connectors. The Connectors page is displayed showing the total number of connectors.

   

   Left Nav Data Sources

   The Data connectors screen is displayed.

2. Click the plus icon on the top. You can also use the +New data connector button on the workspace to create a new connection.

   

   New Data Source
3. Click the Amazon RedShift tile.

   

   My Redshift Connect
4. Click Create Connection. The Data connectors configuration page is displayed.

   

   Create Connect Redshift
5. Specify this information to establish connection with Amazon Redshift database and access fetch the data in the table form by querying:

   

   Data Source Config Redshift

   Name: The name of the Data connector.

   Connectstring: The string to connect to the database.

6. Click Test to check if you are able to establish the connection to the Data connector successfully.

7. Click Save to save the database details. You can only pass the query once the Data tab is enabled. This is enabled after successfully testing the connection.

8. Specify this information on the Data tab.

9. Provide the query in the terminal.

10. Click RUN QUERY to run this query and fetch the data from the database. This button is enabled after you enter the query.

Once the connection is established, you can see the data imported from Amazon Redshift to the platform in the table format.

11. Navigate to the Datasets tab to view the projects that are using the datasets fetched from this connector. You can see the datasets exported to this dataset after running the project at the scheduled time in the Data connector as destination section.

1. Click the Schedulers tab to view the jobs in which the connector has been configured as the destination.

You can manage files, datasets, and published outputs for this data connector across different tabs:

• Data Tab: View the dataset retrieved from this data connector.

• Datasets Tab: See the projects where datasets fetched from this data connector have been used.

• Schedulers Tab: View the outputs published to this connector. When creating a scheduler, users can configure an external connector as the destination to publish the generated outputs upon job execution.