CODEWITHSUNDEEP
sql-serverprestotrino
Dmitrij Kultasev
Dmitrij Kultasev

Reputation: 5787

How to specify database for SQL Server catalog in Presto?

I specified following catalog for SQL Server

connector.name=sqlserver
connection-url=jdbc:sqlserver://192.168.1.1
connection-user=build_agent
connection-password=build_agent

When I try running queries against it, it seems that I can access master database only. How can I specify specific database?

Upvotes: 1

Views: 979

Answers (1)

Piotr Findeisen
Piotr Findeisen

Reputation: 20770

From Trino (formerly Presto SQL) SQL Server connector documentation (https://trino.io/docs/current/connector/sqlserver.html):

connection-url=jdbc:sqlserver://<host>:<port>;database=<database>

Upvotes: 3

Related Questions