Connecting to database
Enable the Database tools and SQL plugin
This functionality relies on the Database tools and SQL plugin, which is bundled and enabled in DataSpell by default. If the relevant features aren't available, make sure that you didn't disable the plugin.
Press Ctrl+Alt+S to open the IDE settings and select.
Open the Installed tab, find the Database tools and SQL plugin, and select the checkbox next to the plugin name.
To issue a query to a database, you must create a data source connection. Data source is the location of your data and can be a server or a DDL file. The data source includes a name and connection settings that are dependent on the data source type.
Select a data source that you want to create. DataSpell provides a complete support for the following database vendors:
- Amazon Redshift
- Apache Cassandra
- Apache Derby
- Apache Hive
- Azure SQL Database
- Couchbase Query
- IBM Db2 LUW
- Microsoft SQL Server
- Sybase ASE
Complete support of a database vendor includes such features as enhanced code completion and better retrieval of database objects (introspection). All the inspections, quick-fixes, and other code assistance features are also available. Whereas a basic support has limited features available.
For more information on the support types, refer to the Other databases topic.
For the database vendors listed below, a basic support is provided:
Google Cloud Spanner