vincentkoc

Cleanup Redash Queries (Housekeeping)

Use the following clean-up scripts to help locate redundant queries, widgets, dashboards and alerts within Redash. This was mostly to keep lineage lean and reduce discovery of redundant reports and data:

• locate_expired_assets.sql - Finds expired queries and other assets downstream from that query
• locate_expired_dashboards.sql - Finds unused dashboards older than 1 year
• locate_expired_alerts.sql - Finds unused alerts not executed older than 1 year
• locate_expired_users.sql - Finds unused users not logged older than 90 days
• locate_insecure_tokens.sql - Finds API tokens older than 90 days still in use
• locate_orphaned_connections.sql - Finds orphaned data connections with no queries

vincentkoc

/*

GA4 Attribution Model

This query is designed to replicate the old Universal Analytics attribution
model in Google Analytics 4 (GA4). It calculates the source, medium,
campaign, and event rank for each user based on their events. It also retrieves
purchase data and joins it with the first events to attribute the purchase
to a specific source, medium, and campaign.

vincentkoc

You are a document to graph generation assistant. You task is to meticulously take some high level concepts, entities and summary of a research paper in JSON and convert this into a graph.

• You will respond back only in JSON with nodes and edges
• You will take a JSON of entities, summary and arguments for a given research paper and convert into a graph to better understand the relationship of the ideas
• You will breakdown larger terms into smaller ideas where possible
• You will ensure that all the nodes and edges are connected, if not you will connect them
• If you are still unable to connect all the nodes and edges, you will connect these to the core/main idea
• You will not make assumptions and only stick to the information provided

Please be critical and discerning in your evaluations.

vincentkoc

Buy Me a Coffee

This is unsing the "smaller" style of sheilds.io which most developers like to use.

Using inlined HTML

<a href="https://www.buymeacoffee.com/koconderi" target="_blank"><img src="https://img.shields.io/badge/-buy_me_a%C2%A0coffee-gray?logo=buy-me-a-coffee" alt="Buy Me A Coffee"></a>

vincentkoc

UQ Agentic Workflow Masterclass

These resources are compiled for use as part of the Agentic workflow masterclass ran at University of Queensland.

vincentkoc

# azure-pipeline.yaml
trigger:
  paths:
    - 'flows/**/*.json'    # Properly escaped pattern for JSON files
    - 'flows/**/*.flow'    # In case you use .flow extension

variables:
  FLOWISE_API_KEY: $(FLOWISE_API_KEY)
  AZURE_STORAGE_CONNECTION_STRING: $(AZURE_STORAGE_CONNECTION_STRING)
  CONTAINER_NAME: 'flowise-flows'