Welcome to GovSocket

Build polished data products with SQL and Markdown

This demo connects to a local DuckDB file needful_things.duckdb.

Write in Markdown

Run SQL using Code Fences

In your markdown file, you can include SQL queries in code fences.

To see the queries on a page, click the 3-dot menu at the top right of the page and Show Queries. You can see both the SQL and the query results by interacting with the query above.

Visualize Data with Components

Value in Text

Last month customers placed error 'number_of_orders' is not a column in the dataset orders. The AOV was error 'average_order_value' is not a column in the dataset.

Big Value

'sales' is not a column in the dataset

Big Value

'number_of_orders' is not a column in the dataset

Bar Chart

'number_of_orders' is not a column in the dataset

Try: Change the chart to a <LineChart>.

Data Table

Created Month	Plugin Logs
2024-01-01	8
2023-11-01	3,438
2023-12-01	6,375

No Results