SQL Server

Connect & Ingest data from / to a SQL Server database

Sling CLI Setup
The following credentials keys are accepted:
host (required) -> The hostname / ip of the instance
user (required) -> The username to access the instance
database (required) -> The database name of the instance
schema (optional) -> The default schema to use
password (optional) -> The password to access the instance
port (optional) -> The port of the instance. Default is 1433.
ssh_tunnel (optional) -> The URL of the SSH server you would like to use as a tunnel (example ssh://user:[email protected]:22)
ssh_private_key (optional) -> The private key to use to access a SSH server.
Here is an example of setting a connection named MSSQL. We must provide the type=sqlserver property:
$ sling conns set MSSQL type=sqlserver host=<host> user=<user> database=<database> password=<password> port=<port>
​
# Or use url
$ sling conns set MSSQL url=sqlserver://myuser:[email protected]:1433/mydatabase
Environment Variable
export MSSQL='sqlserver://myuser:[email protected]:1433/mydatabase'
If you are facing issues connecting, please reach out to us at [email protected].

SQLite

Snowflake

Last modified 1mo ago