Load Data with Liquibase

Prerequisites

• A SingleStoreDB cluster running SingleStoreDB version 8.1 or later.

• Download the SingleStore JDBC driver .jar file.

• Download the Liquibase extension for SingleStoreDB.

• Install Liquibase.

Connect with Liquibase from SingleStoreDB

To connect to your SingleStoreDB database with Liquibase,

1. Run the following command to initialize a new Liquibase project:

   Shell

   Copy

   liquibase init project

   You may use the default properties or customize the available parameters while initializing a new project. In this guide, we'll use liquibase.properties as the defaults file.

2. Place the downloaded SingleStore JDBC driver and Liquibase extension for SingleStoreDB .jar files in the liquibase/lib directory. If you are using Maven, add the following dependencies to your pom.xml file:

   XML

   Copy

   <dependency>
       <groupId>com.singlestore</groupId>
       <artifactId>singlestore-jdbc-client</artifactId>
       <version>1.1.5</version>
   </dependency>
   <dependency>
       <groupId>org.liquibase.ext</groupId>
       <artifactId>liquibase-singlestore</artifactId>
       <version>1.0.0</version>
   </dependency> 

3. Customize the following parameters in the liquibase.properties file:

   • url: Specify the connection string for your SingleStoreDB database in the following format: jdbc:singlestore://<hostname>:<port>/<database>.

   • username: Specify the username of the SingleStoreDB database user that is used to access the database.

   • password: Specify the password for the SingleStoreDB database user.

   • driver: Specify the JDBC Driver Class as com.singlestore.jdbc.Driver.

   • classpath: Specify the path to the downloaded SingleStore JDBC driver .jar file, including the filename and the .jar extension.

   Here's a sample liquibase.properties file:

   Copy

   url:jdbc:singlestore://svchost:3306/dbTest
   username:s2user
   password:pa55w0rd
   liquibaseProLicenseKey: licensekey
   liquibase.hub.APIKey: APIKey
   driver:com.singlestore.jdbc.Driver
   classpath=~/singlestore-jdbc-client-1.1.5.jar

4. Update the changelog file in your project, and add a changeset. In this guide we'll use the following changelog.sql file:

   SQL

   Copy

   -- liquibase formatted sql
   
   -- changeset admin:1
   CREATE TABLE Stock (ID INT, Code VARCHAR(4), PRIMARY KEY(ID))

5. Run the following command from the Liquibase installation directory:

   Shell

   Copy

   liquibase status --changelog-file=changelog.sql

   --
   Liquibase command 'status' was executed successfully.

   For a successful connection, the output contains a similar message.

Refer to Using Liquibase with SingleStoreDB for more information.