![]() ![]() However, this process is extremely redundant and inefficient, with the use of many intermediate tools.Īnother method is to use a cloud-based data management platform, such as Acho. Metabase can then access your data through the BigQuery data warehouse. For example, you can import a CSV file into Google Sheets and connect it with BigQuery. The first is to load your data into a database. There are currently two methods to read data from other sources on Metabase. ![]() You cannot import data from other sources to Metabase, such as from third-party apps or CSV files. However, it only supports databases at the moment. In addition to being an affordable, open-source software, it offers a user-friendly and intuitive interface that allows anyone to create a dashboard. You can also configure Google OAuth to make the login easier, however that’s out of scope in this article.Metabase is quickly becoming one of the more popular business intelligence tools in recent years. Once deployed, use your tunnel URL to access it. whr -metabase # <- if you have chosen a different name for the tunnel, change it here too env : - name : RELAY_KEY Image : webhookrelay/webhookrelayd : 1 args : -mode name : MB_REDIRECT_ALL_REQUESTS_TO_HTTPS Volumes : - /data/metabase :/metabase -data Last step is to create a Synpse application. Go to the secrets page in Synpse and create both relayKey and relaySecret secrets: Save the key and secret before closing the window. Head to the tokens page here and create a new pair. destination: ‘ (metabase is reachable using container’s name).name: ‘whr-metabase’ ( webhookrelayd agent will need to know which tunnel to use).Go to your page and create a new tunnel with these details: For this, we are creating a Webhook Relay tunnel that will be established by a webhookrelayd container. Our Metabase deployment will need to be reachable from outside so we can actually view reports. Create a Webhook Relay tunnel for your Metabase app Once you run the command, after a few seconds (depends on your internet speed) you should see the magic happen and device appear in your “Devices” page in Synpse :) 2. There are multiple ways to do it however initially you can just SSH into the machine via local network. From there you will be able to find the auto-generated command that you need to run on the device to add it to your project. Once you log into Synpse Cloud, select your project and then head to the “Devices” page. Offers management of up to 5 devices for free.ġ. Synpse account - a lightweight and fantastic platform to manage and run software on your own hardware.Webhook Relay account - will be used to expose the Metabase to the internet, so we can access it.In this article, we will use a setup that works exactly the same way on both an Intel NUC (for some of my projects) and on a large VM that is managed by a VMware. When paired with the right technologies, this setup becomes trivial to anything from a small organization to a big company. I personally am a fan of Metabase as it is the easiest to deploy and use. It is always useful to know how your business or projects are doing and for that, there are a bunch of tools available such as Excel spreadsheets, Google DataStudio, Apache Superset, etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |