How do I connect to Pipeline Cloud using command line?

Before you begin

Make sure you've completed the Pipeline Cloud initial setup and have SQLCMD version 15.02 or higher installed on your Windows PC.

Step 1: Prepare your command

1. Open a command prompt or terminal window
2. Use the SQLCMD syntax with the following parameters:
   1. -S for server name
   2. -d for database name
   3. -U for username (your email)
   4. -G to enable interactive authentication
   5. -q for your query

Step 2: Execute your command

1. Enter your complete command following this format:

Sqlcmd -S [your_server_name] -d [your_database_name] -G -U [your_email] -q "your SQL query;"
 

2. For example:

Sqlcmd -S esv30ddbms001.database.windows.net -d TestDb02 -G -U your.email@example.com -q "select top 10 VanID from dbo.Contacts;"
 

3. Follow the authentication prompts that appear

Not quite what you were searching for?

• Navigate back to Pipeline Cloud Resource Index.