Code Monkey home page Code Monkey logo

metabase-firebolt-driver's Introduction

Metabase Firebolt Driver

Installation

Beginning with Metabase 0.32, drivers must be stored in a plugins directory in the same directory where metabase.jar is, or you can specify the directory by setting the environment variable MB_PLUGINS_DIR. There are a few options to get up and running with a custom driver.

Download Metabase Jar and Run

  1. Download a fairly recent Metabase binary release (jar file) from the Metabase distribution page.
  2. Download the Firebolt driver jar from the "Firebolt Driver".
  3. Download the firebolt jdbc driver jar from the "Firebolt JDBC Driver".
  4. Create a directory and copy the metabase.jar to it.
  5. In that directory create a sub-directory called plugins.
  6. Copy the Firebolt driver jar and Firebolt jdbc driver jar to the plugins directory.
  7. Make sure you are the in the directory where your metabase.jar lives.
  8. Run java -jar metabase.jar.

In either case, you should see a message on startup similar to:

04-15 06:14:08 DEBUG plugins.lazy-loaded-driver :: Registering lazy loading driver :firebolt...
04-15 06:14:08 INFO driver.impl :: Registered driver :firebolt (parents: [:sql-jdbc]) ๐Ÿšš

Configuring

  1. Once you've started up Metabase, open http://localhost:3000 , go to add a database and select "Firebolt".
  2. You'll need to provide the Database Name, Username and Password.

Prerequisites

Build from source

  1. Clone and build metabase dependency jar.

    git clone https://github.com/metabase/metabase
    cd metabase
    clojure -X:deps prep
    cd modules/drivers
    clojure -X:deps prep
    cd ../..
    clojure -T:build uberjar
  2. Clone metabase-firebolt-driver repo

    cd modules/drivers
    git clone https://github.com/firebolt-db/metabase-firebolt-driver
  3. Download Firebolt jdbc driver from the Firebolt generic jdbc driver and paste it in metabase-firebolt-driver directory to make a local maven repo.

    cp ../../target/uberjar/metabase.jar metabase-firebolt-driver/
    cd metabase-firebolt-driver
    mkdir repo
    mvn deploy:deploy-file -Durl=file:repo -DgroupId=com.firebolt -DartifactId=metabase-core -Dversion=1.40 -Dpackaging=jar -Dfile=metabase.jar
    mvn deploy:deploy-file -Durl=file:repo -DgroupId=com.firebolt -DartifactId=firebolt-jdbc -Dversion=1.0.0 -Dpackaging=jar -Dfile=firebolt-jdbc-1.18-jar-with-dependencies.jar
  4. Build the jar

    LEIN_SNAPSHOTS_IN_RELEASE=true DEBUG=1 lein uberjar
  5. Let's assume we download metabase.jar from the Metabase jar to ~/metabase/ and we built the project above. Copy the built jar and also Firebolt generic jdbc driver jar to the Metabase plugins directly and run Metabase from there!

    cd ~/metabase/
    java -jar metabase.jar

You should see a message on startup similar to:

2019-05-07 23:27:32 INFO plugins.lazy-loaded-driver :: Registering lazy loading driver :firebolt...
2019-05-07 23:27:32 INFO metabase.driver :: Registered driver :firebolt (parents: #{:sql-jdbc}) ๐Ÿšš

metabase-firebolt-driver's People

Contributors

ptiurin avatar ranjanasigmoid avatar kevinmarr avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.