bicortex

  • Home
  • {RSS}

Posts Tagged ‘SQL’

Data Build Tool (DBT) – The Emerging Standard For Building SQL-First Data Transformation Pipelines – Part 2

January 20th, 2023 / 4 Comments » / by admin

Posted in Cloud Computing, Data Mining, Programming, SQL | 4 Comments »

Building rapid data import interfaces with PySimpleGUI and Streamlit

December 5th, 2022 / 3 Comments » / by admin

Posted in GUI, Programming, SQL | 3 Comments »

« Older Entries
Newer Entries »

What you are looking at...

My name is Martin and this site is a random collection of recipes and reflections about various topics covering information management, data engineering, machine learning, business intelligence and visualisation plus everything else that I fancy to categorise under the 'analytics' umbrella. I'm a native of Poland but since my university days I have lived in Melbourne, Australia and worked as a DBA, developer, data architect, technical lead and team manager. My main interests lie in both, helping clients in technical aspects of information management e.g. data modelling, systems architecture, cloud deployments as well as business-oriented strategies e.g. enterprise data solutions project management, data governance and stewardship, data security and privacy or data monetisation. On the whole, I am very fond of anything closely or remotely related to data and as long as it can be represented as a string of ones and zeros and then analysed and visualised, you've got my attention!

Outside sporadic updates to this site I typically find myself fiddling with data, spending time with my kids or a good book, the gym or watching a good movie while eating Polish sausage with Zubrowka (best served on rocks with apple juice and a lime twist). Please read on and if you find these posts of any interests, don't hesitate to leave me a comment!

Subscribe

Subscribe via RSS | Comments (RSS)

Or, subscribe via email:  

Advertising


    1. admin on Protecting PHI & PII data at Scale with LLMs using Snowflake, LangGraph and Streamlit for Human-in-the-Loop QAMay 18, 2026

      Ahh, yes, the Streamlit app, as implemented in the current codebase, is using Snowflake for inference but is designed for…

    2. Do Ho on Protecting PHI & PII data at Scale with LLMs using Snowflake, LangGraph and Streamlit for Human-in-the-Loop QAMay 16, 2026

      Hi Martin I looked at the code you provided but it seems the Streamlit app can only run on a…

    3. José Fernández on Snowflake Scale-Out Metadata-Driven Ingestion Framework (Snowpark, JDBC, Python)February 2, 2026

      Great post Martin and I found that the source code worked well. My company was about procure and deploy an…

    4. admin on Snowflake Scale-Out Metadata-Driven Ingestion Framework (Snowpark, JDBC, Python)January 7, 2026

      The answer is definitely yes, providing you find a compatible JDBC driver and adjust catalog queries for metadata extraction to…

    5. Huo Wang on Snowflake Scale-Out Metadata-Driven Ingestion Framework (Snowpark, JDBC, Python)January 7, 2026

      Nice post Martin. I was wondering if this can be used with other database vendors like MySQL, but since it’s…

  • Tags

    SQL68SQL Server37Python29This-and-That26Code23Programming22SSIS22Cloud Computing20Big Data15MPP RDBMS15Analytics14Azure14Microsoft12Data Modelling12Data Warehouse10Data10Visualisation8Social Networks5Tableau5SSAS5.NET5Amazon Redshift5ETL4SSRS4Vertica4Snowflake4C#4Data Mining4NoSQL4MongoDB4Excel3DuckDB3Azure Functions3AWS3OLAP2Streamlit2BigQuery2Serverless2dbt2GCP2Artificial Intelligence2Machine Learning2IBM Watson2RapidMiner2VB.NET2PowerView2T-SQL1Azure Logic App1ClickHouse1Polybase1Snowpark1LLM1Unit Testing1Hadoop1GUI1Airflow1Pandas1Dask1SAP1Self-service BI1SharePoint1

bicortex is proudly powered by WordPress | Firebug Theme by Blog Oh! Blog

Valid CSS! Valid XHTML 1.0 Transitional