Skip to main content
Insights is the SQL workbench for your ledger history. On a managed Sandbox or Production instance, it reads the instance data lake, a stored copy of your ledgers, balances, transactions, and identities. Use it to report on volume, status mix, wallets, and identities. To call the same lake SQL from your backend, use Create new query.

​
Open Insights

1

Open Insights

Navigate to the side navigation and open Insights.
Note: Make sure you’re in the right instance where you want to query the lake. If you’re not sure, you can confirm by checking the active instance in the top right corner of your screen.
2

Start a query

Click New query to open a blank SQL editor. Until you save, the draft is named Untitled lake query.The left sidebar has three tabs:
  • Queries: reopen Saved queries, manage Scheduled runs, and check History.
  • Schema: browse the tables and columns you can query.
  • Templates: open a starter query and edit it for the report you need.
Insights workbench after New query, with Untitled lake query and the Queries tab open
3

Set the range, run, and save

Pick start and end dates in the toolbar. Keep the range as tight as the question allows. See How the lake works for why the date range matters.Write a SELECT or WITH query, or paste a template. Click Run (or ⌘ Enter / Ctrl Enter). Results can be a Table or a Chart. Click Save if you want it on the instance. For schedules and history, see Queries.Set the date range, run a query, then save it from Actions

​
Need help?

We are very happy to help you make the most of Blnk, regardless of whether it is your first time or you are switching from another tool. To ask questions or discuss issues, please contact us or join our Discord community.