Connecting Amazon Redshift in Bold Data Hub

Published:

Updated:

Connect Amazon Redshift in Bold Data Hub

Amazon Redshift is a cloud-based data warehouse from AWS that uses SQL to analyze large datasets. It’s known for fast query performance, easy scalability, and deep integration with other AWS services. Redshift is widely used for business intelligence, analytics, and big data processing.

Connection Properties

In a YAML file, the config section contains the following properties:

connectorname: RedShift
schemaname: <>
host: <>
port: <>
username: <>
database: <>
password: <>

Example Configuration

version: 1.0.1
destination: 
plugins:
 extractors:
   - name: RedShift
     connectorname: RedShift
     schemaname: public
     config:
       host: hostname
       port: 5439
       username: user
       database: database
       password: password
     select:
       - tablename

Configure the Bold Data Hub to connect Amazon Redshift

Click the Data Hub icon on the Navigation Pane.
Click Add Pipeline and provide the new pipeline name.
Select the newly created pipeline and add the Amazon Redshift template.

Configuration Parameters

Parameters	Description
Host:	Specify the hostname of the Amazon Redshift server.
Port:	Specify the port number of the Amazon Redshift server (default is 3306).
Username:	Provide the username to authenticate with the Amazon Redshift server.
Password:	Provide the password to authenticate with the Amazon Redshift server.
Database:	Specify the name of the Amazon Redshift database from which data will be extracted.
Select:	Tablename(s): Specify the table name list to load tables from the Amazon Redshift server.

Update the details required in the template and Click Save, choose the desired destination to save the pipeline.
Navigate to the logs tab to check the logs for any updates or errors.

The data source created using Data Hub can now be utilized in Bold Reports.

Was this article useful?

Dislike

Comments (0)