SQLServer

Select the “Connectors” tab on the top page and click the “Create” button.

Enter the credentials for the database you want to connect to in the displayed form. If you are connecting via a remote server, check the “SSH” box and fill in the necessary fields.

After entering the information, click the Create button to complete the creation. If there are any errors in the parameters, an error message will be displayed, so please check the connection details again.

Once created successfully, you can retrieve the connector name from the list display. The string next to the icon is connection_name. You can use this to connect to the database in your code.

Enter the created connector name in your SQL or Python code to retrieve data.

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name

Run the morph init command to save the DB connection information in ~/.morph/connections.yml.

morph init

pip install morph-data

An interactive interface will display a list of database types, select SQLServer.

Select your database type:
1. PostgreSQL
2. MySQL
3. Redshift
4. SQLServer
5. Snowflake (User/Password)
6. BigQuery (Service Account)
Enter the number corresponding to your database type: 4

SQLServer selected.

Next, enter the database credentials. slug is treated as the connector name, which you will specify in SQL or Python.

Replace the following input examples with actual values that can connect.

Create a slug for your connection: sqlserver-connection
Enter your SQLServer host (default: localhost): localhost
Enter your SQLServer username: your_user_name
Enter your SQLServer password: your_password
Enter your SQLServer port (default: 1433): 1433
Enter your SQLServer database name: your_database_name
Enter your SQLServer schema name (default: public): public
Select if you are using SSH tunneling (y/n): n

Once the credentials are saved, the following message will be displayed.

Successfully initialized! 🎉
You can edit your connection details in `path_to_connections.yml`

connections.yml is saved as follows. If you create other connectors, they will be added under connections.

cat ~/.morph/connections.yml

connections:
  sqlserver-connection: # Connector name
    dbname: your_database_name
    host: localhost
    password: your_password
    port: 1433
    schema_: public
    ssh_host: null
    ssh_password: null
    ssh_port: null
    ssh_private_key: null
    ssh_user: null
    type: mssql # Fixed
    user: your_user_name

Enter the created connector name in your SQL or Python code to retrieve data.

{{
    config(
        connection="connection_name"
    )
}}

select * from table_name