Mage AI home pagelight logodark logo
  • GitHub
  • Community
  • Mage Pro
  • Get a demo
  • Get a demo
Documentation
Development
Production
AI
Observability
Integrations
Extensibility
Quickstart
  • Guides
  • Tips & tricks
Developer experience
  • Code editor
  • Dependency tree
  • Pipeline dependencies
  • Pipeline canvas
  • File browser
  • Code browser
  • Sidekick
  • Personalize
  • Workspaces
  • Visual Studio Code
Version control
  • Version control guide
  • Configurations
  • Git application
  • Git sync
  • Git terminal
  • Git integration
  • File versioning
Blocks
  • Reorder
  • Detach
  • Dynamic
  • Dynamic blocks 2.0
  • Batch read/write
  • Polars
  • Replicate
  • Transformers
  • Custom
  • Markdown
  • SQL
  • R
Pipelines
  • Batch
  • Data integration
  • Streaming
    • Overview
    • Sources
    • Destinations
      • ActiveMQ
      • Amazon S3
      • BigQuery
      • ClickHouse
      • DuckDB
      • Dummy
      • Elasticsearch
      • Google Cloud PubSub
      • Google Cloud Storage
      • InfluxDB
      • Kafka
      • Kinesis
      • MongoDB
      • Microsoft SQL Server
      • MySQL
      • Opensearch
      • Oracle Database
      • Postgres
      • RabbitMQ
      • Redshift
      • Snowflake
      • Trino
    • Tutorials
  • Importing
  • Community Examples
dbt
  • Overview
  • Getting started
  • New project
  • Configuration
  • Models
  • Commands
Destinations

Microsoft SQL Server

​
Basic config

connector_type: mssql
profile: default    # profile in the io_config.yaml
config:
  table_name: table_name

​
Optional fields

schema_name: schema_name    # Override the schema name. Default schema is "dbo"

Was this page helpful?

Suggest editsRaise issue
MongoDBMySQL
On this page
  • Basic config
  • Optional fields
Mage AI home pagelight logodark logo
githubslacklinkedintwitter

OSS

CodeDemo playground

Mage Pro

Get started for free

Community

ChatFacebookYoutubeInstagramMedium
githubslacklinkedintwitter
Powered by Mintlify
Assistant
Responses are generated using AI and may contain mistakes.