dbt-utils
streamlit
dbt-utils | streamlit | |
---|---|---|
7 | 258 | |
1,206 | 31,868 | |
1.7% | 2.0% | |
6.2 | 9.8 | |
10 days ago | about 17 hours ago | |
Python | Python | |
Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
dbt-utils
-
Show HN: Nasty, a cross warehouse, type checked, unit testable analytics library
// To get around this, we can use the approach outlined by how dbt does ansi sql generate_series
// https://github.com/dbt-labs/dbt-utils/blob/main/macros/sql/generate_series.sql
-
Anything one should know before going for self-hosted dbt?
I got bit by dbt-utils/deduplicate naively removing any row that contained a null in it recently, but fortunately there was a workaround for Databricks and a few other flavors of SQL.
-
Managing SQL Tests
I'm used to utilising dbt and defining my tests there (along with dbt-utils or https://github.com/calogica/dbt-expectations): I simply add a list item to a column definition and can already define a great number of tests without having to copy code. I can even extend the pre-defined using generic tests. Writing custom tests also integrates nicely. Additionally it's very convenient to tag tests or define a severity. The learning curve for a business engineer is almost flat as long as they know some SQL.
-
Dbt to acquire Transform to build out its semantic layer
My top three:
- Dev/stag/prod env check numbers before pushing to production.
- Unions between two sources that are not the same shape can be done without the headache. https://github.com/dbt-labs/dbt-utils#union_relations-source
- Macros for common case when statements.
-
Analytics Stacks for Startups
Add tests: unit tests in SQL are still not really practical, but testing the data, before allowing users to see it, is possible. dbt has some basic tests like Non-NULL and so on. dbt_utils supports comparing data across tables. If you need more, there is Great Expectation and similar tools. dbt also supports writing SQL queries which output “bad” rows. Use this to, e.g. check a specific order against manually checked correct data. Tests give you confidence that your pipelines produce correct results: nothing is worse than waking up with a Slack message from your boss that the graphs look wrong… They are especially useful in case you have to refactor a data pipeline. Basically every query you would run during the QA phase of a change request has a high potential to become an automatic test.
- Why is Data Build Tool (DBT) is so popular? What are some other alternatives?
-
Unit testing SQL in DBT
The equality test macro is also in the dbt-utils package from fishtown at https://github.com/fishtown-analytics/dbt-utils/blob/master/macros/schema_tests/equality.sql
streamlit
-
Developing a Generic Streamlit UI to Test Amazon Bedrock Agents
I decided to use Streamlit to build the UI as it is a popular and fitting choice. Streamlit is an open-source Python library used for building interactive web applications specially for AI and data applications. Since the application code is written only in Python, it is easy to learn and build with.
-
Creando Subtítulos Automáticos para Vídeos con Python, Faster-Whisper, FFmpeg, Streamlit, Pillow
Streamlit (https://streamlit.io/)
-
PySheets – Spreadsheet UI for Python
Does it need to be live (i.e when database or underlying spreadsheet updates does it need to be reflected in real time on the dashboard) or are you ok with static display.
Live updating data is a pain I've messed around using javascript to force refresh html iframes on a timer. But I was never really satisfied with this. I've heard you can do things with websockets but that is starting to get too complicated for me (I'm not a programmer).
For static stuff one of the data scientists in my org pointed me to Streamlit (https://streamlit.io/) it's a python package I found very easy to use. Can easily combine SQL with CSV imports and display them all on one dashboard. Can use forms toggle butotns etc to control the display.
-
Building an Email Assistant Application with Burr
Note that there are many tools that make this easier/simpler to prototype, including chainlit, streamlit, etc… The backend API we built is amenable to interacting with them as well.
-
Creating a Sales Analysis Application with Streamlit: A Practical Approach to Business Intelligence
2.-Go to https://streamlit.io, log in, and create a new app from your GitHub repository.
-
🦙 Llama-2-GGML-CSV-Chatbot 🤖
Developed using Langchain and Streamlit technologies for enhanced performance.
-
Python dev considering Electron vs. Kivy for desktop app UI
Hello,
Have you ever seen the https://streamlit.io/ ? I think this is what you are looking for.
-
Show HN: Buefy Web Components for Streamlit
While building dashboards in Streamlit, I found myself really missing Buefy's (Bulma) modern web components.
Specially due to the inability to add new values to Streamlit's multiselect [1], some missing controls like a polished image carousel [2] or a highly customizable data table.
Long story short, we put together streamfy (Streamlit + Buefy) as an MIT licensed project in GitHub to bring Buefy to Streamlit.
Demo: https://streamfy.streamlit.app
All the form components are implemented, missing half of other non-form UX components. There is plenty of room for PRs, testing, feedback, documentation, example, etc.
Please send issues and contributions to GitHub project [3] and general feedback to X / Twitter [4]
Thanks!
[1] https://github.com/streamlit/streamlit/issues/5348
-
Simplify Web App Development: Code Lite, Create Big!
Here's your savior, let's welcome Streamlit.
-
Show HN: Hyperdiv – Reactive, immediate-mode web UI framework for Python
Looks cool. How do you see this differing from streamlit? https://streamlit.io/
What are some alternatives?
dbt-expectations - Port(ish) of Great Expectations to dbt test macros
PyWebIO - Write interactive web app in script way.
sqlfluff - A modular SQL linter and auto-formatter with support for multiple dialects and templated code.
gradio - Build and share delightful machine learning apps, all in Python. 🌟 Star to support our work!
dbt-oracle - A dbt adapter for oracle db backend
nicegui - Create web-based user interfaces with Python. The nice way.
nodejs-bigquery - Node.js client for Google Cloud BigQuery: A fast, economical and fully-managed enterprise data warehouse for large-scale data analytics.
superset - Apache Superset is a Data Visualization and Data Exploration Platform
reflex - 🕸️ Web apps in pure Python 🐍
PySimpleGUI - Python GUIs for Humans! PySimpleGUI is the top-rated Python application development environment. Launched in 2018 and actively developed, maintained, and supported in 2024. Transforms tkinter, Qt, WxPython, and Remi into a simple, intuitive, and fun experience for both hobbyists and expert users.
dash - Data Apps & Dashboards for Python. No JavaScript Required.
datapane - Build and share data reports in 100% Python