• Documentation
    • Search documentation
    karat

    +

    K

    API Reference ↗
    Data connectivity & integrationAvailable connectorsAWS Redshift

    AWS Redshift

    Connect Foundry to Amazon Redshift to read and write data between Redshift databases and Foundry datasets.

    Supported capabilities

    CapabilityStatus
    Exploration🟢 Generally available
    Batch syncs🟢 Generally available
    Incremental🟢 Generally available
    Table exports🟡 Beta

    Data model

    The connector transfers relational data from Redshift tables into Foundry datasets. Schemas and data types are preserved during transfer. You can also export Foundry datasets to Redshift tables.

    Performance and limitations

    Performance depends on the size of your Redshift cluster and network conditions. Foundry uses Redshift's efficient data transfer mechanisms to optimize performance.

    Network connectivity between your Foundry instance and AWS Redshift cluster is required. This may require VPC peering, AWS PrivateLink, or public Internet access with proper security configurations.

    Setup

    1. Open the Data Connection application and select + New Source in the upper right corner of the screen.
    2. Select AWS Redshift from the available connector types.
    3. Choose to use a direct connection over the Internet or to connect through an agent runtime.
    4. Follow the additional configuration prompts to continue the setup of your connector using the information in the sections below.

    Learn more about setting up a connector in Foundry.

    Configuration options

    The following configuration options are available for the AWS Redshift connector:

    OptionRequired?Description
    EndpointYesThe endpoint to use to access Redshift (for example, redshift.us-east-1.amazonaws.com)
    PortYesThe port to connect to Redshift (default: 5439)
    DatabaseYesThe name of the Redshift database
    UsernameYesUsername for authentication
    PasswordYesPassword for authentication
    JDBC propertiesNoAdd property names and values to configure connection behavior. Learn more about JDBC properties below.

    JDBC properties

    You can optionally add properties ↗ to your JDBC connection to configure behavior. Refer to the AWS documentation for additional available JDBC properties to add to your connection configuration.

    Cloud identity configuration

    Cloud identity authentication allows Foundry to access resources in your AWS instance. Cloud identities are configured and managed at the enrollment level in Control Panel. Learn how to configure cloud identities.

    When using cloud identity authentication, the Role ARN will be displayed in the credentials section. After selecting the Cloud identity credential option, you must also configure the following:

    1. Configure an Identity and Access Management (IAM) role in the target Amazon AWS account.
    2. Grant the IAM role access to the Redshift cluster to which you wish to connect. You can generally do this with a bucket policy ↗.
    3. In the Redshift source configuration details, add the IAM role under the Security Token Service (STS) role ↗ configuration. The cloud identity IAM role in Foundry will attempt to assume the AWS Account IAM role ↗ when accessing Redshift.
    4. Configure a corresponding trust policy ↗ to allow the cloud identity IAM role to assume the target AWS account IAM role.

    Table export configuration options

    When exporting data to Redshift tables, records are inserted in batches for better performance. The default batch size is 1,000 records, but this can be configured up to 100,000 records per batch depending on your performance needs and data characteristics. For more information about table export configuration options, review our documentation.