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
Syntax
CREATE POSTGRES CONNECTION  
    <connection_identifier> 
    CONNECTION_STRING = '<connection_string>' 
    USER_NAME = '<user_name>'
    PASSWORD = '<password>' 
    [ COMMENT = '<comment>' ]
Jump to
​CONNECTION_STRING​
​USER_NAME​
​PASSWORD​
​COMMENT​
Connection options
CONNECTION_STRING — editable
Type: text
The connection string to use when connecting to the database. This string can be copied directly from PostgreSQL.
USER_NAME — editable
Type: text
The user to authenticate to the database with.
PASSWORD — editable
Type: text
The password for the user.
COMMENT — editable
Type: text
(Optional) A description or comment regarding this connection.
Example
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'

MySQL

Snowflake

Last modified 14d ago

PostgreSQL

Syntax

Jump to

Connection options

`CONNECTION_STRING` — editable

`USER_NAME` — editable

`PASSWORD` — editable

`COMMENT` — editable

Example