User Guide

Synapse-Databricks User Guide

Synapse-Databricks adds new Storm commands to allow you to query the Databricks API using your existing API credentials.

Getting Started

Check with your Admin to enable permissions and find out if you need personal API credentials.

Examples

Setting your personal API credentials

To set-up a personal use API key:

> databricks.setup.credentials pat --self https://myhost.databricks.com --warehouse 123 --token mytoken
Setting Databricks API credentials for scope=current-user.

Execute a query and print the results

> databricks.sql.execute "select * from `samples`.`nyctaxi`.`trips` limit 2"
statement_id=01ef2d0a-8a49-1127-8f56-f68535c4211d
['2016-02-14T16:52:13.000Z', '2016-02-14T17:16:04.000Z', '4.94', '19.0', '10282', '10171']
['2016-02-04T18:44:19.000Z', '2016-02-04T18:46:00.000Z', '0.28', '3.5', '10110', '10110']