Setup Guide
Steps
Enter a Connection Name, excluding whitespace and special characters
Enter Cluster Endpoint as Server (e.g. "cluster-name".cluster-xxxxxxxxxxxx."region".docdb.amazonaws.com)
Enter the port number for your primary node
Enter the user detail
Enter the password for the user you entered previously
If you selected Connect via an SSH, provide the following information
SSH Server
SSH Port
SSH User
If you have disabled SSL/TLS on your database, uncheck the Require TLS
By default, the Flatten object properties into columns of their own is checked. If your document fields keep changing frequently please uncheck this option otherwise you might see an Invalid column name error randomly as that column might not be available when we run the job next time.
By default, the Type Detection Method will be 'RowScan' where we will scan 100 rows to heuristically determine the data type and columns. If you have mixed types of data(e.g. date and string or numeric in one column) then select 'None', It will return all columns as the string type. Note: You can only use replace mode if you are selecting 'None' as a Type Detection Method.
By default, the Rows to scan to look for the columns available will be 100 rows to heuristically determine the data type and columns. If you don't see your field in the column list you can increase the value. Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly.
When you're happy with your settings, click Save -> Test -> Publish
Permissions
Please make sure the user has access to the below actions
listDatabases
listCollections
Last updated