Schema explorer and keyboard completion.Hopefully this will unlock all the presto possibilities for you! NOTE : make sure to use full url with jdbc protocol and portĮnter fullscreen mode Exit fullscreen mode If you're dealing with particularly large amount of tables, this step could take a while. The last step is particularly helpful if you presto is hosting multiple catalogs across database instances. select "All Databases" and also select "All Schemas". Right click on new Datasource->Database Tools->Manage Shown Schemas.Add the Datasource and use the Driver (and click "Test connection".).Pick the driver class (facebook or prestosql).Under the "Driver Files" box, click the + and browse to the downloaded jdbc jar.Enter "PrestoSQL" or "PrestoDB" in the name (whichever driver you chose.In "Database" panel click + or right click and select New -> "Driver".~/Library/Application\ Support/JetBrains/IntelliJIdea2020.2/jdbc-drivers/ So just click the link under "JDBC Driver" and download it. Trino, the rename of the fork PrestoSQL the fork of the project in the community PrestoDB, the original project by Facebook. I encourage folks to follow their releases for more critical information. Not surprisingly there is a JDBC driver for each and mostly they seem to be nearly identical, however at the time of writing, PrestoSQL's driver performed a bit faster for me. If you don't know by now, there's two forks of presto in the universe.
While it's not totally un-intuitive, many people trying to set it up might not see the options and give up. If you like ancient history, feel free to keep reading :) Happy coding! UPDATE - IntelliJ and DataGrip now have drivers for presto and trino right out of the oven, so no need to read on! So it should be totally well documented how to set it up with IntelliJ, right? Not so fast. Presto is a cool technology that works with everything (within reason).
0 kommentar(er)
