Connection Steps

This section explains how to connect Lyftrondata to Redshift.

Establishing a connection

Lyftrondata offers three methods connecting to Redshift. To establish your connection, use the connection strings described below.

Basic

Key	Value	Field
hostname	Redshift hostname	Required
port	Redshift port	Required
database	Redshift database name	Required
username	Redshift Username	Required
password	Redshift Password	Required
Access Key	Redshift Access Key	Required
Secret Key	Redshift Secret Key	Required
Bucket Name	Redshift Bucket Name	Required

Advanced Config:

The JSON represents advanced configuration settings for a Spark application. It contains a list of key-value pairs with corresponding fields and values. The settings include packages needed for the application, file system details, and credentials for accessing resources.

The table summarizes these settings with editable values for some fields.

Key	Value	Field
spark.jars.packages	com.amazon.redshift:redshift-jdbc42:2.1.0.12,com.google.guava:guava:31.1-jre,org.apache.hadoop:hadoop-aws:3.2.2	false
spark.hadoop.fs.s3a.impl	org.apache.hadoop.fs.s3a.S3AFileSystem	false
spark.hadoop.fs.s3a.access.key		false
spark.hadoop.fs.s3a.aws.credentials.provider	org.apache.hadoop.fs.s3a.SimpleAWSCredentialsProvider	false
spark.hadoop.fs.s3a.secret.key		false

Policy:

This JSON represents a single item in a list of policies, with a key "policy". It contains a text field for specifying a bucket policy.

Key	Text	Type
policy	Policy	Required

Quickstart Steps

Do you have questions about how to use the platform? Don't worry; we've got you covered. Simply follow the quickstart instructions here.

Questions?

We're always happy to help with any other questions you might have! Set up a meeting with our experts.