PostgreSQL
This article describes how to create a connection to PostgreSQL using a SQL command.
To write your transformed data into a PostgreSQL table using SQLake, you must first create a connection that provides the appropriate credentials to access your database
CREATE POSTGRES CONNECTION
<connection_identifier>
CONNECTION_STRING = '<connection_string>'
USER_NAME = '<user_name>'
PASSWORD = '<password>'
[ COMMENT = '<comment>' ]
Type:
text
The connection string to use when connecting to the database. This string can be copied directly from PostgreSQL.
Type:
text
The user to authenticate to the database with.
Type:
text
The password for the user.
Type:
text
(Optional) A description or comment regarding this connection.
CREATE POSTGRES CONNECTION postgress_connection
CONNECTION_STRING = 'jdbc:postgresql://cdc2.c02eyuedjkh9.eu-west-1.rds.amazonaws.com:5432/auction'
USER_NAME = 'your username'
PASSWORD = 'your password'
Last modified 14d ago