# DatabaseSourceConfiguration
<a name="API_DatabaseSourceConfiguration"></a>

 The top level object for configuring streams with database as a source. 

Amazon Data Firehose is in preview release and is subject to change.

## Contents
<a name="API_DatabaseSourceConfiguration_Contents"></a>

 ** Databases **   <a name="Firehose-Type-DatabaseSourceConfiguration-Databases"></a>
 The list of database patterns in source database endpoint for Firehose to read from.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: [DatabaseList](API_DatabaseList.md) object  
Required: Yes

 ** DatabaseSourceAuthenticationConfiguration **   <a name="Firehose-Type-DatabaseSourceConfiguration-DatabaseSourceAuthenticationConfiguration"></a>
 The structure to configure the authentication methods for Firehose to connect to source database endpoint.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: [DatabaseSourceAuthenticationConfiguration](API_DatabaseSourceAuthenticationConfiguration.md) object  
Required: Yes

 ** DatabaseSourceVPCConfiguration **   <a name="Firehose-Type-DatabaseSourceConfiguration-DatabaseSourceVPCConfiguration"></a>
 The details of the VPC Endpoint Service which Firehose uses to create a PrivateLink to the database.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: [DatabaseSourceVPCConfiguration](API_DatabaseSourceVPCConfiguration.md) object  
Required: Yes

 ** Endpoint **   <a name="Firehose-Type-DatabaseSourceConfiguration-Endpoint"></a>
 The endpoint of the database server.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: String  
Length Constraints: Minimum length of 1. Maximum length of 255.  
Pattern: `^(?!\s*$).+`   
Required: Yes

 ** Port **   <a name="Firehose-Type-DatabaseSourceConfiguration-Port"></a>
The port of the database. This can be one of the following values.  
+ 3306 for MySQL database type
+ 5432 for PostgreSQL database type
Amazon Data Firehose is in preview release and is subject to change.  
Type: Integer  
Valid Range: Minimum value of 0. Maximum value of 65535.  
Required: Yes

 ** SnapshotWatermarkTable **   <a name="Firehose-Type-DatabaseSourceConfiguration-SnapshotWatermarkTable"></a>
 The fully qualified name of the table in source database endpoint that Firehose uses to track snapshot progress.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: String  
Length Constraints: Minimum length of 1. Maximum length of 129.  
Pattern: `[\u0001-\uFFFF]*`   
Required: Yes

 ** Tables **   <a name="Firehose-Type-DatabaseSourceConfiguration-Tables"></a>
 The list of table patterns in source database endpoint for Firehose to read from.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: [DatabaseTableList](API_DatabaseTableList.md) object  
Required: Yes

 ** Type **   <a name="Firehose-Type-DatabaseSourceConfiguration-Type"></a>
The type of database engine. This can be one of the following values.   
+ MySQL
+ PostgreSQL
Amazon Data Firehose is in preview release and is subject to change.  
Type: String  
Valid Values: `MySQL | PostgreSQL`   
Required: Yes

 ** Columns **   <a name="Firehose-Type-DatabaseSourceConfiguration-Columns"></a>
 The list of column patterns in source database endpoint for Firehose to read from.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: [DatabaseColumnList](API_DatabaseColumnList.md) object  
Required: No

 ** SSLMode **   <a name="Firehose-Type-DatabaseSourceConfiguration-SSLMode"></a>
 The mode to enable or disable SSL when Firehose connects to the database endpoint.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: String  
Valid Values: `Disabled | Enabled`   
Required: No

 ** SurrogateKeys **   <a name="Firehose-Type-DatabaseSourceConfiguration-SurrogateKeys"></a>
 The optional list of table and column names used as unique key columns when taking snapshot if the tables don’t have primary keys configured.   
Amazon Data Firehose is in preview release and is subject to change.  
Type: Array of strings  
Length Constraints: Minimum length of 1. Maximum length of 1024.  
Pattern: `^\S+$`   
Required: No

## See Also
<a name="API_DatabaseSourceConfiguration_SeeAlso"></a>

For more information about using this API in one of the language-specific AWS SDKs, see the following:
+  [AWS SDK for C\$1\$1](https://docs.aws.amazon.com/goto/SdkForCpp/firehose-2015-08-04/DatabaseSourceConfiguration) 
+  [AWS SDK for Java V2](https://docs.aws.amazon.com/goto/SdkForJavaV2/firehose-2015-08-04/DatabaseSourceConfiguration) 
+  [AWS SDK for Ruby V3](https://docs.aws.amazon.com/goto/SdkForRubyV3/firehose-2015-08-04/DatabaseSourceConfiguration)