(Optional) Initial SQL statement to run every time Tableau connects Name of the server that hosts the database you want to connect to Before you beginīefore you begin, gather this connection information: To a MySQL database and set up the data source. Please feel free to reach out if you want additional support for an editor not listed in this document in our discord channel.This article describes how to connect Tableau Our long term goal is full MySQL dialect and wire protocol compatibility which will mean Dolt can fit anywhere MySQL can, enabling the broadest possible set of use-cases across data science, data engineering, and applications.įor a full list of compatible editors see here. In this blog we showed how to connect TablePlus to Dolt SQL Server. You can go the Tableplus website to see more features. If you select the circled button below you should see a view like this. Hit connect and your editor is now all setup with Dolt. Set the user to root and leave the password empty. Set the name to Dolt Server and put the host to 127.0.0.1 and port to 3306 as per the config. Opening up Tableplus and click the "Create a New Connection Option" and select the MySQL Option. Certain editors will connect with multiple connections so if we leave this at its default value (1) we'll see hanging from the application side. The important parameter here is max_connection parameter. We also turned autocommit on meaning that each query can execute insert and update statements.įinally, in the listener section set host, port, the number of concurrent connections allowed as well as some timeouts. In the behavior section we can see that we've set read_only to false indicating that we can write queries to that affect that database state. So if any query doesn't work you can send it to us to fix. This will be pretty valuable for the Dolt team as our compatibility with these editors is still a little early. In this case we'll log at level trace meaning will print each query and its output. The log_level indicates the type of logging dolt's sql-server will do. Password : "" listener : host : localhost Behavior : read_only : false autocommit : true user : name : root
0 kommentar(er)
