![]() Metabase supports a lot of different databases, and ships with a Sample Database for you to play around with. Metabase also makes it easy to share questions and dashboards with the rest of your team.Īt a high level, we’ll walk through the features that let you: You can save your questions, and group questions into handsome dashboards. Metabase lets you ask questions about your data, and displays answers in formats that make sense, whether that’s a bar chart or a detailed table. Metabase is an open-source business intelligence tool. The Metabase home page.īut first, what is Metabase? What is Metabase? Metabase has a lot of tools in its toolkit (and we can’t cover everything here), but even seasoned Metabasers will benefit from a tour of its feature set - especially since we add major new features at a regular clip. This is the “what comes in the box when you install Metabase” article. Group permissions for data and collections.Create models to use as starting data for new questions.The console will print out the tables that are loaded as well as total time to complete. Load employees.sql into the metabase_example database and enter the database user password when prompted: mysql -u metabase_user -p employees < employees.sql Navigate into the cloned repository: cd test_db The database consists of employee and salary data with over 2.8 million entries, this size makes it useful for experimenting in a non-trivial way.Ĭlone the repository containing the test database: git clone The Employees Testing Database is an example database that can be loaded into MySQL. Restart NGINX: sudo systemctl restart nginx Verify there are no issues with the configuration: sudo nginx -t ![]() Move the file into /var so that it can start on reboot: sudo mv metabase.jar /var/metabase.jarĬreate a new NGINX configuration file with the settings below setting server_name with your FDQN or public IP address: GRANT ALL PRIVILEGES ON employees.* TO 'metabase_user' ĭownload the jar file from Metabase: wget Log in as the root user: mysql -u root -pĬreate a database and user for Metabase: CREATE DATABASE employees ĬREATE USER 'metabase_user' IDENTIFIED BY 'password' Enter a root password when specified: sudo apt install mysql-server Install the Java JDK 8: sudo apt-get install oracle-java8-installerĭownload MySQL Server. Update the source list: sudo apt-get update Install software-properties-common to easily add new repositories: sudo apt-get install software-properties-commonĪdd the Java PPA: sudo add-apt-repository ppa:webupd8team/java For other distributions, see the official docs. ![]() The steps in this section will install the Java 8 JDK on Ubuntu 16.04. Install Metabase Java Runtime Environment This makes Metabase versatile for sharing data even among those without an analytical background. Visualizing results become very simple through an intuitive interface. There are a number of additional databases that are supported from SQLite to PostgreSQL. This guide shows how to connect MySQL to Metabase then deploy on NGINX through a reverse proxy. In addition to supporting SQL querying, Metabase offers functionality to analyze data without SQL, create dashboards, and track metrics. Metabase provides an interface to query data on your browser.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |