Send data from Redshift to your destinations through Freshpaint
- A Freshpaint account
- Connection information for Redshift, including
- Port number
- Database name
- Schema name
With the Redshift source, Freshpaint can sync data from any and all of your tables in Redshift into our SQL Engine. You'll be able to access this data as SQL tables, in the same way you would inside Redshift.
With that data, you can:
- Combine your Redshift data with that of any other source
First, you'll want to locate Redshift on the list of sources:
Click the Configure button, and you'll see a modal that looks like below. Enter your database's host, port number, the name of a database we can connect to, a schema, user, and password.
You can configure the schedule for any frequency you want to sync with our SQL Engine. Once you have your tables configured, you can trigger a new sync to have access to the data in your tables. Your connection should now look something like this:
Redshift is a general data warehouse; the only limit to what data you can pull is what access you provide to the user. Below is a simple example of the SQL you can run in the SQL Editor to see the data in any of your tables.
People use Redshift as a data warehouse. You can use the Redshift source integration to send data to any analytics tool of your choice. Suppose you wanted to sync new accounts to Mixpanel:
account_id AS insert_id,
email AS user_id,
created_at AS time,
A query like this would pull data from an
account_signupstable in Redshift and send that to Mixpanel.
Point-to-Point integrations need you to define the
user_idfor the data to be accepted by your destination. Remember this when you build your own queries! Because you selected
*, you'll see all of your data as properties named for their original columns as well.
You might find yourself in need of bringing data over to a new warehouse. With your Redshift source, you can tap into all of the warehouses you've connected with Freshpaint.
- In order for us to connect with Redshift, it must be configured to be publicly accessible. Additionally, it must be located in a VPC and Security Group that are configured to allow ingress from the Freshpaint IP address 22.214.171.124 to the port that Redshift is listening on.