Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a development environment in Paradime, SQL Server enables dbt™️ development from Paradime's Code IDE.

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

Setup Instructions

  1. Click the gear Icon (⚙️) on the top right of the Paradime interface to access Account Settings

  2. In the left sidebar, click "Connections"

  3. Click "Add New" next to the Code IDE section

  4. Select "SQL Server"

  5. In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section.

driver: 'ODBC Driver 18 for SQL Server'     # ODBC Driver 18 for SQL Server
server: sql.company.com                     # Hostname or IP address
port: 1433                                  # Default: 1433
database: analytics_db                      # Name of the database
user: sql_user                              # SQL Server username
password: your_password                     # SQL Server password

After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.

  1. Provide a dbt™ Profile Name (This should match with the profile name set in your dbt_project.yml).

  2. In the Target field, enter "dev". This is the default target your dbt project will use for development work.

  3. The "Schema" field is pre-configured, but you can change it to specify the schema where dbt will build objects.

  4. The "Threads" value is pre-configured to 1, but you can adjust this number to specify how many parallel operations your dbt project can run.


Example Profile Configuration


Profile Fields Reference

Field
Description
Example
Default Value
Required

driver

OBDC driver

ODBC Driver 18 for SQL Server

ODBC Driver 18 for SQL Server

server

Server hostname or IP

sql.company.com

None

port

Server port number

1433

1433

database

Database name

analytics_db

None

schema

Schema name. This is configured in the UI "Schema" field

dbo

None

user

Authentication username

sql_user

None

password

Authentication password

your_password

None

retries

Number of query retry attempts

3

1

encrypt

Enable connection encryption

true

true

trust_cert

Trust server certificate

false

false

login_timeout

Connection timeout in seconds

10

0

query_timeout

Query timeout in seconds

300

0

schema_authorization

Schema owner principal

db_owner

None

Last updated