Microsoft SQL Server

​

Add credentials

1. Create a new pipeline or open an existing pipeline.
2. Expand the left side of your screen to view the file browser.
3. Scroll down and click on a file named io_config.yaml.
4. Enter the following keys and values under the key named default (you can have multiple profiles, add it under whichever is relevant to you)

version: 0.1.1
default:
  MSSQL_DATABASE: database
  MSSQL_SCHEMA: schema
  MSSQL_DRIVER: "ODBC Driver 18 for SQL Server"
  MSSQL_HOST: host
  MSSQL_PASSWORD: password
  MSSQL_PORT: 1433
  MSSQL_USER: SA

​

Using SQL block

1. Create a new pipeline or open an existing pipeline.
2. Add a data loader, transformer, or data exporter block.
3. Select SQL.
4. Under the Data provider/Connection dropdown, select Microsoft SQL Server.
5. Under the Profile dropdown, select default (or the profile you added credentials underneath).
6. Enter the schema and optional table name of the table to write to.
7. Under the Write policy dropdown, select Replace or Append (please see SQL blocks guide for more information on write policies).
8. Enter in this test query: SELECT 1.
9. Run the block.