Getting started with Visual Studio 2019 for SQL Data Warehouse

Visual Studio 2019 SQL Server Data Tools (SSDT) is a single tool allowing you to do the following:

  • Connect, query, and develop applications for SQL Data Warehouse
  • Leverage an object explorer to visually explore all objects in your data model including tables, views, stored procedures, and etc.
  • Generate T-SQL data definition language (DDL) scripts for your objects
  • Develop your data warehouse using a state-based approach with SSDT Database Projects
  • Integrate your database project with source control systems such as Git with Azure DevOps Repos
  • Set up continuous integration and deployment pipelines with automation servers such as Azure DevOps [Coming soon]

Note

Currently Visual Studio SSDT Database Projects is in preview. To receive periodic updates on this feature, please vote on UserVoice.

Install Visual Studio 2019 Preview

See Download Visual Studio 2019 Preview to download and install Visual Studio. During install, select the data storage and processing workload. Standalone SSDT installation is no longer required in Visual Studio 2019.

Reporting issues with SSDT Visual Studio 2019 (preview)

To report issues when using SSDT with SQL Data Warehouse, email the following email distribution list: sqldwssdtpreview@service.microsoft.com

Next steps

Now that you have the latest version of SSDT, you're ready to connect to your SQL Data Warehouse.